Difference between revisions of "Zabbix slow queries"
Jump to navigation
Jump to search
(Created page with "``` SELECT pid, user, pg_stat_activity.query_start, now() - pg_stat_activity.query_start AS query_time, query, state, wait_event_type, wait_event FROM pg_stat_...") |
(No difference)
|
Revision as of 17:47, 7 May 2022
SELECT pid, user, pg_stat_activity.query_start, now() - pg_stat_activity.query_start AS query_time, query, state, wait_event_type, wait_event FROM pg_stat_activity WHERE (now() - pg_stat_activity.query_start) > interval '2 minutes' and state != 'idle' order by backend_start limit 10;