explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f5XU : Index on claim id

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

Nested Loop (cost=2,088.93..3,327,951.21 rows=485,864 width=1,084) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on grid_property gp1 (cost=0.00..2.70 rows=1 width=417) (actual rows= loops=)

  • Filter: (property_type = 'LCD_PART'::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,088.93..3,323,089.87 rows=485,864 width=667) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on grid_property gp (cost=0.00..2.70 rows=1 width=417) (actual rows= loops=)

  • Filter: (property_type = 'SMALL_PART'::text)
5. 0.000 0.000 ↓ 0.0

Gather (cost=2,088.93..3,318,228.53 rows=485,864 width=250) (actual rows= loops=)

  • Workers Planned: 1
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,088.93..3,268,642.13 rows=285,802 width=250) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,088.23..2,012,901.43 rows=285,802 width=274) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,087.66..611,571.83 rows=285,802 width=192) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,087.10..169,900.00 rows=285,802 width=115) (actual rows= loops=)

  • Hash Cond: (il.invoice_id = i.id)
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on invoice_line il (cost=0.00..157,678.31 rows=2,207,031 width=65) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=1,068.78..1,068.78 rows=1,466 width=58) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.96..1,068.78 rows=1,466 width=58) (actual rows= loops=)

  • Hash Cond: (i.vendor = div.invoice_vendor)
13. 0.000 0.000 ↓ 0.0

Seq Scan on invoice i (cost=0.00..1,034.20 rows=11,320 width=58) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=3.74..3.74 rows=18 width=17) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on dim_invoice_vendor div (cost=0.00..3.74 rows=18 width=17) (actual rows= loops=)

  • Filter: (rule_category = 'Depot Repair/Rapid Repair'::text)
16. 0.000 0.000 ↓ 0.0

Index Scan using claim_pkey_1 on claim cl (cost=0.56..1.55 rows=1 width=77) (actual rows= loops=)

  • Index Cond: (id = il.claim_id)
17. 0.000 0.000 ↓ 0.0

Index Scan using warranty_summary_pkey on warranty_summary (cost=0.57..4.90 rows=1 width=139) (actual rows= loops=)

  • Index Cond: (cl.warranty_product_id = warranty_id)
18. 0.000 0.000 ↓ 0.0

Index Scan using purchased_item_pkey_1 on purchased_item pi (cost=0.70..4.39 rows=1 width=40) (actual rows= loops=)

  • Index Cond: (cl.core_item_id = id)