explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yhBg

Settings
# exclusive inclusive rows x rows loops node
1. 980.042 46,031.562 ↓ 0.0 0 1

Insert on pg_temp_13.kb_work_linkids (cost=995,317.67..1,462,487.77 rows=453 width=20) (actual time=46,031.562..46,031.562 rows=0 loops=1)

  • Buffers: shared hit=4914097 read=72910, local hit=1619172 read=45513 dirtied=8659 written=4566, temp read=21654 written=21654
2. 2,940.341 45,051.520 ↓ 3,536.1 1,601,861 1

Merge Join (cost=995,317.67..1,462,487.77 rows=453 width=20) (actual time=4,708.203..45,051.520 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))
  • Join Filter: (tli.idpro = a.idpro)
  • Rows Removed by Join Filter: 3043930
  • Buffers: shared hit=4914097 read=72910, local read=36850, temp read=21654 written=21654
3. 34,502.855 34,502.855 ↑ 1.1 5,770,912 1

Index Scan using clr_cle_knd_pro on castoncast_local.acc a (cost=0.43..392,581.97 rows=6,164,822 width=16) (actual time=0.007..34,502.855 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=4914097 read=72910
4. 1,053.682 7,608.324 ↓ 1.4 9,819,313 1

Materialize (cost=995,314.23..1,029,400.48 rows=6,817,250 width=16) (actual time=4,708.180..7,608.324 rows=9,819,313 loops=1)

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

Sort (cost=995,314.23..1,012,357.35 rows=6,817,250 width=16) (actual time=4,708.165..6,554.642 rows=6,817,250 loops=1)

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

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

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