/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 vote269 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote267 views2 answers
Starting mysql service from mac
SQL
-1 vote231 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote268 views1 answer
Mysql return column names when table is empty
SQL
8 votes273 views2 answers
Change name of colum in sql table
SQL
0 vote253 views1 answer
Mysql group rows with same value
SQL
3 votes282 views2 answers
Sql paging query
SQL
0 vote291 views1 answer
Show the colums of table sql
SQL
0 vote250 views1 answer
Sql min
SQL
7 votes279 views2 answers
Mysql default value
SQL