explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zs7

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.026 ↑ 1.0 1 1

Aggregate (cost=125.73..125.74 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1)

2. 0.001 0.024 ↓ 0.0 0 1

Limit (cost=93.47..125.72 rows=1 width=220) (actual time=0.024..0.024 rows=0 loops=1)

3. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=93.47..125.72 rows=1 width=220) (actual time=0.023..0.023 rows=0 loops=1)

4. 0.002 0.023 ↓ 0.0 0 1

Hash Join (cost=93.20..125.28 rows=1 width=24) (actual time=0.022..0.023 rows=0 loops=1)

  • Hash Cond: ("LimitStatus".header = "TagHeader".rowid)
5. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on "LimitStatus" (cost=0.00..27.00 rows=1,353 width=8) (actual time=0.021..0.021 rows=0 loops=1)

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

Hash (cost=93.18..93.18 rows=1 width=16) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=78.13..93.18 rows=1 width=16) (never executed)

  • Hash Cond: ("LimitTagsRef".header = "TagHeader".rowid)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on "LimitTagsRef" (cost=0.00..14.00 rows=400 width=64) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=78.12..78.12 rows=1 width=16) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TagHeader" (cost=0.00..78.12 rows=1 width=16) (never executed)

  • Filter: "uiVisibility
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "currentTagHeaderIndex" on "CurrentTag" (cost=0.28..0.39 rows=5 width=8) (never executed)

  • Index Cond: (header = "LimitStatus".header)
  • Heap Fetches: 0