Documentation
DrDroid Docs 2025
-- Basic SELECT SELECT column1, column2 FROM table_name WHERE condition LIMIT 100; -- JOIN example SELECT o.order_id, c.customer_name, o.order_date FROM orders o JOIN customers c ON o.customer_id = c.id WHERE o.status = 'shipped';
-- Check for long-running queries SELECT pid, now() - query_start AS duration, query FROM pg_stat_activity WHERE state != 'idle' AND now() - query_start > interval '5 minutes';
-- Find slow queries SELECT query, mean_exec_time, calls FROM pg_stat_statements ORDER BY mean_exec_time DESC LIMIT 10;