explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcVP

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 124,139.641 ↑ 1.0 25 1

Limit (cost=0.56..5,796.73 rows=25 width=997) (actual time=124,132.835..124,139.641 rows=25 loops=1)

  • Buffers: shared hit=15,018 read=5,249,835
  • I/O Timings: read=59,414.544
2. 124,139.632 124,139.632 ↑ 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=124,132.832..124,139.632 rows=25 loops=1)

  • Filter: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Rows Removed by Filter: 45,000,009
  • Buffers: shared hit=15,018 read=5,249,835
  • I/O Timings: read=59,414.544
Planning time : 0.732 ms
Execution time : 124,154.736 ms