explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xFmZ

Settings
# exclusive inclusive rows x rows loops node
1. 934.549 27,315.170 ↓ 0.0 0 1

Insert on pg_temp_12.kb_work_linkids (cost=995,322.39..1,489,024.11 rows=427 width=20) (actual time=27,315.170..27,315.170 rows=0 loops=1)

  • Buffers: shared hit=4944493 read=42514, local hit=1619172 read=45513 dirtied=8659 written=4566, temp read=21654 written=21654
2. 2,559.688 26,380.621 ↓ 3,751.4 1,601,861 1

Merge Join (cost=995,322.39..1,489,024.11 rows=427 width=20) (actual time=5,001.023..26,380.621 rows=1,601,861 loops=1)

  • Output: tli.linkid, 'S'::character(1), 0, a.idacc
  • Merge Cond: ((a.idclr = tli.idclr) AND (a.idcle = tli.idcle) AND (a.idpro = tli.idpro))
  • Buffers: shared hit=4944493 read=42514, local read=36850, temp read=21654 written=21654
3. 16,134.044 16,134.044 ↑ 1.1 5,770,912 1

Index Scan using clr_cle_pro on castoncast_local.acc a (cost=0.43..392,471.17 rows=6,164,822 width=16) (actual time=0.008..16,134.044 rows=5,770,912 loops=1)

  • Output: a.idacc, a.idclr, a.idcle, a.acctyplo, a.acctyphi, a.acctyplo2, a.acctyphi2, a.accknd, a.idpro, a.prop
  • Buffers: shared hit=4944493 read=42514
4. 856.908 7,686.889 ↑ 1.0 6,817,250 1

Materialize (cost=995,314.23..1,029,400.48 rows=6,817,250 width=16) (actual time=5,001.008..7,686.889 rows=6,817,250 loops=1)

  • Output: tli.linkid, tli.idclr, tli.idcle, tli.idpro
  • Buffers: local read=36850, temp read=21654 written=21654
5. 5,623.451 6,829.981 ↑ 1.0 6,817,250 1

Sort (cost=995,314.23..1,012,357.35 rows=6,817,250 width=16) (actual time=5,000.993..6,829.981 rows=6,817,250 loops=1)

  • Output: tli.linkid, tli.idclr, tli.idcle, tli.idpro
  • Sort Key: tli.idclr, tli.idcle, tli.idpro
  • Sort Method: external merge Disk: 173112kB
  • Buffers: local read=36850, temp read=21654 written=21654
6. 1,206.530 1,206.530 ↑ 1.0 6,817,250 1

Seq Scan on pg_temp_12.tmp_linkids tli (cost=0.00..105,022.50 rows=6,817,250 width=16) (actual time=0.049..1,206.530 rows=6,817,250 loops=1)

  • Output: tli.linkid, tli.idclr, tli.idcle, tli.idpro
  • Buffers: local read=36850