explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 31TgX

Settings
# exclusive inclusive rows x rows loops node
1. 4.458 22,485.338 ↑ 1,180.6 9 1

Unique (cost=4,502,692.95..4,502,755.25 rows=10,625 width=32) (actual time=22,477.131..22,485.338 rows=9 loops=1)

2. 0.000 22,480.880 ↓ 3.9 48,538 1

Sort (cost=4,502,692.95..4,502,724.10 rows=12,461 width=32) (actual time=22,477.128..22,480.880 rows=48,538 loops=1)

  • Sort Key: ((ahoy_events.properties ->> 'story'::text))
  • Sort Method: quicksort Memory: 4539kB
3. 506.904 22,912.220 ↓ 3.9 48,538 1

Gather (cost=135,452.04..4,501,845.28 rows=12,461 width=32) (actual time=3,667.272..22,912.220 rows=48,538 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1,113.511 22,405.316 ↓ 3.1 16,179 3

Nested Loop (cost=134,452.04..4,499,581.00 rows=5,192 width=32) (actual time=3,658.070..22,405.316 rows=16,179 loops=3)

5. 18,425.016 21,291.740 ↓ 3.1 16,317 3

Parallel Bitmap Heap Scan on ahoy_events (cost=134,451.62..4,481,517.48 rows=5,192 width=141) (actual time=3,657.547..21,291.740 rows=16,317 loops=3)

  • Recheck Cond: ((name)::text = 'Countdown Screen Reached'::text)
  • Rows Removed by Index Recheck: 12398471
  • Filter: ((properties ->> 'episode'::text) = '10'::text)
  • Rows Removed by Filter: 800817
  • Heap Blocks: exact=292235 lossy=352657
6. 2,866.724 2,866.724 ↑ 1.0 2,451,406 1

Bitmap Index Scan on index_ahoy_events_on_name_and_created_at (cost=0.00..134,448.50 rows=2,492,241 width=0) (actual time=2,866.724..2,866.724 rows=2,451,406 loops=1)

  • Index Cond: ((name)::text = 'Countdown Screen Reached'::text)
7. 0.065 0.065 ↑ 1.0 1 48,950

Index Only Scan using index_ahoy_visits_on_id on ahoy_visits (cost=0.42..3.48 rows=1 width=16) (actual time=0.065..0.065 rows=1 loops=48,950)

  • Index Cond: (id = ahoy_events.visit_id)
  • Heap Fetches: 7026