vw_status_locks

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

maquina

inet

2147483647

√

null

banco

name

2147483647

√

null

esquema

name

2147483647

√

null

tabela

name

2147483647

√

null

mode

text

2147483647

√

null

modo

text

2147483647

√

null

Table contained 0 rows

View Definition

SELECT d.client_addr AS maquina, c.datname AS banco, e.schemaname AS esquema, b.relname AS tabela, a.mode, CASE WHEN (a.mode = 'AccessShareLock'::text) THEN 'Acesso a tabela'::text WHEN (a.mode = 'ExclusiveLock'::text) THEN 'Travamento da tabela'::text WHEN (a.mode = 'AccessExclusiveLock'::text) THEN 'Travamento da tabela - ACESSO EXCLUSIVO'::text WHEN (a.mode = 'RowShareLock'::text) THEN 'Acesso ao registro da tabela'::text WHEN (a.mode = 'RowExclusiveLock'::text) THEN 'Travamento do registro da tabela'::text ELSE NULL::text END AS modo FROM ((((pg_locks a JOIN pg_class b ON (((b.oid = a.relation) AND (b.relkind = 'r'::"char")))) JOIN pg_tables e ON ((b.relname = e.tablename))) JOIN pg_database c ON ((c.oid = a.database))) JOIN pg_stat_activity d ON ((d.procpid = a.pid))) WHERE (b.relname !~~ 'pg_%'::text) ORDER BY CASE WHEN (a.mode = 'AccessShareLock'::text) THEN 'Acesso a tabela'::text WHEN (a.mode = 'ExclusiveLock'::text) THEN 'Travamento da tabela'::text WHEN (a.mode = 'AccessExclusiveLock'::text) THEN 'Travamento da tabela - ACESSO EXCLUSIVO'::text WHEN (a.mode = 'RowShareLock'::text) THEN 'Acesso ao registro da tabela'::text WHEN (a.mode = 'RowExclusiveLock'::text) THEN 'Travamento do registro da tabela'::text ELSE NULL::text END DESC, d.client_addr, b.relname;

Description

Columns

View Definition

Possibly Referenced Tables/Views