explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uHFW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 88.098 ↑ 1.0 1 1

Aggregate (cost=334.88..334.89 rows=1 width=8) (actual time=88.098..88.098 rows=1 loops=1)

2. 0.001 88.093 ↓ 0.0 0 1

Limit (cost=115.33..334.87 rows=1 width=220) (actual time=88.093..88.093 rows=0 loops=1)

3. 0.000 88.092 ↓ 0.0 0 1

Nested Loop (cost=115.33..334.87 rows=1 width=220) (actual time=88.092..88.092 rows=0 loops=1)

4. 0.002 88.092 ↓ 0.0 0 1

Nested Loop (cost=114.91..334.38 rows=1 width=24) (actual time=88.092..88.092 rows=0 loops=1)

  • Join Filter: ("LimitStatus".header = "CurrentTag".header)
5. 0.020 88.090 ↓ 0.0 0 1

Hash Join (cost=114.49..333.12 rows=1 width=16) (actual time=88.090..88.090 rows=0 loops=1)

  • Hash Cond: ("LimitTagsRef".header = "LimitStatus".header)
6. 5.297 5.297 ↑ 5,718.0 1 1

Seq Scan on "LimitTagsRef" (cost=0.00..197.18 rows=5,718 width=64) (actual time=5.297..5.297 rows=1 loops=1)

7. 0.000 82.773 ↓ 0.0 0 1

Hash (cost=114.48..114.48 rows=1 width=8) (actual time=82.773..82.773 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
8. 82.773 82.773 ↓ 0.0 0 1

Seq Scan on "LimitStatus" (cost=0.00..114.48 rows=1 width=8) (actual time=82.773..82.773 rows=0 loops=1)

  • Filter: (zone <> 3)
  • Rows Removed by Filter: 5,718
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "currentTagHeaderIndex" on "CurrentTag" (cost=0.42..1.24 rows=1 width=8) (never executed)

  • Index Cond: (header = "LimitTagsRef".header)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using "TagHeader_pkey" on "TagHeader" (cost=0.42..0.49 rows=1 width=16) (never executed)

  • Index Cond: (rowid = "CurrentTag".header)
  • Filter: "uiVisibility