explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZuJ

Settings
# exclusive inclusive rows x rows loops node
1. 39.246 770.382 ↓ 1.1 54,399 1

Gather (cost=2,244.41..170,512.71 rows=50,458 width=62) (actual time=29.688..770.382 rows=54,399 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 22.113 731.136 ↑ 1.1 27,200 2 / 2

Nested Loop Left Join (cost=1,244.41..164,466.91 rows=29,681 width=62) (actual time=26.149..731.136 rows=27,200 loops=2)

3. 346.734 355.429 ↑ 1.1 27,200 2 / 2

Parallel Bitmap Heap Scan on ahoy_events ae (cost=1,244.32..87,585.48 rows=29,681 width=4) (actual time=26.096..355.429 rows=27,200 loops=2)

  • Recheck Cond: (name = 'Order Completed'::text)
  • Heap Blocks: exact=26,615
4. 8.694 8.694 ↓ 1.1 54,399 1 / 2

Bitmap Index Scan on index_ahoy_events_on_name_and_time (cost=0.00..1,241.80 rows=50,458 width=0) (actual time=17.389..17.389 rows=54,399 loops=1)

  • Index Cond: (name = 'Order Completed'::text)
5. 353.594 353.594 ↑ 1.0 1 54,399 / 2

Index Scan using ahoy_visits_pkey on ahoy_visits av (cost=0.09..2.59 rows=1 width=66) (actual time=0.013..0.013 rows=1 loops=54,399)

  • Index Cond: (id = ae.ahoy_visit_id)
Planning time : 7.142 ms
Execution time : 773.487 ms