explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6id6

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.009 ↓ 0.0 0 1

Sort (cost=6.63..6.64 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: projects.repository_retry_at
  • Sort Method: quicksort Memory: 25kB
2.          

CTE failed_repositories

3. 0.001 0.005 ↓ 0.0 0 1

Limit (cost=0.56..6.60 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)

4. 0.004 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.60 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • -> Index Scan using idx_repository_states_on_repository_failure_partial on project_repository_states (cost=0.12..3.14 rows=1 width=12) (actual time=0.004..0.004 rows=0 loo
  • Filter: (repository_retry_at < '2018-11-30 16:43:53.006464+00'::timestamp with time zone)
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projects_pkey on projects projects_1 (cost=0.43..3.45 rows=1 width=4) (never executed)

  • Index Cond: (id = project_repository_states.project_id)
  • Heap Fetches: 0
6. 0.005 0.005 ↓ 0.0 0 1

CTE Scan on failed_repositories projects (cost=0.00..0.02 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)