explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WWQA

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

Limit (cost=150,674.53..150,674.59 rows=25 width=1,005) (actual time=2,639.483..2,639.490 rows=25 loops=1)

  • Buffers: shared hit=70 read=35,061
  • I/O Timings: read=2,164.236
2. 39.364 2,639.484 ↑ 1,793.1 25 1

Sort (cost=150,674.53..150,786.60 rows=44,827 width=1,005) (actual time=2,639.482..2,639.484 rows=25 loops=1)

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

Bitmap Heap Scan on published_event (cost=2,024.60..149,409.54 rows=44,827 width=1,005) (actual time=30.941..2,600.120 rows=35,960 loops=1)

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

Bitmap Index Scan on idx_destination_topic_lower (cost=0.00..2,013.39 rows=44,827 width=0) (actual time=24.673..24.673 rows=35,960 loops=1)

  • Index Cond: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Buffers: shared read=187
  • I/O Timings: read=15.305
Planning time : 0.172 ms
Execution time : 2,658.960 ms