explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wYMn

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,226.198 ↑ 1.0 25 1

Limit (cost=150,775.96..150,776.03 rows=25 width=1,005) (actual time=2,226.191..2,226.198 rows=25 loops=1)

  • Buffers: shared hit=70 read=35,093
  • I/O Timings: read=1,770.870
2. 39.277 2,226.192 ↑ 1,793.1 25 1

Sort (cost=150,775.96..150,888.03 rows=44,827 width=1,005) (actual time=2,226.189..2,226.192 rows=25 loops=1)

  • Sort Key: ((published_timestamp + 0))
  • Sort Method: top-N heapsort Memory: 43kB
  • Buffers: shared hit=70 read=35,093
  • I/O Timings: read=1,770.870
3. 2,047.598 2,186.915 ↑ 1.2 35,960 1

Bitmap Heap Scan on published_event (cost=2,238.10..149,510.98 rows=44,827 width=1,005) (actual time=145.460..2,186.915 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=1,770.870
4. 139.317 139.317 ↑ 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=139.317..139.317 rows=35,960 loops=1)

  • Index Cond: ((destination_topic)::text = 'socsec.nsso.discard'::text)
  • Buffers: shared read=219
  • I/O Timings: read=129.536
Planning time : 0.214 ms
Execution time : 2,228.385 ms