explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SKWs

Settings
# exclusive inclusive rows x rows loops node
1. 4.609 4.609 ↑ 10.5 2 1

Index Scan using device_locale_account_id_idx on ifood_account_devices.device_event (cost=0.58..954.09 rows=21 width=202) (actual time=4.607..4.609 rows=2 loops=1)

  • Output: id, account_id, device_id, action, latitude, longitude, cloud_id, platform, device_description, occurrences, created_at, updated_at, email, location, accept_language, tenant_id, ip
  • Index Cond: (device_event.account_id = '94dc4509-5c2b-40c7-b826-c70556290ab3'::uuid)
  • Filter: (((device_event.action)::text = ANY ('{LEGACY,ACCOUNT_CREATION}'::text[])) AND (device_event.device_id <> 'unknown'::text) AND (device_event.device_id <> '-1'::text))
  • Rows Removed by Filter: 5,068
  • Buffers: shared hit=5,065
Planning time : 0.137 ms
Execution time : 4.632 ms