/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 vote138 views1 answer
Connecting mySQL to STS
SQL
3 votes119 views1 answer
Oracle get trigger ddl
SQL
0 vote114 views1 answer
How to use group_concat in sql server
SQL
0 vote115 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote114 views1 answer
Sql query contains multiple ids
SQL
0 vote238 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
2 votes113 views1 answer
Add 2 hours to current time in MySQL
SQL
2 votes135 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote127 views2 answers
Dumping sql table
SQL
0 vote116 views1 answer
Python sql last insertend
SQL