explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kfM

Settings
# exclusive inclusive rows x rows loops node
1. 48.916 4,354.436 ↑ 1.0 35,960 1

Gather Merge (cost=158,296.15..162,654.65 rows=37,356 width=997) (actual time=4,332.249..4,354.436 rows=35,960 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=363 read=34,783
  • I/O Timings: read=12,375.137
2. 16.267 4,305.520 ↑ 1.6 11,987 3 / 3

Sort (cost=157,296.12..157,342.82 rows=18,678 width=997) (actual time=4,304.197..4,305.520 rows=11,987 loops=3)

  • Sort Key: published_timestamp
  • Sort Method: quicksort Memory: 7,292kB
  • Worker 0: Sort Method: quicksort Memory: 6,229kB
  • Worker 1: Sort Method: quicksort Memory: 6,174kB
  • Buffers: shared hit=363 read=34,783
  • I/O Timings: read=12,375.137
3. 4,286.071 4,289.253 ↑ 1.6 11,987 3 / 3

Parallel Bitmap Heap Scan on published_event (cost=2,024.60..148,382.26 rows=18,678 width=997) (actual time=5.697..4,289.253 rows=11,987 loops=3)

  • Recheck Cond: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Heap Blocks: exact=13,074
  • Buffers: shared hit=345 read=34,783
  • I/O Timings: read=12,375.137
4. 3.182 3.182 ↑ 1.2 35,960 1 / 3

Bitmap Index Scan on idx_destination_topic_lower (cost=0.00..2,013.39 rows=44,827 width=0) (actual time=9.545..9.545 rows=35,960 loops=1)

  • Index Cond: (lower((destination_topic)::text) = 'socsec.nsso.discard'::text)
  • Buffers: shared hit=187
Planning time : 0.190 ms
Execution time : 4,356.767 ms