explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iUvM

Settings
# exclusive inclusive rows x rows loops node
1. 297,208.950 731,109.958 ↓ 71.9 28,411,288 1

Hash Join (cost=1,082,314.26..6,496,667.20 rows=395,244 width=144) (actual time=60,446.996..731,109.958 rows=28,411,288 loops=1)

  • Hash Cond: (bcr.id = tkts.tem_registro_consumo_id)
  • Join Filter: ((CASE WHEN (tkts.last_update > bcr.last_update) THEN tkts.last_update ELSE bcr.last_update END >= '2019-11-01 00:00:00'::timestamp without time zone) AND (CASE WHEN (tkts.last_update > bcr.last_update) THEN tkts.last_update ELSE bcr.last_update END <= '2019-12-31 23:59:59'::timestamp without time zone))
  • Rows Removed by Join Filter: 2977499
2. 373,582.703 373,582.703 ↓ 1.0 31,388,787 1

Seq Scan on tem_registro_consumo bcr (cost=0.00..3,759,383.60 rows=31,087,322 width=101) (actual time=41.266..373,582.703 rows=31,388,787 loops=1)

  • Filter: ((status)::text = 'CHAMADA_TARIFADA'::text)
  • Rows Removed by Filter: 66503136
3. 11,500.008 60,318.305 ↓ 2.9 31,388,787 1

Hash (cost=853,823.70..853,823.70 rows=10,732,765 width=47) (actual time=60,318.305..60,318.305 rows=31,388,787 loops=1)

  • Buckets: 32768 Batches: 256 (originally 64) Memory Usage: 14337kB
4. 48,818.297 48,818.297 ↓ 2.9 31,388,787 1

Seq Scan on bill_tickets tkts (cost=0.00..853,823.70 rows=10,732,765 width=47) (actual time=10.462..48,818.297 rows=31,388,787 loops=1)

  • Filter: (COALESCE(id_tem_bill_ivn_central, (-1)) > 0)
Total runtime : 732,275.023 ms