explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nvej

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=494.02..567.91 rows=1 width=808) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=493.74..565.61 rows=1 width=661) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=493.61..565.43 rows=1 width=641) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=493.46..565.26 rows=1 width=526) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=493.32..565.10 rows=1 width=393) (actual rows= loops=)

  • Hash Cond: (le."tagHeader" = th.rowid)
6. 0.000 0.000 ↓ 0.0

Append (cost=0.00..68.05 rows=1,420 width=262) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on "LogEvent_1" le (cost=0.00..53.55 rows=1,237 width=260) (actual rows= loops=)

  • Filter: ((rowid >= 500) AND (rowid <= 53224714) AND ("ackStatus" = ANY ('{0,1}'::integer[])))
8. 0.000 0.000 ↓ 0.0

Seq Scan on "LogEvent_2" le_1 (cost=0.00..7.40 rows=183 width=279) (actual rows= loops=)

  • Filter: ((rowid >= 500) AND (rowid <= 53224714) AND ("ackStatus" = ANY ('{0,1}'::integer[])))
9. 0.000 0.000 ↓ 0.0

Hash (cost=487.02..487.02 rows=504 width=134) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "TagHeader" th (cost=6.33..487.02 rows=504 width=134) (actual rows= loops=)

  • Recheck Cond: (equipment = 708)
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "tagHeaderEquipmentIndex" (cost=0.00..6.20 rows=504 width=0) (actual rows= loops=)

  • Index Cond: (equipment = 708)
12. 0.000 0.000 ↓ 0.0

Index Scan using "UserAccount_pkey" on "UserAccount" ua (cost=0.14..0.16 rows=1 width=133) (actual rows= loops=)

  • Index Cond: (le."user" = rowid)
13. 0.000 0.000 ↓ 0.0

Index Scan using "LogEventClass_pkey" on "LogEventClass" lec (cost=0.14..0.17 rows=1 width=115) (actual rows= loops=)

  • Index Cond: (rowid = le."eventClass")
14. 0.000 0.000 ↓ 0.0

Index Scan using "ImportanceLevel_pkey" on "ImportanceLevel" il (cost=0.13..0.17 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (lec."importanceLevel" = rowid)
15. 0.000 0.000 ↓ 0.0

Index Scan using "Equipment_pkey" on "Equipment" e (cost=0.28..2.29 rows=1 width=147) (actual rows= loops=)