explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O7uv

Settings
# exclusive inclusive rows x rows loops node
1. 2,662.892 2,662.892 ↑ 121.6 1,000 1

Index Scan using container_expiration_policies_pkey on container_expiration_policies (cost=0.43..69,916.15 rows=121,623 width=82) (actual time=0.087..2,662.892 rows=1,000 loops=1)

  • Index Cond: ((project_id >= 21,070,364) AND (project_id < 21781007))
  • Filter: (enabled AND (next_run_at < '2020-10-15 18:14:29.551899+00'::timestamp with time zone))
  • Rows Removed by Filter: 558,309
Planning time : 0.510 ms
Execution time : 2,663.025 ms