explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AdLIl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 17.201 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.42..85.16 rows=3 width=756) (actual time=17.201..17.201 rows=0 loops=1)

2. 0.001 17.201 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..60.10 rows=3 width=240) (actual time=17.201..17.201 rows=0 loops=1)

3. 0.000 17.200 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..35.20 rows=3 width=171) (actual time=17.200..17.200 rows=0 loops=1)

4. 0.001 17.200 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.58..34.04 rows=3 width=146) (actual time=17.200..17.200 rows=0 loops=1)

5. 17.199 17.199 ↓ 0.0 0 1

Index Scan using ix_permitadvisor_permitid on permitadvisor pa (cost=0.29..9.13 rows=3 width=94) (actual time=17.199..17.199 rows=0 loops=1)

  • Index Cond: (permitid = 25007)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on "user" u (cost=0.29..8.30 rows=1 width=56) (never executed)

  • Index Cond: (id = pa.userid)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organisation on organisation uorg (cost=0.28..0.39 rows=1 width=33) (never executed)

  • Index Cond: (u.organisationid = id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_permitexternaladvisor on permitexternaladvisor pea (cost=0.28..8.29 rows=1 width=73) (never executed)

  • Index Cond: (id = pa.externaluserid)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on "user" approveusr (cost=0.29..8.30 rows=1 width=22) (never executed)

  • Index Cond: (id = pa.approvedby)
10.          

SubPlan (forNested Loop Left Join)

11. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=516) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=50) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

Planning time : 22.627 ms