explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4TXy

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.077 ↑ 1.0 1 1

Nested Loop (cost=1.57..34.81 rows=1 width=54) (actual time=0.066..0.077 rows=1 loops=1)

2. 0.007 0.065 ↑ 1.0 1 1

Nested Loop (cost=1.29..26.50 rows=1 width=31) (actual time=0.056..0.065 rows=1 loops=1)

  • Join Filter: (credit_request.loan_type_id = loan_type.loan_type_id)
  • Rows Removed by Join Filter: 5
3. 0.003 0.053 ↑ 1.0 1 1

Nested Loop (cost=1.29..25.36 rows=1 width=39) (actual time=0.049..0.053 rows=1 loops=1)

4. 0.004 0.041 ↑ 1.0 1 1

Nested Loop (cost=0.86..16.91 rows=1 width=23) (actual time=0.039..0.041 rows=1 loops=1)

5. 0.026 0.026 ↑ 1.0 1 1

Index Scan using application_credit_request_idx on application (cost=0.43..8.45 rows=1 width=24) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: (credit_request_id = 2152721)
6. 0.011 0.011 ↑ 1.0 1 1

Index Scan using application_data_pkey on application_data (cost=0.43..8.45 rows=1 width=11) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (application_data_id = application.application_data_id)
7. 0.009 0.009 ↑ 1.0 1 1

Index Scan using credit_request_pkey on credit_request (cost=0.43..8.45 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (credit_request_id = 2152721)
8. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on loan_type (cost=0.00..1.06 rows=6 width=4) (actual time=0.002..0.005 rows=6 loops=1)

9. 0.006 0.006 ↑ 1.0 1 1

Index Scan using retailers_pkey on retailers (cost=0.28..8.30 rows=1 width=31) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (retailer_id = credit_request.retailer_id)