explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EuHW

Settings
# exclusive inclusive rows x rows loops node
1. 51.438 34,394.001 ↓ 1.1 54,399 1

Gather (cost=2,244.41..170,548.58 rows=50,457 width=66) (actual time=849.225..34,394.001 rows=54,399 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 5,390.192 34,342.563 ↑ 1.1 27,200 2 / 2

Nested Loop Left Join (cost=1,244.41..164,502.88 rows=29,681 width=66) (actual time=846.299..34,342.563 rows=27,200 loops=2)

3. 8,623.539 9,042.337 ↑ 1.1 27,200 2 / 2

Parallel Bitmap Heap Scan on ahoy_events ae (cost=1,244.32..87,583.69 rows=29,681 width=210) (actual time=845.797..9,042.337 rows=27,200 loops=2)

  • Recheck Cond: (name = 'Order Completed'::text)
  • Heap Blocks: exact=25,793
4. 418.798 418.798 ↓ 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,457 width=0) (actual time=837.596..837.596 rows=54,399 loops=1)

  • Index Cond: (name = 'Order Completed'::text)
5. 19,910.034 19,910.034 ↑ 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.732..0.732 rows=1 loops=54,399)

  • Index Cond: (id = ae.ahoy_visit_id)
Planning time : 9.077 ms
Execution time : 34,401.074 ms