explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lKQA

Settings
# exclusive inclusive rows x rows loops node
1. 0.065 0.065 ↑ 1.0 25 1

Limit (cost=0.56..6.10 rows=25 width=997) (actual time=0.052..0.065 rows=25 loops=1)

  • Buffers: shared hit=7 read=1
  • I/O Timings: read=0.010
  • (actual time=0.051..0.061 rows=25 loops=1)
  • '14-MAY-20 00:00:00'::timestamp without time zone))
2. 0.000 0.000 ↓ 0.0

Index Scan Backward using idx_published_timestamp on published_event (cost=0.56..223,981.78 rows=1,011,325 width=997) (actual rows= loops=)

  • Index Cond: ((published_timestamp > '13-MAY-20 00:00:00'::timestamp without time zone) AND (published_timestamp <
  • Buffers: shared hit=7 read=1
  • I/O Timings: read=0.010
Planning time : 0.175 ms
Execution time : 0.104 ms