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

0 vote135 views1 answer
How to get table id sequence postgres
SQL
0 vote95 views1 answer
Lost connection to mysql
SQL
0 vote99 views1 answer
Mysql select all where count more than"
SQL
2 votes106 views3 answers
How to check current user in mySQL
SQL
0 vote101 views1 answer
Check if table exists oracle
SQL
36 votes121 views3 answers
Add column in mysq
SQL
0 vote110 views1 answer
Postgres clear table
SQL
0 vote112 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
11 votes100 views1 answer
Get ddl materialized view oracle
SQL
0 vote103 views1 answer
Services.AddDbContext DataSource Sqlite
SQL