explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jsO2

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 15.992 ↑ 1.0 1 1

Aggregate (cost=149,498.93..149,498.96 rows=1 width=8) (actual time=15.991..15.992 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=15.942
2. 0.003 15.985 ↓ 0.0 0 1

Bitmap Heap Scan on published_event (cost=2,024.82..149,386.79 rows=44,855 width=0) (actual time=15.985..15.985 rows=0 loops=1)

  • Recheck Cond: (lower((destination_topic)::text) = 'unknown'::text)
  • Buffers: shared read=5
  • I/O Timings: read=15.942
3. 15.982 15.982 ↓ 0.0 0 1

Bitmap Index Scan on idx_destination_topic_lower (cost=0.00..2,013.60 rows=44,855 width=0) (actual time=15.982..15.982 rows=0 loops=1)

  • Index Cond: (lower((destination_topic)::text) = 'unknown'::text)
  • Buffers: shared read=5
  • I/O Timings: read=15.942
Planning time : 12.750 ms
Execution time : 16.060 ms