Skip to content

Instantly share code, notes, and snippets.

@damon140

damon140/postgres_helpful_queries.sql

Last active November 29, 2018 07:14
Show Gist options
  • Save damon140/a38876a50a8626721f40b0e13207163b to your computer and use it in GitHub Desktop.
Save damon140/a38876a50a8626721f40b0e13207163b to your computer and use it in GitHub Desktop.
Download ZIP
Helpful PostgreSQL Queries
Raw
postgres_helpful_queries.sql
-- show running queries, oldest first (postgres 10.5)
SELECT pid, age(clock_timestamp(), query_start), usename, state, query
FROM pg_stat_activity
WHERE state != 'idle' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY age desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment