explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KXxk

Settings
# exclusive inclusive rows x rows loops node
1. 0.224 20.385 ↓ 11.0 11 1

GroupAggregate (cost=536.12..536.14 rows=1 width=22) (actual time=20.209..20.385 rows=11 loops=1)

  • Group Key: e.event
2. 0.497 20.161 ↓ 895.0 895 1

Sort (cost=536.12..536.12 rows=1 width=14) (actual time=20.090..20.161 rows=895 loops=1)

  • Sort Key: e.event
  • Sort Method: quicksort Memory: 79kB
3. 0.158 19.664 ↓ 895.0 895 1

Nested Loop (cost=0.99..536.11 rows=1 width=14) (actual time=0.052..19.664 rows=895 loops=1)

4. 0.019 0.019 ↑ 1.0 1 1

Index Scan using profiles_pkey on profiles p (cost=0.42..8.44 rows=1 width=33) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((id)::text = 'aid_859fb58c-18c2-4df3-b82e-935b8e425466'::text)
5. 19.487 19.487 ↓ 895.0 895 1

Index Scan using events_anonymous_id_idx on events e (cost=0.56..527.66 rows=1 width=35) (actual time=0.029..19.487 rows=895 loops=1)

  • Index Cond: ((anonymous_id)::text = (p.anonymous_id)::text)
  • Filter: ((event IS NOT NULL) AND ((site_id)::text = 'eq4xTsvKZZYX3Nyb1hajkkwZdO03'::text) AND ("timestamp" >= (CURRENT_DATE - '30 days'::interval day)))
  • Rows Removed by Filter: 5410
Planning time : 0.517 ms
Execution time : 20.440 ms