explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aTp3

Settings
# exclusive inclusive rows x rows loops node
1. 8,408.440 21,446.829 ↓ 199.5 14,068,314 1

Sort (cost=1,249,961.19..1,250,137.51 rows=70,529 width=8) (actual time=19,575.069..21,446.829 rows=14,068,314 loops=1)

  • Sort Key: idmensagemvalidada
  • Sort Method: external merge Disk: 247,792kB
  • Buffers: shared hit=654,348 read=53,905, temp read=30,974 written=30,977
2. 10,321.301 13,038.389 ↓ 199.5 14,068,314 1

Bitmap Heap Scan on integradormensagemvalidada imv (cost=279,668.09..1,244,281.51 rows=70,529 width=8) (actual time=2,968.449..13,038.389 rows=14,068,314 loops=1)

  • Recheck Cond: ((nodeelement)::text = 'cd_empresa'::text)
  • Filter: ((idprotocolo)::integer = (idprotocolo)::integer)
  • Heap Blocks: exact=654,345
  • Buffers: shared hit=654,345 read=53,905
3. 2,717.088 2,717.088 ↑ 1.0 14,068,314 1

Bitmap Index Scan on ix_h01 (cost=0.00..279,650.46 rows=14,105,852 width=0) (actual time=2,717.088..2,717.088 rows=14,068,314 loops=1)

  • Index Cond: ((nodeelement)::text = 'cd_empresa'::text)
  • Buffers: shared read=53,905