explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOsH

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 5.393 ↑ 1.0 1 1

Aggregate (cost=309.39..309.40 rows=1 width=8) (actual time=5.393..5.393 rows=1 loops=1)

2. 0.224 5.354 ↓ 0.0 0 1

Hash Join (cost=228.49..309.38 rows=1 width=4) (actual time=5.354..5.354 rows=0 loops=1)

  • Hash Cond: (design_management_designs.project_id = projects.id)
3. 2.237 2.237 ↓ 1.0 2,320 1

Index Only Scan using index_design_management_designs_on_project_id on design_management_designs (cost=0.28..72.52 rows=2,304 width=4) (actual time=0.027..2.237 rows=2,320 loops=1)

  • Heap Fetches: 1100
4. 0.085 2.893 ↑ 1.0 147 1

Hash (cost=226.33..226.33 rows=151 width=4) (actual time=2.893..2.893 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
5. 2.808 2.808 ↑ 1.0 147 1

Index Scan using index_projects_on_repository_storage on projects (cost=0.56..226.33 rows=151 width=4) (actual time=1.792..2.808 rows=147 loops=1)

  • Index Cond: ((repository_storage)::text = 'default'::text)
Planning time : 0.879 ms
Execution time : 5.480 ms