explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BmN7

Settings
# exclusive inclusive rows x rows loops node
1. 5.349 58.767 ↓ 24.6 221 1

GroupAggregate (cost=107.60..107.87 rows=9 width=67) (actual time=52.998..58.767 rows=221 loops=1)

  • Group Key: wc.web_client_type, wc.web_client_name, wc.web_client_version, wc.web_client_os_name, wc.web_client_device_type
  • Buffers: shared hit=17260
2. 21.127 53.418 ↓ 478.0 4,302 1

Sort (cost=107.60..107.63 rows=9 width=43) (actual time=52.767..53.418 rows=4,302 loops=1)

  • Sort Key: wc.web_client_type, wc.web_client_name, wc.web_client_version, wc.web_client_os_name, wc.web_client_device_type
  • Sort Method: quicksort Memory: 596kB
  • Buffers: shared hit=17260
3. 19.385 32.291 ↓ 478.0 4,302 1

Nested Loop (cost=0.84..107.46 rows=9 width=43) (actual time=0.079..32.291 rows=4,302 loops=1)

  • Buffers: shared hit=17260
  • -> Index Scan using "t_interaction_form_views_web_client_daily$pk" on t_interaction_form_views_web_client_daily ti (cost=0.56..40.78 rows=9 width=16) (actual time=0.055..13.872 rows=430
  • Index Cond: ((organization_uuid = 'ceb7f4e9-60e6-427b-b8dc-1762f9e0ba22'::uuid) AND (activity_definition_instance_id = '09e3f8f4-63f1-40d1-8fac-ba24c3588221'::uuid) AND (event_date_
  • Buffers: shared hit=4354
4. 12.906 12.906 ↑ 1.0 1 4,302

Index Scan using t_web_client_dim_pkey on t_web_client_dim wc (cost=0.28..7.41 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=4,302)

  • Index Cond: (web_client_key = ti.web_client_key)
  • Buffers: shared hit=12906