explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q1gV

Settings
# exclusive inclusive rows x rows loops node
1. 11,088.449 243,500.215 ↓ 27.0 32,337,782 1

Gather (cost=569,835.76..3,441,425.81 rows=1,196,378 width=281) (actual time=203,921.462..243,500.215 rows=32,337,782 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 33,451.304 232,411.766 ↓ 21.6 6,467,556 5 / 5

Parallel Hash Join (cost=568,835.76..3,320,788.01 rows=299,094 width=281) (actual time=203,491.631..232,411.766 rows=6,467,556 loops=5)

  • Hash Cond: (bcr.id = tkts.tem_registro_consumo_id)
  • Join Filter: (to_char(CASE WHEN (tkts.last_update > bcr.last_update) THEN tkts.last_update ELSE bcr.last_update END, 'yyyymmdd'::text) >= '20180101'::text)
3. 161,184.999 161,184.999 ↑ 1.3 6,467,556 5 / 5

Parallel Seq Scan on tem_registro_consumo bcr (cost=0.00..2,441,779.92 rows=8,170,200 width=101) (actual time=133.457..161,184.999 rows=6,467,556 loops=5)

  • Filter: ((status)::text = 'CHAMADA_TARIFADA'::text)
  • Rows Removed by Filter: 13162518
4. 5,845.487 37,775.463 ↓ 2.4 6,467,556 5 / 5

Parallel Hash (cost=511,465.57..511,465.57 rows=2,694,815 width=47) (actual time=37,775.463..37,775.463 rows=6,467,556 loops=5)

  • Buckets: 2097152 (originally 2097152) Batches: 32 (originally 16) Memory Usage: 98656kB
5. 31,929.976 31,929.976 ↓ 2.4 6,467,556 5 / 5

Parallel Seq Scan on bill_tickets tkts (cost=0.00..511,465.57 rows=2,694,815 width=47) (actual time=0.022..31,929.976 rows=6,467,556 loops=5)

  • Filter: (COALESCE(id_tem_bill_ivn_central, '-1'::integer) > 0)
Planning time : 0.365 ms
Execution time : 244,528.137 ms