explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b37Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 6.346 ↓ 4.3 497 1

Append (cost=1.98..4,076.81 rows=115 width=299) (actual time=0.065..6.346 rows=497 loops=1)

2. 0.407 3.499 ↓ 2.9 278 1

Nested Loop (cost=1.98..3,202.74 rows=96 width=294) (actual time=0.064..3.499 rows=278 loops=1)

3. 0.274 2.258 ↓ 2.9 278 1

Nested Loop (cost=1.70..2,363.62 rows=96 width=161) (actual time=0.043..2.258 rows=278 loops=1)

4. 0.108 1.428 ↓ 2.9 278 1

Nested Loop (cost=1.27..1,556.90 rows=96 width=125) (actual time=0.035..1.428 rows=278 loops=1)

5. 0.100 1.042 ↓ 2.9 278 1

Nested Loop (cost=0.99..1,108.09 rows=96 width=96) (actual time=0.028..1.042 rows=278 loops=1)

6. 0.226 0.664 ↓ 2.9 278 1

Nested Loop (cost=0.71..659.29 rows=96 width=67) (actual time=0.022..0.664 rows=278 loops=1)

7. 0.160 0.160 ↓ 2.9 278 1

Index Scan using ix_billinglog_exportid on billinglog (cost=0.42..18.01 rows=96 width=36) (actual time=0.013..0.160 rows=278 loops=1)

  • Index Cond: (exportid = '4354'::bigint)
  • Filter: (entitytypeid = 1)
  • Rows Removed by Filter: 219
8. 0.278 0.278 ↑ 1.0 1 278

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

  • Index Cond: (id = billinglog.userid)
9. 0.278 0.278 ↑ 1.0 1 278

Index Scan using ix_organisation_id_emailenabled on organisation userorg (cost=0.28..4.67 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=278)

  • Index Cond: (id = billinglog.userorgid)
10. 0.278 0.278 ↑ 1.0 1 278

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg (cost=0.28..4.67 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=278)

  • Index Cond: (id = billinglog.topparentorgid)
11. 0.556 0.556 ↑ 1.0 1 278

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=278)

  • Index Cond: (id = billinglog.entityid)
12. 0.278 0.278 ↑ 1.0 1 278

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

  • Index Cond: (id = roadworkrequest.roadworkrequestpsmorganisationid)
13.          

SubPlan (for Nested Loop)

14. 0.000 0.556 ↑ 1.0 1 278

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=278)

15. 0.556 0.556 ↑ 1.0 1 278

Index Only Scan using ix_entityid_billinglog on billinglog bl (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=278)

  • Index Cond: (entityid = billinglog.entityid)
  • Heap Fetches: 278
16. 0.330 2.815 ↓ 11.5 219 1

Nested Loop (cost=1.98..872.34 rows=19 width=326) (actual time=0.049..2.815 rows=219 loops=1)

17. 0.111 1.828 ↓ 11.5 219 1

Nested Loop (cost=1.69..706.18 rows=19 width=161) (actual time=0.034..1.828 rows=219 loops=1)

18. 0.114 1.498 ↓ 11.5 219 1

Nested Loop (cost=1.41..583.22 rows=19 width=132) (actual time=0.029..1.498 rows=219 loops=1)

19. 0.195 1.165 ↓ 11.5 219 1

Nested Loop (cost=1.13..460.26 rows=19 width=103) (actual time=0.024..1.165 rows=219 loops=1)

20. 0.187 0.751 ↓ 11.5 219 1

Nested Loop (cost=0.84..313.33 rows=19 width=72) (actual time=0.017..0.751 rows=219 loops=1)

21. 0.126 0.126 ↓ 6.3 219 1

Index Scan using ix_billinglog_exportid on billinglog billinglog_1 (cost=0.42..18.01 rows=35 width=36) (actual time=0.009..0.126 rows=219 loops=1)

  • Index Cond: (exportid = '4354'::bigint)
  • Filter: (entitytypeid = 2)
  • Rows Removed by Filter: 278
22. 0.438 0.438 ↑ 1.0 1 219

Index Scan using pk_permit on permit (cost=0.42..8.44 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=219)

  • Index Cond: (id = billinglog_1.entityid)
23. 0.219 0.219 ↑ 1.0 1 219

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

  • Index Cond: (id = billinglog_1.userid)
24. 0.219 0.219 ↑ 1.0 1 219

Index Scan using ix_organisation_id_emailenabled on organisation userorg_1 (cost=0.28..6.47 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=219)

  • Index Cond: (id = billinglog_1.userorgid)
25. 0.219 0.219 ↑ 1.0 1 219

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg_1 (cost=0.28..6.47 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=219)

  • Index Cond: (id = billinglog_1.topparentorgid)
26. 0.219 0.219 ↑ 1.0 1 219

Index Scan using ix_organisation_id_emailenabled on organisation permitpsmorg (cost=0.28..0.31 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=219)

  • Index Cond: (id = permit.permitpublicspacemanagerid)
27.          

SubPlan (for Nested Loop)

28. 0.000 0.438 ↑ 1.0 1 219

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=219)

29. 0.438 0.438 ↑ 1.0 1 219

Index Only Scan using ix_entityid_billinglog on billinglog bl_1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=219)

  • Index Cond: (entityid = billinglog_1.entityid)
  • Heap Fetches: 219