/SQL/Postgresql get long running queries

Postgresql get long running queries

Postgres get running query

--Version > 9.2
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

Postgresql get long running queries

SELECT pid, age(clock_timestamp(), query_start), usename, query 

FROM pg_stat_activity 

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

ORDER BY query_start desc;

Similar codes

0 vote140 views1 answer
Sql list dates between two dates
SQL
0 vote156 views1 answer
How to get parent and child record in single query using sql
SQL
7 votes139 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote116 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote155 views1 answer
Sql_inner_join
SQL
0 vote144 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes127 views1 answer
Sql create database
SQL
1 vote142 views1 answer
Mysql query bulk insert
SQL
2 votes142 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
4 votes143 views2 answers
Bulk kill mysql processlist
SQL