explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7byV

Settings
# exclusive inclusive rows x rows loops node
1. 19.408 271.550 ↑ 3.7 33,794 1

WindowAgg (cost=294,839.63..297,020.19 rows=124,603 width=546) (actual time=247.170..271.550 rows=33,794 loops=1)

2. 40.233 252.142 ↑ 3.7 33,794 1

Sort (cost=294,839.63..295,151.14 rows=124,603 width=542) (actual time=247.155..252.142 rows=33,794 loops=1)

  • Sort Key: events.msg_offset
  • Sort Method: quicksort Memory: 36,331kB
3. 44.646 211.909 ↑ 3.7 33,794 1

Hash Join (cost=5,624.11..284,293.87 rows=124,603 width=542) (actual time=46.066..211.909 rows=33,794 loops=1)

  • Hash Cond: (events.cluster_id = clusters.cluster_id)
4. 131.805 167.205 ↑ 1.0 281,535 1

Bitmap Heap Scan on events (cost=5,622.47..281,971.50 rows=286,587 width=550) (actual time=45.996..167.205 rows=281,535 loops=1)

  • Recheck Cond: ((msg_offset >= 63,900,326) AND (msg_offset <= 64,182,340))
  • Filter: ((type)::text = ANY ('{prices-v1,reference-data-v5,product-base-document,search-product,location,selling-restrictions}'::text[]))
  • Rows Removed by Filter: 480
  • Heap Blocks: exact=50,520
5. 35.400 35.400 ↑ 1.0 282,015 1

Bitmap Index Scan on events_pkey (cost=0.00..5,550.82 rows=286,969 width=0) (actual time=35.400..35.400 rows=282,015 loops=1)

  • Index Cond: ((msg_offset >= 63,900,326) AND (msg_offset <= 64,182,340))
6. 0.032 0.058 ↑ 1.4 7 1

Hash (cost=1.52..1.52 rows=10 width=8) (actual time=0.058..0.058 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.026 0.026 ↑ 1.4 7 1

Seq Scan on clusters (cost=0.00..1.52 rows=10 width=8) (actual time=0.010..0.026 rows=7 loops=1)

  • Filter: ((cluster_uuid)::text = ANY ('{NONE,417bda80-bfba-412c-9b52-c35d68530342,0ebc3b5d-81be-4f20-9c7d-022afe913356,05e7673f-b28d-491a-82b4-08a836112e2a,9938734d-6991-4497-aea4-68a8b1c40ffc,6c1b27c2-911d-4abf-be6b-6e043713f490,bfc03ffe-e78f-4aee-a2ec-b7b2c616dfa6,7293a0f2-bd28-4b73-b81c-5165d3ddded0,97b05cbb-897d-49ca-b338-330a38d3bd82,769d8c7f-8d92-4423-8f92-ab2331206ed6}'::text[]))
  • Rows Removed by Filter: 16
Planning time : 0.600 ms
Execution time : 278.631 ms