explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WmZ9

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.081 ↓ 2.0 2 1

Sort (cost=17.85..17.86 rows=1 width=924) (actual time=0.081..0.081 rows=2 loops=1)

  • Sort Key: apdd.id DESC
  • Sort Method: quicksort Memory: 25kB
2.          

CTE application_project_description_detail

3. 0.006 0.056 ↓ 2.0 2 1

Nested Loop (cost=0.29..17.77 rows=1 width=328) (actual time=0.050..0.056 rows=2 loops=1)

4. 0.006 0.038 ↓ 2.0 2 1

Nested Loop (cost=0.15..9.55 rows=1 width=262) (actual time=0.034..0.038 rows=2 loops=1)

5. 0.014 0.014 ↓ 2.0 2 1

Seq Scan on application_project_description_detail apdd_1 (cost=0.00..1.34 rows=1 width=48) (actual time=0.013..0.014 rows=2 loops=1)

  • Filter: (application_project_description_id = 25)
  • Rows Removed by Filter: 25
6. 0.018 0.018 ↑ 1.0 1 2

Index Scan using loan_purpose_pkey on loan_purpose lp (cost=0.15..8.17 rows=1 width=222) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (id = apdd_1.loan_purpose_id)
7. 0.012 0.012 ↑ 1.0 1 2

Index Scan using industry_pkey on industry i (cost=0.15..8.17 rows=1 width=42) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: (id = apdd_1.industry_id)
8. 0.002 0.072 ↓ 2.0 2 1

Nested Loop (cost=0.03..0.08 rows=1 width=924) (actual time=0.070..0.072 rows=2 loops=1)

9. 0.054 0.054 ↓ 2.0 2 1

CTE Scan on application_project_description_detail apdd (cost=0.00..0.02 rows=1 width=290) (actual time=0.053..0.054 rows=2 loops=1)

10. 0.000 0.016 ↑ 1.0 1 2

Limit (cost=0.03..0.04 rows=1 width=666) (actual time=0.008..0.008 rows=1 loops=2)

11. 0.008 0.016 ↑ 1.0 1 2

Sort (cost=0.03..0.04 rows=1 width=666) (actual time=0.007..0.008 rows=1 loops=2)

  • Sort Key: application_project_description_detail.project_cost DESC
  • Sort Method: quicksort Memory: 25kB
12. 0.008 0.008 ↓ 2.0 2 1

CTE Scan on application_project_description_detail (cost=0.00..0.02 rows=1 width=666) (actual time=0.001..0.008 rows=2 loops=1)

Planning time : 0.579 ms
Execution time : 0.142 ms