explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RB0O

Settings
# exclusive inclusive rows x rows loops node
1. 0.939 43.799 ↑ 1.0 1 1

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

2. 2.231 42.860 ↑ 3.7 11,699 1

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

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

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

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

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

5. 4.248 30.033 ↓ 4.0 11,699 1

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

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

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

Planning time : 0.135 ms
Execution time : 44.702 ms