explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uloh

Settings
# exclusive inclusive rows x rows loops node
1. 4.586 86,156.118 ↑ 1,180.9 9 1

Unique (cost=4,504,585.72..4,504,648.05 rows=10,628 width=32) (actual time=86,147.739..86,156.118 rows=9 loops=1)

2. 0.000 86,151.532 ↓ 3.9 48,553 1

Sort (cost=4,504,585.72..4,504,616.88 rows=12,466 width=32) (actual time=86,147.737..86,151.532 rows=48,553 loops=1)

  • Sort Key: ((ahoy_events.properties ->> 'story'::text))
  • Sort Method: quicksort Memory: 4540kB
3. 521.138 86,585.563 ↓ 3.9 48,553 1

Gather (cost=135,503.92..4,503,737.67 rows=12,466 width=32) (actual time=28,160.369..86,585.563 rows=48,553 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,124.428 86,064.425 ↓ 3.1 16,184 3

Nested Loop (cost=134,503.92..4,501,472.89 rows=5,194 width=32) (actual time=28,151.900..86,064.425 rows=16,184 loops=3)

5. 56,399.199 83,939.872 ↓ 3.1 16,322 3

Parallel Bitmap Heap Scan on ahoy_events (cost=134,503.49..4,483,400.40 rows=5,194 width=141) (actual time=28,150.437..83,939.872 rows=16,322 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: 801133
  • Heap Blocks: exact=309546 lossy=371701
6. 27,540.673 27,540.673 ↑ 1.0 2,452,407 1

Bitmap Index Scan on index_ahoy_events_on_name_and_created_at (cost=0.00..134,500.38 rows=2,493,291 width=0) (actual time=27,540.673..27,540.673 rows=2,452,407 loops=1)

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

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

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