PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

PostgreSQL Lock Conflicts

这个工具展示了 PostgreSQL 中所有的命令和锁。 如果你选择一个命令，它会列出该命令获取的锁，与该命令冲突的命令，以及可以与该命令并发运行（无冲突或阻塞）的命令。 如果你选择一个锁，它会列出获取该锁的命令，以及其他与之冲突的锁。

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