explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8uxi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=407.46..407.48 rows=1 width=49) (actual rows= loops=)

  • Group Key: profiles.id
  • Filter: (count(*) >= 1)
2. 0.000 0.000 ↓ 0.0

Sort (cost=407.46..407.46 rows=1 width=41) (actual rows= loops=)

  • Sort Key: profiles.id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.81..407.45 rows=1 width=41) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.26..391.29 rows=23 width=41) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on events (cost=4.84..213.84 rows=21 width=31) (actual rows= loops=)

  • Recheck Cond: ((site_id)::text = '5e55213d0d8cdf000726e813'::text)
  • Filter: ((type)::text = 'page'::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on events_site_id_idx (cost=0.00..4.83 rows=55 width=0) (actual rows= loops=)

  • Index Cond: ((site_id)::text = '5e55213d0d8cdf000726e813'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using anonymous_id_idx on profiles (cost=0.42..8.44 rows=1 width=75) (actual rows= loops=)

  • Index Cond: ((anonymous_id)::text = (events.anonymous_id)::text)
  • Filter: ((arena_user_id IS NOT NULL) OR (user_id IS NOT NULL))
8. 0.000 0.000 ↓ 0.0

Index Only Scan using profile_site_pkey on profile_site (cost=0.55..0.70 rows=1 width=41) (actual rows= loops=)

  • Index Cond: ((id = (profiles.id)::text) AND (site_id = '5e55213d0d8cdf000726e813'::text))