explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kkOo

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 113,292.496 ↑ 1.0 25 1

Limit (cost=0.56..5,796.73 rows=25 width=997) (actual time=113,289.087..113,292.496 rows=25 loops=1)

  • Buffers: shared hit=15,077 read=5,249,776
  • I/O Timings: read=47,234.984
2. 113,292.476 113,292.476 ↑ 1,793.1 25 1

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

  • Filter: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Rows Removed by Filter: 45,000,009
  • Buffers: shared hit=15,077 read=5,249,776
  • I/O Timings: read=47,234.984
Planning time : 6.525 ms
Execution time : 113,292.554 ms