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;

Similar codes

1 vote197 views1 answer
Oracle sql create or replace view
SQL
0 vote198 views1 answer
SqlFunction does not exist
SQL
5 votes221 views1 answer
Oracle nls parameters
SQL
0 vote187 views1 answer
Update using case in mysql
SQL
1 vote206 views1 answer
Describe table in sql
SQL
2 votes223 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
3 votes196 views1 answer
Two select sql
SQL
5 votes252 views3 answers
Sql server utc to local
SQL
0 vote197 views1 answer
How to find username and password in oracle 18c
SQL
0 vote194 views1 answer
How to set sql_mode for a query in CI model
SQL