explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bwoc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 49.795 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4.45..21,968.40 rows=1 width=6,240) (actual time=49.795..49.795 rows=0 loops=1)

  • Join Filter: (p.bo_id = bo.bo_id)
2.          

CTE cte_cpf_product

3. 0.012 0.012 ↑ 1.0 1 1

Index Scan using cpf_product_pk on cpf_product (cost=0.58..2.59 rows=1 width=664) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (bo_id = 478832711)
4. 0.000 49.793 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.43..21,963.32 rows=1 width=6,466) (actual time=49.793..49.793 rows=0 loops=1)

  • Join Filter: ((p.package_id)::text = (c.package_id)::text)
5. 0.001 49.793 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.43..21,768.42 rows=1 width=6,423) (actual time=49.793..49.793 rows=0 loops=1)

6. 0.008 49.792 ↓ 0.0 0 1

Nested Loop (cost=1.01..21,765.97 rows=1 width=6,396) (actual time=49.792..49.792 rows=0 loops=1)

  • Join Filter: (((p.product_id)::text = (COALESCE(video_rates.product_id, '-1'::character varying))::text) AND ((p.rate_group)::text = (vi
7. 0.010 0.047 ↑ 1.0 1 1

Nested Loop (cost=0.58..1,073.99 rows=1 width=6,386) (actual time=0.041..0.047 rows=1 loops=1)

  • Join Filter: ((p.bundle_type_cd IS NOT NULL) OR ((p.product_type)::text <> ALL ('{BQTFDTRK,BQTFDVTRK,BQTFVTRK}'::text[])) OR ((p.b
8. 0.014 0.014 ↑ 1.0 1 1

Index Scan using bo_mapping_pk on bo_mapping bom (cost=0.58..2.59 rows=1 width=16) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (bo_id = 478832711)
9. 0.023 0.023 ↑ 1.0 1 1

CTE Scan on cte_cpf_product p (cost=0.00..0.02 rows=1 width=6,804) (actual time=0.020..0.023 rows=1 loops=1)

  • Filter: (bo_id = 478832711)
10.          

SubPlan (forNested Loop)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..1,071.36 rows=1 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using bo_mapping_fk5 on bo_mapping bom1 (cost=0.58..685.45 rows=148 width=8) (never executed)

  • Index Cond: (vol_parent_bo_id = bom.vol_parent_bo_id)
  • Filter: ((bom.bo_id <> bo_id) AND (bo_status_code = 2))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using cpf_product_pk on cpf_product p1 (cost=0.58..2.60 rows=1 width=8) (never executed)

  • Index Cond: (bo_id = bom1.bo_id)
  • Filter: ((bundle_type_cd IS NOT NULL) AND ((product_type)::text = (p.product_type)::text))
14. 49.737 49.737 ↓ 0.0 0 1

Index Scan using pk_video_rates on video_rates (cost=0.43..20,691.97 rows=1 width=20) (actual time=49.737..49.737 rows=0 loops=1)

  • Index Cond: (((state_code)::text = ''::text) AND (start_date <= date_trunc('day'::text, ('now'::cstring)::timestamp without time z
  • Filter: (((rate_type)::text <> 'RC-USAGE'::text) AND ((end_date IS NULL) OR (end_date >= date_trunc('day'::text, ('now'::cstring):
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_products on products b (cost=0.42..2.44 rows=1 width=33) (never executed)

  • Index Cond: ((p.product_id)::text = (product_id)::text)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on packages c (cost=0.00..144.40 rows=4,040 width=49) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using bo_mapping_override_ix1 on bo_mapping_override bo (cost=0.42..2.45 rows=1 width=8) (never executed)

  • Index Cond: (bo_id = 478832711)
  • Filter: ((bo_status_code = 4) AND ((is_active)::text = 'Y'::text))