explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HB6d

Settings
# exclusive inclusive rows x rows loops node
1. 40.719 513.703 ↓ 1.1 54,401 1

Gather (cost=1,586.60..170,233.17 rows=50,584 width=62) (actual time=23.774..513.703 rows=54,401 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 26.181 472.984 ↑ 1.1 27,200 2 / 2

Nested Loop Left Join (cost=586.60..164,174.77 rows=29,755 width=62) (actual time=20.903..472.984 rows=27,200 loops=2)

3. 222.911 229.199 ↑ 1.1 27,200 2 / 2

Parallel Bitmap Heap Scan on ahoy_events ae (cost=586.52..87,123.44 rows=29,755 width=4) (actual time=20.850..229.199 rows=27,200 loops=2)

  • Recheck Cond: (name = 'Order Completed'::text)
  • Heap Blocks: exact=29,298
4. 6.288 6.288 ↓ 1.1 54,401 1 / 2

Bitmap Index Scan on index_ahoy_events_on_name (cost=0.00..583.99 rows=50,584 width=0) (actual time=12.576..12.576 rows=54,401 loops=1)

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

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

  • Index Cond: (id = ae.ahoy_visit_id)
Planning time : 0.374 ms
Execution time : 516.576 ms