explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3LnI : https://gitlab.com/gitlab-org/gitlab/merge_requests/20173#note_251915874

Settings
# exclusive inclusive rows x rows loops node
1. 2.247 7.466 ↑ 1.0 1 1

Aggregate (cost=484.26..484.27 rows=1 width=8) (actual time=7.465..7.466 rows=1 loops=1)

  • Buffers: shared hit=149
2. 2.581 5.219 ↑ 1.0 11,699 1

Hash Join (cost=204.28..455.01 rows=11,699 width=4) (actual time=1.414..5.219 rows=11,699 loops=1)

  • Hash Cond: (design_management_designs.project_id = projects.id)
  • Buffers: shared hit=149
3. 1.251 1.251 ↑ 1,299.9 9 1

Seq Scan on design_management_designs (cost=0.00..219.99 rows=11,699 width=4) (actual time=0.010..1.251 rows=9 loops=1)

  • Buffers: shared hit=103
4. 0.535 1.387 ↓ 1.0 4,001 1

Hash (cost=154.28..154.28 rows=4,000 width=4) (actual time=1.387..1.387 rows=4,001 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 173kB
  • Buffers: shared hit=46
5. 0.852 0.852 ↓ 1.0 4,001 1

Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on projects (cost=0.28..154.28 rows=4,000 width=4) (actual time=0.011..0.852 rows=4,001 loops=1)

  • Index Cond: (repository_storage = 'default'::text)
  • Heap Fetches: 48
  • Buffers: shared hit=46
Planning time : 0.556 ms
Execution time : 7.528 ms