explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vuc

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4.996 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..1,015.95 rows=3 width=756) (actual time=4.996..4.996 rows=0 loops=1)

2. 0.000 4.995 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.84..990.88 rows=3 width=240) (actual time=4.995..4.995 rows=0 loops=1)

3. 0.000 4.995 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.57..965.98 rows=3 width=171) (actual time=4.995..4.995 rows=0 loops=1)

4. 0.002 4.995 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..964.83 rows=3 width=146) (actual time=4.995..4.995 rows=0 loops=1)

5. 4.993 4.993 ↓ 0.0 0 1

Seq Scan on permitadvisor pa (cost=0.00..939.91 rows=3 width=94) (actual time=4.993..4.993 rows=0 loops=1)

  • Filter: (permitid = 25007)
  • Rows Removed by Filter: 40473
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)