explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AAFq

Settings
# exclusive inclusive rows x rows loops node
1. 36,398.304 174,412.675 ↓ 46.4 649 1

Nested Loop (cost=664.60..672.67 rows=14 width=4) (actual time=1,397.806..174,412.675 rows=649 loops=1)

2. 5.578 1,401.541 ↓ 1,569.0 1,569 1

HashAggregate (cost=564.31..564.32 rows=1 width=8) (actual time=1,397.151..1,401.541 rows=1,569 loops=1)

  • Group Key: application_renewal.renewal_product
3. 1,395.963 1,395.963 ↓ 1,586.0 1,586 1

Foreign Scan on application application_renewal (cost=167.87..564.31 rows=1 width=8) (actual time=18.893..1,395.963 rows=1,586 loops=1)

  • Filter: ((status)::application_status_type = 'FUNDED'::application_status_type)
  • Rows Removed by Filter: 374
4. 136,612.830 136,612.830 ↓ 0.0 0 1,569

Foreign Scan on business_loan (cost=100.29..108.34 rows=1 width=4) (actual time=87.070..87.070 rows=0 loops=1,569)

Planning time : 4,048.920 ms
Execution time : 174,430.242 ms