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,

    last_vacuum,

    last_analyze,

    n_live_tup AS live_rows,

    n_dead_tup AS dead_rows

FROM pg_stat_sys_tables 

WHERE relname IN ('pg_class', 'pg_attribute', 'pg_namespace', 'pg_description', 'pg_constraint')

ORDER BY system_table;