/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

1 vote338 views1 answer
Postgres upgrade to superuser
SQL
1 vote183 views1 answer
Encrypt password postgresql
SQL
2 votes209 views3 answers
Postgres create view
SQL
0 vote178 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
11 votes173 views2 answers
Having clause
SQL
0 vote184 views1 answer
We are intrested to work with your organization
SQL
14 votes207 views1 answer
Excel
SQL
0 vote199 views1 answer
Regex mongoose
SQL
0 vote206 views1 answer
How to move a columns location in mysql
SQL
0 vote181 views1 answer
Mysql start of today
SQL