explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AZkD

Settings
# exclusive inclusive rows x rows loops node
1. 1,039.518 1,039.518 ↓ 0.0 0 1

Limit (cost=550,228.59..550,231.09 rows=1,000 width=174) (actual time=1,039.518..1,039.518 rows=0 loops=1)

  • -> Seq Scan on actions actions_1 (cost=0.00..266030.85 rows=47682 width=100) (actual time=1039.50
  • Filter: (agent_id = '14c53fb2-aeba-5c7f-beb4-405bf5e59ed1'::uuid)
  • Rows Removed by Filter: 9536348
  • -> Sort (cost=284197.74..284316.94 rows=47682 width=174) (actual time=1039.517..1039.517 rows=0 loo
  • Sort Key: results.created_at
  • Sort Method: quicksort Memory: 25kB
  • -> Nested Loop Left Join (cost=0.43..281583.39 rows=47682 width=174) (actual time=1039.510..1
  • -> CTE Scan on actions (cost=0.00..953.64 rows=47682 width=100) (actual time=1039.509..
  • -> Index Scan using results_pkey on results (cost=0.43..5.87 rows=1 width=57) (never ex
  • Index Cond: (actions.id = id)
Planning time : 0.204 ms
Execution time : 1,039.577 ms