/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

4 votes332 views3 answers
Sql drop database if exists
SQL
2 votes329 views2 answers
Mysql alter column default
SQL
1 vote339 views1 answer
Mysql breakline on string
SQL
1 vote305 views1 answer
Ilike for date postgres
SQL
4 votes294 views1 answer
Update table from another table oracle
SQL
0 vote326 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
3 votes342 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote327 views1 answer
How to show index type in postgresql
SQL
10 votes318 views1 answer
Oracle object dependencies
SQL
11 votes341 views2 answers
How to import mysql database command line
SQL