invalid index
SELECT c.relname AS index_name,
i.indrelid::regclass AS table_name,
i.indisvalid
FROM pg_index i
JOIN pg_class c ON i.indexrelid = c.oid
WHERE i.indisvalid = false;
blocking query
SELECT blocking_activity.pid AS blocking_pid, blocking_activity.usename AS blocking_user, blocking_activity.query AS blocking_statement, blocked_activity.pid AS blocked_pid, blocked_activity.query AS blocked_ui_query FROM pg_catalog.pg_locks blocked_locks JOIN pg_catalog.pg_stat_activity blocked_activity ON blocked_activity.pid = blocked_locks.pid JOIN pg_catalog.pg_locks blocking_locks ON blocking_locks.locktype = blocked_locks.locktype AND blocking_locks.database IS NOT DISTINCT FROM blocked_locks.database AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation AND blocking_locks.pid != blocked_locks.pid JOIN pg_catalog.pg_stat_activity blocking_activity ON blocking_activity.pid = blocking_locks.pid WHERE NOT blocked_locks.granted; SELECT schemaname AS schema_name, relname AS system_table, ...
Comments
Post a Comment