PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

PostgreSQL Lock Conflicts

This tool shows all commands and locks in postgres. If you select a command, it lists the locks that it acquires, commands that conflicts with it and commands that are allowed to run concurrently with it (with no conflict or blocking). If you select a lock, it lists commands that acquire the lock and what are the other conflicting locks.

Locks

  1. AccessShareLock (table)
  2. RowShareLock (table)
  3. RowExclusiveLock (table)
  4. ShareUpdateExclusiveLock (table)
  5. ShareLock (table)
  6. ShareRowExclusiveLock (table)
  7. ExclusiveLock (table)
  8. AccessExclusiveLock (table)
  9. FORKEYSHARE (row)
  10. FORSHARE (row)
  11. FORNOKEYUPDATE (row)
  12. FORUPDATE (row)

Commands

  1. SELECT
  2. SELECT FOR UPDATE
  3. SELECT FOR SHARE
  4. SELECT FOR NO KEY UPDATE
  5. SELECT FOR KEY SHARE
  6. COPY TO
  7. INSERT
  8. UPDATE (NO KEYS)
  9. UPDATE (KEYS)
  10. DELETE
  11. COPY FROM
  12. MERGE
  13. VACUUM
  14. VACUUM FULL
  15. TRUNCATE
  16. REINDEX
  17. REINDEX CONCURRENTLY
  18. REFRESH MATERIALIZED VIEW
  19. REFRESH MATERIALIZED VIEW CONCURRENTLY
  20. DROP TABLE
  21. DROP INDEX
  22. DROP INDEX CONCURRENTLY
  23. CREATE TRIGGER
  24. CREATE STATISTICS
  25. CREATE INDEX
  26. CREATE INDEX CONCURRENTLY
  27. COMMENT ON
  28. CLUSTER
  29. ANALYZE
  30. ALTER TABLE VALIDATE CONSTRAINT
  31. ALTER TABLE SET/DROP DEFAULT
  32. ALTER TABLE SET WITHOUT CLUSTER
  33. ALTER TABLE SET TOAST
  34. ALTER TABLE SET TABLESPACE
  35. ALTER TABLE SET STORAGE
  36. ALTER TABLE SET STATISTICS
  37. ALTER TABLE SET SEQUENCE
  38. ALTER TABLE SET N_DISTINCT
  39. ALTER TABLE SET FILLFACTOR
  40. ALTER TABLE SET DATA TYPE
  41. ALTER TABLE SET COMPRESSION
  42. ALTER TABLE SET AUTOVACUUUM
  43. ALTER TABLE RESET STORAGE
  44. ALTER TABLE RENAME
  45. ALTER TABLE INHERIT PARENT
  46. ALTER TABLE ENABLE/DISABLE TRIGGER
  47. ALTER TABLE ENABLE/DISABLE RULE
  48. ALTER TABLE ENABLE/DISABLE ROW LEVEL SECURITY
  49. ALTER TABLE DROP EXPRESSION
  50. ALTER TABLE DROP CONSTRAINT
  51. ALTER TABLE DROP COLUMN
  52. ALTER TABLE DETACH PARTITION (PARENT)
  53. ALTER TABLE DETACH PARTITION (TARGET/DEFAULT)
  54. ALTER TABLE DETACH PARTITION CONCURRENTLY (PARENT)
  55. ALTER TABLE DETACH PARTITION CONCURRENTLY (TARGET/DEFAULT)
  56. ALTER TABLE CLUSTER ON
  57. ALTER TABLE ATTACH PARTITION (PARENT)
  58. ALTER TABLE ATTACH PARTITION (TARGET/DEFAULT)
  59. ALTER TABLE ALTER CONSTRAINT
  60. ALTER TABLE ADD FOREIGN KEY NOT VALID (PARENT)
  61. ALTER TABLE ADD FOREIGN KEY NOT VALID (CHILD)
  62. ALTER TABLE ADD FOREIGN KEY (PARENT)
  63. ALTER TABLE ADD FOREIGN KEY (CHILD)
  64. ALTER TABLE ADD COLUMN
  65. ALTER TABLE ADD CONSTRAINT
  66. ALTER INDEX SET TABLESPACE
  67. ALTER INDEX SET FILLFACTOR
  68. ALTER INDEX ATTACH PARTITION
  69. ALTER INDEX (RENAME)