explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BoPg

Settings
# exclusive inclusive rows x rows loops node
1. 773.826 919.160 ↑ 1.2 35,960 1

Bitmap Heap Scan on published_event (cost=2,238.10..149,398.91 rows=44,827 width=997) (actual time=151.393..919.160 rows=35,960 loops=1)

  • Recheck Cond: ((destination_topic)::text = 'socsec.nsso.discard'::text)
  • Heap Blocks: exact=34,941
  • Buffers: shared hit=67 read=35,093
  • I/O Timings: read=765.577
2. 145.334 145.334 ↑ 1.2 35,960 1

Bitmap Index Scan on idx_destination_topic (cost=0.00..2,226.89 rows=44,827 width=0) (actual time=145.334..145.334 rows=35,960 loops=1)

  • Index Cond: ((destination_topic)::text = 'socsec.nsso.discard'::text)
  • Buffers: shared read=219
  • I/O Timings: read=137.420
Planning time : 0.110 ms
Execution time : 922.531 ms