explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sA6w

Settings
# exclusive inclusive rows x rows loops node
1. 3.948 60.910 ↑ 1.0 1 1

Aggregate (cost=1,495.53..1,495.54 rows=1 width=8) (actual time=60.910..60.910 rows=1 loops=1)

2. 5.299 56.962 ↑ 3.7 11,699 1

Merge Join (cost=732.29..1,388.59 rows=42,778 width=4) (actual time=48.881..56.962 rows=11,699 loops=1)

  • Merge Cond: (projects.id = design_management_designs.project_id)
3. 1.431 12.765 ↓ 1.4 4,001 1

Sort (cost=366.15..373.46 rows=2,925 width=4) (actual time=12.153..12.765 rows=4,001 loops=1)

  • Sort Key: projects.id
  • Sort Method: quicksort Memory: 284kB
4. 11.334 11.334 ↓ 1.4 4,001 1

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

5. 7.135 38.898 ↓ 4.0 11,699 1

Sort (cost=366.15..373.46 rows=2,925 width=4) (actual time=36.719..38.898 rows=11,699 loops=1)

  • Sort Key: design_management_designs.project_id
  • Sort Method: quicksort Memory: 933kB
6. 31.763 31.763 ↓ 4.0 11,699 1

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

Planning time : 0.135 ms
Execution time : 61.762 ms