explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ilkL

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 1,883.355 ↑ 10.5 2 1

Sort (cost=954.55..954.61 rows=21 width=202) (actual time=1,883.355..1,883.355 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
  • Sort Key: device_event.created_at
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=24 read=5,044 dirtied=6
2. 1,883.314 1,883.314 ↑ 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=1,882.583..1,883.314 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=21 read=5,044 dirtied=6
Planning time : 21.809 ms
Execution time : 1,883.403 ms