explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qpq2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.038 ↑ 1.0 1 1

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

2. 0.031 0.031 ↑ 1.0 1 1

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

3. 0.022 0.022 ↑ 1.0 1 1

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

4. 0.015 0.015 ↑ 1.0 1 1

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

5. 0.009 0.009 ↑ 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.008..0.009 rows=1 loops=1)

6. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

7. 0.006 0.006 ↑ 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.006..0.006 rows=1 loops=1)

8. 0.004 0.004 ↑ 1.0 6 1

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

9. 0.004 0.004 ↑ 1.0 1 1

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