explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LugH

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 123,631.495 ↑ 1.0 25 1

Limit (cost=0.56..5,796.73 rows=25 width=997) (actual time=123,624.637..123,631.495 rows=25 loops=1)

  • Buffers: shared hit=15,067 read=5,249,786
  • I/O Timings: read=58,005.404
2. 123,631.485 123,631.485 ↑ 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=123,624.633..123,631.485 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=58,005.404
Planning time : 9.800 ms
Execution time : 123,631.596 ms