explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2OdR

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 111,734.064 ↑ 1.0 25 1

Limit (cost=0.56..5,796.73 rows=25 width=997) (actual time=111,731.043..111,734.064 rows=25 loops=1)

  • Buffers: shared hit=15,067 read=5,249,786
  • I/O Timings: read=45,614.715
2. 111,734.056 111,734.056 ↑ 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=111,731.041..111,734.056 rows=25 loops=1)

  • Filter: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Rows Removed by Filter: 45,000,009
  • Buffers: shared hit=15,067 read=5,249,786
  • I/O Timings: read=45,614.715