explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QcbF

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.099 ↓ 2.0 2 1

Nested Loop Anti Join (cost=0.42..6.16 rows=1 width=21) (actual time=0.051..0.099 rows=2 loops=1)

2. 0.005 0.088 ↓ 2.0 2 1

Nested Loop Left Join (cost=0.26..5.52 rows=1 width=5) (actual time=0.044..0.088 rows=2 loops=1)

  • Join Filter: (ci_builds.project_id = projects.id)
3. 0.006 0.077 ↓ 2.0 2 1

Nested Loop (cost=0.14..3.38 rows=1 width=4) (actual time=0.036..0.077 rows=2 loops=1)

4. 0.053 0.053 ↓ 2.0 2 1

Seq Scan on routes rs (cost=0.00..2.14 rows=1 width=4) (actual time=0.018..0.053 rows=2 loops=1)

  • Filter: (((path)::text ~~ 'gitlab-org/%'::text) AND ((source_type)::text = 'Project'::text))
  • Rows Removed by Filter: 79
5. 0.018 0.018 ↑ 1.0 1 2

Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on projects (cost=0.14..1.16 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (id = rs.source_id)
  • Heap Fetches: 2
6. 0.002 0.006 ↓ 0.0 0 2

Limit (cost=0.12..2.12 rows=1 width=5) (actual time=0.003..0.003 rows=0 loops=2)

7. 0.004 0.004 ↓ 0.0 0 2

Index Only Scan using index_ci_builds_on_project_id_for_successfull_pages_deploy on ci_builds (cost=0.12..2.12 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=2)

  • Heap Fetches: 0
8. 0.004 0.004 ↓ 0.0 0 2

Index Only Scan using index_project_pages_metadata_on_project_id on project_pages_metadata (cost=0.15..0.63 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (project_id = projects.id)
  • Heap Fetches: 0
Planning time : 1.669 ms
Execution time : 0.175 ms