explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 79eI

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 2.630 ↓ 2.3 261 1

Append (cost=1.98..3,287.58 rows=112 width=283) (actual time=0.049..2.630 rows=261 loops=1)

2. 0.027 1.852 ↓ 2.0 190 1

Subquery Scan on *SELECT* 1 (cost=1.98..2,553.40 rows=93 width=278) (actual time=0.049..1.852 rows=190 loops=1)

3. 0.173 1.825 ↓ 2.0 190 1

Nested Loop (cost=1.98..2,552.47 rows=93 width=294) (actual time=0.048..1.825 rows=190 loops=1)

4. 0.178 1.462 ↓ 2.0 190 1

Nested Loop (cost=1.70..2,524.32 rows=93 width=153) (actual time=0.042..1.462 rows=190 loops=1)

5. 0.033 0.904 ↓ 2.0 190 1

Nested Loop (cost=1.27..1,742.94 rows=93 width=117) (actual time=0.034..0.904 rows=190 loops=1)

6. 0.041 0.681 ↓ 2.0 190 1

Nested Loop (cost=0.99..1,191.04 rows=93 width=88) (actual time=0.028..0.681 rows=190 loops=1)

7. 0.087 0.450 ↓ 2.0 190 1

Nested Loop (cost=0.71..639.14 rows=93 width=59) (actual time=0.021..0.450 rows=190 loops=1)

8. 0.173 0.173 ↓ 2.0 190 1

Index Scan using ix_billinglog_exportid on billinglog (cost=0.42..18.77 rows=93 width=28) (actual time=0.015..0.173 rows=190 loops=1)

  • Index Cond: (exportid = '2678'::bigint)
  • Filter: (entitytypeid = 1)
  • Rows Removed by Filter: 71
9. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_user on "user" (cost=0.29..6.67 rows=1 width=35) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = billinglog.userid)
10. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation userorg (cost=0.28..5.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = billinglog.userorgid)
11. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation topparentorg (cost=0.28..5.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = billinglog.topparentorgid)
12. 0.380 0.380 ↑ 1.0 1 190

Index Scan using pk_request on roadworkrequest (cost=0.43..8.40 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=190)

  • Index Cond: (id = billinglog.entityid)
13. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation roadworkpsmorg (cost=0.28..0.30 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = roadworkrequest.roadworkrequestpsmorganisationid)
14. 0.010 0.757 ↓ 3.7 71 1

Subquery Scan on *SELECT* 2 (cost=1.98..733.62 rows=19 width=308) (actual time=0.034..0.757 rows=71 loops=1)

15. 0.063 0.747 ↓ 3.7 71 1

Nested Loop (cost=1.98..733.43 rows=19 width=324) (actual time=0.034..0.747 rows=71 loops=1)

16. 0.019 0.613 ↓ 3.7 71 1

Nested Loop (cost=1.69..727.43 rows=19 width=151) (actual time=0.029..0.613 rows=71 loops=1)

17. 0.020 0.523 ↓ 3.7 71 1

Nested Loop (cost=1.41..589.85 rows=19 width=122) (actual time=0.026..0.523 rows=71 loops=1)

18. 0.043 0.432 ↓ 3.7 71 1

Nested Loop (cost=1.13..452.26 rows=19 width=93) (actual time=0.022..0.432 rows=71 loops=1)

19. 0.016 0.318 ↓ 3.7 71 1

Nested Loop (cost=0.84..305.64 rows=19 width=62) (actual time=0.018..0.318 rows=71 loops=1)

20. 0.089 0.089 ↓ 2.1 71 1

Index Scan using ix_billinglog_exportid on billinglog billinglog_1 (cost=0.42..18.77 rows=34 width=28) (actual time=0.011..0.089 rows=71 loops=1)

  • Index Cond: (exportid = '2678'::bigint)
  • Filter: (entitytypeid = 2)
  • Rows Removed by Filter: 190
21. 0.213 0.213 ↑ 1.0 1 71

Index Scan using pk_permit on permit (cost=0.42..8.44 rows=1 width=38) (actual time=0.003..0.003 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.entityid)
22. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_user on "user" user_1 (cost=0.29..7.72 rows=1 width=35) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.userid)
23. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation userorg_1 (cost=0.28..7.24 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.userorgid)
24. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation topparentorg_1 (cost=0.28..7.24 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.topparentorgid)
25. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation permitpsmorg (cost=0.28..0.32 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = permit.permitpublicspacemanagerid)