explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 15uU

Settings
# exclusive inclusive rows x rows loops node
1. 63,473.307 232,999.479 ↓ 0.0 0 1

Merge Left Join (cost=4,243,895.36..4,482,994.02 rows=1 width=698) (actual time=232,999.479..232,999.479 rows=0 loops=1)

  • Output: rab.idacc, rab.idclr, rab.idnamclr, rab.idcle, rab.idnamcle, rab.idpro, rab.idnampro, rab.bookmode, rab.info1, rab.info2, rab.info3, rab.info4, rab.prop, rab.blkno, rab.idnamblkno, nab.idacc, nab.idclr, nab.idnamclr, nab.idcle, nab.idnamcle, nab.idpro, nab.idnampro, nab.bookmode, nab.info1, nab.info2, nab.info3, nab.info4, nab.prop, nab.blkno, nab.idnamblkno
  • Merge Cond: (((rab.idnamblkno)::text = (nab.idnamblkno)::text) AND ((rab.idnamclr)::text = (nab.idnamclr)::text) AND ((rab.idnamcle)::text = (nab.idnamcle)::text) AND ((rab.idnampro)::text = (nab.idnampro)::text) AND (rab.bookmode = nab.bookmode) AND (rab.prop = nab.prop))
  • Filter: (nab.idacc IS NULL)
  • Rows Removed by Filter: 139802498
  • Buffers: local read=615934, temp read=571077 written=571077
2. 56,002.695 69,791.359 ↑ 1.0 6,387,048 1

Sort (cost=2,124,544.89..2,140,552.20 rows=6,402,924 width=348) (actual time=39,244.841..69,791.359 rows=6,387,048 loops=1)

  • Output: rab.idacc, rab.idclr, rab.idnamclr, rab.idcle, rab.idnamcle, rab.idpro, rab.idnampro, rab.bookmode, rab.info1, rab.info2, rab.info3, rab.info4, rab.prop, rab.blkno, rab.idnamblkno
  • Sort Key: rab.idnamblkno, rab.idnamclr, rab.idnamcle, rab.idnampro, rab.bookmode, rab.prop
  • Sort Method: external merge Disk: 2281664kB
  • Buffers: local read=308058, temp read=285347 written=285347
3. 13,788.664 13,788.664 ↑ 1.0 6,387,048 1

Seq Scan on pg_temp_23.refaccbook rab (cost=0.00..372,087.24 rows=6,402,924 width=348) (actual time=0.486..13,788.664 rows=6,387,048 loops=1)

  • Output: rab.idacc, rab.idclr, rab.idnamclr, rab.idcle, rab.idnamcle, rab.idpro, rab.idnampro, rab.bookmode, rab.info1, rab.info2, rab.info3, rab.info4, rab.prop, rab.blkno, rab.idnamblkno
  • Buffers: local read=308058
4. 7,507.413 99,734.813 ↓ 21.9 139,817,062 1

Materialize (cost=2,119,350.48..2,151,278.96 rows=6,385,697 width=350) (actual time=46,686.517..99,734.813 rows=139,817,062 loops=1)

  • Output: nab.idacc, nab.idclr, nab.idnamclr, nab.idcle, nab.idnamcle, nab.idpro, nab.idnampro, nab.bookmode, nab.info1, nab.info2, nab.info3, nab.info4, nab.prop, nab.blkno, nab.idnamblkno
  • Buffers: local read=307876, temp read=285730 written=285730
5. 70,670.255 92,227.400 ↓ 1.0 6,387,380 1

Sort (cost=2,119,350.48..2,135,314.72 rows=6,385,697 width=350) (actual time=46,686.508..92,227.400 rows=6,387,380 loops=1)

  • Output: nab.idacc, nab.idclr, nab.idnamclr, nab.idcle, nab.idnamcle, nab.idpro, nab.idnampro, nab.bookmode, nab.info1, nab.info2, nab.info3, nab.info4, nab.prop, nab.blkno, nab.idnamblkno
  • Sort Key: nab.idnamblkno, nab.idnamclr, nab.idnamcle, nab.idnampro, nab.bookmode, nab.prop
  • Sort Method: external merge Disk: 2284816kB
  • Buffers: local read=307876, temp read=285730 written=285730
6. 21,557.145 21,557.145 ↓ 1.0 6,387,380 1

Seq Scan on pg_temp_23.newaccbook nab (cost=0.00..371,732.97 rows=6,385,697 width=350) (actual time=5.151..21,557.145 rows=6,387,380 loops=1)

  • Output: nab.idacc, nab.idclr, nab.idnamclr, nab.idcle, nab.idnamcle, nab.idpro, nab.idnampro, nab.bookmode, nab.info1, nab.info2, nab.info3, nab.info4, nab.prop, nab.blkno, nab.idnamblkno
  • Buffers: local read=307876