explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SU3h

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 14,435.196 56,599.937 ↓ 0.0 0 1

Merge Join (cost=47.25..2,323,606.28 rows=995,225 width=146) (actual time=56,599.937..56,599.937 rows=0 loops=1)

  • Merge Cond: (tkts.tem_registro_consumo_id = bcr.id)
  • Join Filter: (CASE WHEN (tkts.last_update > bcr.last_update) THEN tkts.last_update ELSE bcr.last_update END >= to_timestamp('20200105'::text, 'YYYYMMDD'::text))
  • Rows Removed by Join Filter: 17884244
2. 10,821.354 10,821.354 ↓ 3.0 17,884,244 1

Index Scan using idx_bill_ticket_call_rec on bill_tickets tkts (cost=0.44..616,498.11 rows=5,961,415 width=48) (actual time=0.009..10,821.354 rows=17,884,244 loops=1)

  • Filter: (COALESCE(id_tem_bill_ivn_central, (-1)) > 0)
3. 31,343.387 31,343.387 ↑ 1.0 17,884,244 1

Index Scan using pk_bill_call_records on tem_registro_consumo bcr (cost=0.56..1,563,078.22 rows=18,012,609 width=102) (actual time=0.009..31,343.387 rows=17,884,244 loops=1)

  • Filter: ((status)::text = 'CHAMADA_TARIFADA'::text)
  • Rows Removed by Filter: 18081031