explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CT1

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 25.992 ↑ 3.0 1 1

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

2. 0.002 25.975 ↑ 3.0 1 1

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

3. 0.002 25.969 ↑ 3.0 1 1

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

4. 0.006 25.956 ↑ 3.0 1 1

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

5. 25.935 25.935 ↑ 3.0 1 1

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

  • Index Cond: (permitid = 25006)
6. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_user on "user" u (cost=0.29..8.30 rows=1 width=56) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id = pa.userid)
7. 0.011 0.011 ↑ 1.0 1 1

Index Scan using pk_organisation on organisation uorg (cost=0.28..0.39 rows=1 width=33) (actual time=0.011..0.011 rows=1 loops=1)

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

Index Scan using pk_permitexternaladvisor on permitexternaladvisor pea (cost=0.28..8.29 rows=1 width=73) (actual time=0.004..0.004 rows=0 loops=1)

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

Index Scan using pk_user on "user" approveusr (cost=0.29..8.30 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=1)

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

SubPlan (forNested Loop Left Join)

11. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)

12. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=516) (actual time=0.000..0.000 rows=1 loops=1)

13. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=50) (actual time=0.000..0.000 rows=1 loops=1)

14. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1)