explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qXpp

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 5.504 ↓ 0.0 0 1

Hash Join (cost=22.01..79.51 rows=1 width=1) (actual time=5.504..5.504 rows=0 loops=1)

  • Hash Cond: (l_1.locktype = l.locktype)
  • Join Filter: ((NOT (l_1.database IS DISTINCT FROM l.database)) AND (NOT (l_1.relation IS DISTINCT FROM l.relation)) AND (NOT (l_1.page IS DISTINCT FROM l.page)) AND (NOT (l_1.tuple IS DISTINCT FROM l.tuple)) AND (NOT (l_1.virtualxid IS DISTINCT FROM l.virtualxid)) AND (NOT (l_1.transactionid IS DISTINCT FROM l.transactionid)) AND (NOT (l_1.classid IS DISTINCT FROM l.classid)) AND (NOT (l_1.objid IS DISTINCT FROM l.objid)) AND (NOT (l_1.objsubid IS DISTINCT FROM l.objsubid)) AND (l_1.pid <> l.pid))
2. 0.059 5.377 ↑ 500.0 1 1

Hash Join (cost=2.25..21.00 rows=500 width=96) (actual time=5.373..5.377 rows=1 loops=1)

  • Hash Cond: (l_1.pid = s_1.pid)
3. 4.525 4.525 ↑ 1,000.0 1 1

Function Scan on pg_lock_status l_1 (cost=0.00..10.00 rows=1,000 width=96) (actual time=4.525..4.525 rows=1 loops=1)

4. 0.017 0.793 ↑ 16.7 6 1

Hash (cost=1.00..1.00 rows=100 width=12) (actual time=0.793..0.793 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.776 0.776 ↑ 16.7 6 1

Function Scan on pg_stat_get_activity s_1 (cost=0.00..1.00 rows=100 width=12) (actual time=0.773..0.776 rows=6 loops=1)

6. 0.000 0.086 ↓ 0.0 0 1

Hash (cost=16.63..16.63 rows=250 width=96) (actual time=0.086..0.086 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.001 0.086 ↓ 0.0 0 1

Hash Join (cost=2.25..16.63 rows=250 width=96) (actual time=0.086..0.086 rows=0 loops=1)

  • Hash Cond: (l.pid = s.pid)
8. 0.085 0.085 ↓ 0.0 0 1

Function Scan on pg_lock_status l (cost=0.00..10.00 rows=500 width=96) (actual time=0.085..0.085 rows=0 loops=1)

  • Filter: (NOT granted)
  • Rows Removed by Filter: 9
9. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.00..1.00 rows=100 width=12) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=12) (never executed)

Planning time : 0.800 ms
Execution time : 5.650 ms