explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hb7

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 93.449 ↑ 1.0 25 1

Limit (cost=150,674.53..150,674.59 rows=25 width=1,005) (actual time=93.442..93.449 rows=25 loops=1)

  • Buffers: shared hit=35,131
2. 18.927 93.443 ↑ 1,793.1 25 1

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

  • Sort Key: ((published_timestamp + 0))
  • Sort Method: top-N heapsort Memory: 43kB
  • Buffers: shared hit=35,131
3. 66.201 74.516 ↑ 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=14.262..74.516 rows=35,960 loops=1)

  • Recheck Cond: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Heap Blocks: exact=34,941
  • Buffers: shared hit=35,128
4. 8.315 8.315 ↑ 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=8.314..8.315 rows=35,960 loops=1)

  • Index Cond: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Buffers: shared hit=187
Planning time : 0.152 ms
Execution time : 94.183 ms