explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HjQ0y

Settings

Optimization(s) for this plan:

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

WindowAgg (cost=484.82..541.27 rows=1 width=266) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=484.82..541.26 rows=1 width=258) (actual rows= loops=)

  • Hash Cond: (((xls.master_account_id)::bpchar = (xcd.master_account_id)::bpchar) AND ((xls.call_id)::bpchar = (xcd.call_id)::bpchar))
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=129.07..152.58 rows=1,881 width=66) (actual rows= loops=)

  • Group Key: xls.master_account_id, xls.call_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on ct_call_log_signals xls (cost=0.00..107.85 rows=2,829 width=46) (actual rows= loops=)

  • Filter: ((master_account_id)::bpchar = 'AC13110000321682'::bpchar)
5. 0.000 0.000 ↓ 0.0

Hash (cost=355.74..355.74 rows=1 width=243) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.75..355.74 rows=1 width=243) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ct_provisions xcp (cost=2.33..13.96 rows=5 width=17) (actual rows= loops=)

  • Recheck Cond: ((account_id)::bpchar = 'AC15060001813595'::bpchar)
  • Filter: ((master_account_id)::bpchar = 'AC13110000321682'::bpchar)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_ct_provisions_account_id (cost=0.00..2.33 rows=6 width=0) (actual rows= loops=)

  • Index Cond: ((account_id)::bpchar = 'AC15060001813595'::bpchar)
9. 0.000 0.000 ↓ 0.0

Index Scan using ix_ct_call_detail_log_provision_id on ct_call_detail_log xcd (cost=0.42..68.35 rows=1 width=260) (actual rows= loops=)

  • Index Cond: ((provision_id)::bpchar = (xcp.provision_id)::bpchar)
  • Filter: (((master_account_id)::bpchar = 'AC13110000321682'::bpchar) AND (voice_file_status = 'AVAILABLE'::text) AND ((to_char(start_time, 'YYYY'::text))::integer = 2018) AND ((to_char(start_time, 'MM'::text))::integer = 8))