Sql

Search

postgresql find blocked query

select pid, 
       usename, 
       pg_blocking_pids(pid) as blocked_by, 
       query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql get actual fiscal year
Sql :: How To Rename Table Using MySQL RENAME TABLE Statement
Sql :: how to add more columns to a table in mysql
Sql :: inser into example
Sql :: grant select mysql
Sql :: select year from dual oracle
Sql :: procedure syntax
Sql :: if role exists sql
Sql :: mysql join same table multiple times group by
Sql :: sql server obtener nombre sin espacios en blanco
Sql :: order of execution in sql
Sql :: postgres drop all tables
Sql :: mysql get table column names and data types
Sql :: do block in postgresql
Sql :: cascade syntax in sql
Sql :: plsql find location of procedure
Sql :: delete from table where length sql
Sql :: codeigniter dbforge add index
Sql :: sqlalchemy default value for column
Sql :: convert Date to LocalDate via SQLDate
Sql :: sql constraint to check date less than current date
Sql :: Triggers Syntax
Sql :: rename view mysql
Sql :: Insufficient memory to excute the sql query
Sql :: how to create local postgres database
Sql :: sql select only row with the max date
Sql :: sql case sttement with set
Sql :: select in select sql
Sql :: Should I use the datetime or timestamp data type in MySQL?
Sql :: create domain sql

Search

SQL

postgresql find blocked query

ADD CONTENT