explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Y4Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.728 49.540 ↑ 1.0 1 1

Aggregate (cost=434.91..434.92 rows=1 width=8) (actual time=49.540..49.540 rows=1 loops=1)

2. 1.906 48.812 ↓ 2.6 3,852 1

Hash Join (cost=309.56..431.26 rows=1,462 width=4) (actual time=37.323..48.812 rows=3,852 loops=1)

  • Hash Cond: (projects.id = design_management_designs.project_id)
3. 10.490 10.490 ↓ 1.4 4,001 1

Foreign Scan on projects (cost=100.00..197.75 rows=2,925 width=4) (actual time=0.859..10.490 rows=4,001 loops=1)

4. 1.212 36.416 ↓ 19.3 3,852 1

Hash (cost=207.06..207.06 rows=200 width=4) (actual time=36.416..36.416 rows=3,852 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 168kB
5. 6.337 35.204 ↓ 19.3 3,852 1

HashAggregate (cost=205.06..207.06 rows=200 width=4) (actual time=33.753..35.204 rows=3,852 loops=1)

  • Group Key: design_management_designs.project_id
6. 28.867 28.867 ↓ 4.0 11,699 1

Foreign Scan on design_management_designs (cost=100.00..197.75 rows=2,925 width=4) (actual time=0.464..28.867 rows=11,699 loops=1)

Planning time : 0.159 ms
Execution time : 50.127 ms