explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aPlb

Settings
# exclusive inclusive rows x rows loops node
1. 9,625.658 9,874.924 ↓ 12.7 2,255 1

Bitmap Heap Scan on command jpacommand0_ (cost=974.78..85,515.90 rows=177 width=686) (actual time=263.868..9,874.924 rows=2,255 loops=1)

  • Recheck Cond: ((vsb_reference)::text = '6fa95994'::text)
  • Filter: ((destination)::text = 'INSTITUTION'::text)
  • Rows Removed by Filter: 26,948
  • Heap Blocks: exact=22,293
  • Buffers: shared hit=3,332 read=19,168 dirtied=1
  • I/O Timings: read=9,500.743
2. 249.266 249.266 ↓ 1.1 29,213 1

Bitmap Index Scan on idx_command_vsb_reference (cost=0.00..974.74 rows=27,224 width=0) (actual time=249.266..249.266 rows=29,213 loops=1)

  • Index Cond: ((vsb_reference)::text = '6fa95994'::text)
  • Buffers: shared hit=2 read=205
  • I/O Timings: read=237.259
Planning time : 13.535 ms
Execution time : 9,876.406 ms