explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XGaJ

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

Nested Loop Left Join (cost=910.94..1,393.58 rows=1 width=960) (actual time=9.110..9.110 rows=0 loops=1)

2. 0.000 9.108 ↓ 0.0 0 1

Nested Loop Left Join (cost=910.52..1,386.55 rows=1 width=959) (actual time=9.108..9.108 rows=0 loops=1)

3. 0.000 9.108 ↓ 0.0 0 1

Nested Loop Left Join (cost=910.08..1,378.29 rows=1 width=942) (actual time=9.108..9.108 rows=0 loops=1)

  • Join Filter: (tm.call_leg_id = i.call_leg_id)
4. 0.001 9.108 ↓ 0.0 0 1

Nested Loop Left Join (cost=883.63..1,351.73 rows=1 width=876) (actual time=9.108..9.108 rows=0 loops=1)

5. 0.000 9.107 ↓ 0.0 0 1

Nested Loop Left Join (cost=883.21..1,337.74 rows=1 width=839) (actual time=9.107..9.107 rows=0 loops=1)

6. 0.001 9.107 ↓ 0.0 0 1

Nested Loop (cost=882.79..1,330.66 rows=1 width=823) (actual time=9.107..9.107 rows=0 loops=1)

7. 0.001 9.106 ↓ 0.0 0 1

Nested Loop (cost=882.35..1,322.53 rows=1 width=814) (actual time=9.106..9.106 rows=0 loops=1)

8. 0.002 9.105 ↓ 0.0 0 1

Hash Join (cost=881.92..1,314.40 rows=1 width=805) (actual time=9.105..9.105 rows=0 loops=1)

  • Hash Cond: (closure.child_customer_id = i.advertiser_id)
9. 9.103 9.103 ↓ 0.0 0 1

Index Only Scan using customer_closure_key on customer_closure closure (cost=0.43..229.78 rows=65 width=8) (actual time=9.103..9.103 rows=0 loops=1)

  • Index Cond: (parent_customer_id = 2,011,274)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Hash (cost=835.06..835.06 rows=3,714 width=801) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Append (cost=0.42..835.06 rows=3,714 width=801) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using call_leg_end_time_idx1 on call_leg i (cost=0.42..8.46 rows=1 width=842) (never executed)

  • Index Cond: ((end_time >= '2020-03-15 00:00:00+00'::timestamp with time zone) AND (end_time < '2020-03-16 00:00:00+00'::timestamp with time zone))
  • Filter: (((direction)::text = 'inbound'::text) AND ((((source_system)::text = 'MCA'::text) AND ((source_entity)::text = 'MCA_CALL'::text)) OR (((source_system)::text = 'DCM'::text) AND ((source_entity)::text = 'CALLS'::text)) OR (((source_system)::text = 'PFC'::text) AND ((source_entity)::text = 'ALL_CALL'::text))))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using call_leg_2020_03_end_time_idx on call_leg_2020_03 i_1 (cost=0.42..826.60 rows=3,713 width=801) (never executed)

  • Index Cond: ((end_time >= '2020-03-15 00:00:00+00'::timestamp with time zone) AND (end_time < '2020-03-16 00:00:00+00'::timestamp with time zone))
  • Filter: (((direction)::text = 'inbound'::text) AND ((((source_system)::text = 'MCA'::text) AND ((source_entity)::text = 'MCA_CALL'::text)) OR (((source_system)::text = 'DCM'::text) AND ((source_entity)::text = 'CALLS'::text)) OR (((source_system)::text = 'PFC'::text) AND ((source_entity)::text = 'ALL_CALL'::text))))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using phone_number_new_pkey on phone_number outbound (cost=0.43..8.12 rows=1 width=17) (never executed)

  • Index Cond: (phone_number_id = i.outbound_phone_number_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using phone_number_new_pkey on phone_number inbound (cost=0.43..8.12 rows=1 width=17) (never executed)

  • Index Cond: (phone_number_id = i.inbound_phone_number_id)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using clm_call_leg_id_from_match_type on call_leg_match clm (cost=0.42..7.07 rows=1 width=32) (never executed)

  • Index Cond: ((i.call_leg_id = call_leg_id_from) AND ((match_type)::text = 'EXTERNAL'::text))
17. 0.000 0.000 ↓ 0.0 0

Append (cost=0.42..13.98 rows=2 width=52) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using call_leg_pkey1 on call_leg e (cost=0.42..7.01 rows=1 width=52) (never executed)

  • Index Cond: (call_leg_id = clm.call_leg_id_to)
  • Filter: ((end_time >= '2020-03-14 22:50:00+00'::timestamp with time zone) AND (end_time < '2020-03-16 01:10:00+00'::timestamp with time zone))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using call_leg_2020_03_pkey on call_leg_2020_03 e_1 (cost=0.42..6.97 rows=1 width=53) (never executed)

  • Index Cond: (call_leg_id = clm.call_leg_id_to)
  • Filter: ((end_time >= '2020-03-14 22:50:00+00'::timestamp with time zone) AND (end_time < '2020-03-16 01:10:00+00'::timestamp with time zone))
20. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=26.45..26.49 rows=3 width=36) (never executed)

  • Group Key: tm.call_leg_id
21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..26.40 rows=3 width=36) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on transaction_match tm (cost=0.00..1.03 rows=3 width=20) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Index Scan using transaction_pkey on transaction t (cost=0.43..8.45 rows=1 width=28) (never executed)

  • Index Cond: (transaction_id = tm.transaction_id)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using call_tracking_entity_new_pkey on call_tracking_entity cte (cost=0.43..8.26 rows=1 width=25) (never executed)

  • Index Cond: (call_tracking_entity_id = i.call_tracking_entity_id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using call_leg_projection_pkey on call_leg_projection clp (cost=0.42..7.01 rows=1 width=17) (never executed)

  • Index Cond: (call_leg_id = i.call_leg_id)