explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jmtz

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.247 ↑ 2.0 2 1

Sort (cost=42.51..42.52 rows=4 width=924) (actual time=0.246..0.247 rows=2 loops=1)

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

CTE application_project_description_detail

3. 0.034 0.215 ↑ 2.0 2 1

Hash Join (cost=27.77..42.23 rows=4 width=328) (actual time=0.213..0.215 rows=2 loops=1)

  • Hash Cond: (lp.id = apdd_1.loan_purpose_id)
4. 0.015 0.015 ↑ 80.0 4 1

Seq Scan on loan_purpose lp (cost=0.00..13.20 rows=320 width=222) (actual time=0.014..0.015 rows=4 loops=1)

5. 0.004 0.166 ↑ 2.0 2 1

Hash (cost=27.72..27.72 rows=4 width=82) (actual time=0.166..0.166 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.063 0.162 ↑ 2.0 2 1

Hash Join (cost=19.05..27.72 rows=4 width=82) (actual time=0.068..0.162 rows=2 loops=1)

  • Hash Cond: (i.id = apdd_1.industry_id)
7. 0.060 0.060 ↑ 1.0 337 1

Seq Scan on industry i (cost=0.00..7.37 rows=337 width=42) (actual time=0.012..0.060 rows=337 loops=1)

8. 0.008 0.039 ↑ 2.0 2 1

Hash (cost=19.00..19.00 rows=4 width=48) (actual time=0.039..0.039 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.031 0.031 ↑ 2.0 2 1

Seq Scan on application_project_description_detail apdd_1 (cost=0.00..19.00 rows=4 width=48) (actual time=0.029..0.031 rows=2 loops=1)

  • Filter: (application_project_description_id = 25)
  • Rows Removed by Filter: 25
10. 0.003 0.238 ↑ 2.0 2 1

Nested Loop (cost=0.10..0.23 rows=4 width=924) (actual time=0.235..0.238 rows=2 loops=1)

11. 0.003 0.234 ↑ 1.0 1 1

Limit (cost=0.10..0.10 rows=1 width=666) (actual time=0.232..0.234 rows=1 loops=1)

12. 0.011 0.231 ↑ 4.0 1 1

Sort (cost=0.10..0.11 rows=4 width=666) (actual time=0.231..0.231 rows=1 loops=1)

  • Sort Key: application_project_description_detail.project_cost DESC
  • Sort Method: quicksort Memory: 25kB
13. 0.220 0.220 ↑ 2.0 2 1

CTE Scan on application_project_description_detail (cost=0.00..0.08 rows=4 width=666) (actual time=0.216..0.220 rows=2 loops=1)

14. 0.001 0.001 ↑ 2.0 2 1

CTE Scan on application_project_description_detail apdd (cost=0.00..0.08 rows=4 width=290) (actual time=0.000..0.001 rows=2 loops=1)

Planning time : 0.789 ms
Execution time : 0.350 ms