explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A23F

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.025 ↓ 0.0 0 1

Sort (cost=633.27..634.11 rows=337 width=138) (actual time=0.024..0.025 rows=0 loops=1)

  • Sort Key: deployments.updated_at DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
2. 0.013 0.013 ↓ 0.0 0 1

Index Scan using index_deployments_on_project_id_and_status on public.deployments (cost=0.56..619.12 rows=337 width=138) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (deployments.project_id = 1)
  • Buffers: shared hit=4