Pinned

1. Useful PostgreSQL Queries and Commands Useful PostgreSQL Queries and Commands

   1

   -- show running queries (pre 9.2)

   2

   SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 

   3

   FROM pg_stat_activity 

   4

   WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 

   5

   ORDER BY query_start desc;