explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gs2V

Settings
# exclusive inclusive rows x rows loops node
1. 253,625.256 253,625.256 ↑ 1.0 25 1

Limit (cost=0.56..5,796.73 rows=25 width=997) (actual time=253,618.103..253,625.256 rows=25 loops=1)

  • Buffers: shared hit=50,135 read=5,214,718
  • I/O Timings: read=188,552.554
  • (actual time=253,618.097..253625.243 rows=25 loops=1)
2. 0.000 0.000 ↓ 0.0

Index Scan Backward using idx_published_timestamp on published_event (cost=0.56..10,392,987.30 rows=44,827 width=997) (actual rows= loops=)

  • Filter: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Rows Removed by Filter: 45,000,009
  • Buffers: shared hit=50,135 read=5,214,718
  • I/O Timings: read=188,552.554
Planning time : 0.149 ms
Execution time : 253,625.308 ms