explain.depesz.com

PostgreSQL's explain analyze made readable

Result: scJK

Settings
# exclusive inclusive rows x rows loops node
1. 2.743 21.433 ↑ 1.0 1 1

Aggregate (cost=149,409.54..149,409.57 rows=1 width=8) (actual time=21.433..21.433 rows=1 loops=1)

  • Buffers: shared hit=191
2. 12.518 18.690 ↑ 1.2 35,960 1

Bitmap Heap Scan on published_event (cost=2,024.60..149,297.48 rows=44,827 width=0) (actual time=12.038..18.690 rows=35,960 loops=1)

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

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