explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W3eM

Settings
# exclusive inclusive rows x rows loops node
1. 45,028.795 475,170.830 ↓ 2.4 17,884,244 1

Merge Join (cost=38.38..2,328,223.12 rows=7,487,706 width=146) (actual time=0.030..475,170.830 rows=17,884,244 loops=1)

  • Merge Cond: (tkts.tem_registro_consumo_id = bcr.id)
2. 41,915.709 41,915.709 ↓ 1.0 17,884,244 1

Index Scan using idx_bill_ticket_call_rec on bill_tickets tkts (cost=0.44..661,208.72 rows=17,882,457 width=48) (actual time=0.009..41,915.709 rows=17,884,244 loops=1)

  • Filter: ((id_tem_bill_ivn_central IS NOT NULL) AND (last_update > to_timestamp('20191101'::text, 'YYYYMMDD'::text)))
3. 388,226.326 388,226.326 ↓ 1.2 17,884,244 1

Index Scan using idx_bill_call_records_id_status on tem_registro_consumo bcr (cost=0.44..1,266,837.44 rows=15,059,307 width=102) (actual time=0.009..388,226.326 rows=17,884,244 loops=1)

  • Filter: (last_update > to_timestamp('20191101'::text, 'YYYYMMDD'::text))