explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vh9W

Settings
# exclusive inclusive rows x rows loops node
1. 0.643 678.921 ↑ 1.0 1,000 1

Sort (cost=3,413.58..3,416.08 rows=1,000 width=12) (actual time=678.829..678.921 rows=1,000 loops=1)

  • Sort Key: projects.last_repository_updated_at
  • Sort Method: quicksort Memory: 71kB
  • Buffers: shared hit=4,051 read=161 dirtied=53
  • I/O Timings: read=559.000
2.          

CTE reverifiable_repositories

3. 0.247 677.465 ↑ 1.0 1,000 1

Limit (cost=1.57..3,343.75 rows=1,000 width=12) (actual time=6.076..677.465 rows=1,000 loops=1)

  • Buffers: shared hit=4,048 read=161 dirtied=53
  • I/O Timings: read=559.000
4. 2.077 677.218 ↑ 124.8 1,000 1

Merge Join (cost=1.57..417,182.84 rows=124,823 width=12) (actual time=6.074..677.218 rows=1,000 loops=1)

  • Merge Cond: (projects_1.id = project_repository_states.project_id)
  • Buffers: shared hit=4,048 read=161 dirtied=53
  • I/O Timings: read=559.000
5. 279.203 279.203 ↑ 259.7 1,010 1

Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on public.projects projects_1 (cost=0.56..441,978.53 rows=262,262 width=12) (actual time=2.448..279.203 rows=1,010 loops=1)

  • Index Cond: (projects_1.repository_storage = 'nfs-file07'::text)
  • Heap Fetches: 20
  • Buffers: shared hit=556 read=83 dirtied=8
  • I/O Timings: read=274.601
6. 395.938 395.938 ↑ 859.1 8,150 1

Index Only Scan using idx_repository_states_on_last_repository_verification_ran_at on public.project_repository_states (cost=0.43..165,917.28 rows=7,002,034 width=4) (actual time=3.572..395.938 rows=8,150 loops=1)

  • Heap Fetches: 78
  • Filter: ((project_repository_states.last_repository_verification_ran_at IS NULL) OR (project_repository_states.last_repository_verification_ran_at <= '2020-07-30 18:27:40.847082+00'::timestamp with time zone))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3,492 read=78 dirtied=45
  • I/O Timings: read=284.399
7. 678.278 678.278 ↑ 1.0 1,000 1

CTE Scan on reverifiable_repositories projects (cost=0.00..20.00 rows=1,000 width=12) (actual time=6.079..678.278 rows=1,000 loops=1)

  • Buffers: shared hit=4,048 read=161 dirtied=53
  • I/O Timings: read=559.000