SQL queries to use with PostgreSQL to monitor current executing SQL commands

postgresql.sql

-- activity.sql

select procpid, query_start, current_query from pg_stat_activity WHERE current_query <> '<IDLE>' order by query_start


-- cancel.sql

select pg_cancel_backend(procpid)


-- index_stats.sql

select * from pg_stat_user_indexes where relname='table_name';