explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8bD2

Settings
# exclusive inclusive rows x rows loops node
1. 2.681 8.727 ↑ 1.0 1 1

Aggregate (cost=3,687.27..3,687.30 rows=1 width=8) (actual time=8.727..8.727 rows=1 loops=1)

  • Buffers: shared hit=236 read=2
  • I/O Timings: read=1.355
2. 6.046 6.046 ↑ 1.2 35,960 1

Index Only Scan using idx_destination_topic on published_event (cost=0.69..3,575.20 rows=44,827 width=0) (actual time=1.345..6.046 rows=35,960 loops=1)

  • Index Cond: (destination_topic = 'socsec.nsso.discard'::text)
  • Heap Fetches: 0
  • Buffers: shared hit=236 read=2
  • I/O Timings: read=1.355
Planning time : 0.104 ms
Execution time : 8.776 ms