explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktBA

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

Nested Loop (cost=1,494.02..6,452.76 rows=1 width=808) (actual rows= loops=)

  • -> Index Scan using "Equipment_pkey" on "Equipment" e (cost=0.28..2.29 rows=1 width=147)" Index Cond: (rowid = 708)
2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,493.61..6,450.27 rows=1 width=641) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

Gather (cost=1,493.32..6,449.94 rows=1 width=393) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=493.32..5,449.84 rows=1 width=393) (actual rows= loops=)

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

Append (cost=0.00..4,954.32 rows=837 width=262) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "LogEvent_1" le (cost=0.00..44.47 rows=728 width=260) (actual rows= loops=)

  • Filter: ((rowid >= 500) AND (rowid <= 3,224,714) AND ("ackStatus" <> 2))
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "LogEvent_2" le_1 (cost=0.00..6.08 rows=108 width=279) (actual rows= loops=)

  • Filter: ((rowid >= 500) AND (rowid <= 3,224,714) AND ("ackStatus" <> 2))
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "LogEvent_3" le_2 (cost=0.00..4,899.58 rows=1 width=191) (actual rows= loops=)

  • Filter: ((rowid >= 500) AND (rowid <= 3,224,714) AND ("ackStatus" <> 2))
11. 0.000 0.000 ↓ 0.0

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

12. 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)
13. 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)
14. 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)
15. 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")
16. 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)