explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ciSn

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 8.052 ↓ 4.3 497 1

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

2. 0.162 4.668 ↓ 2.9 278 1

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

3. 0.147 2.560 ↓ 2.9 278 1

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

4. 0.137 1.579 ↓ 2.9 278 1

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

5. 0.137 1.164 ↓ 2.9 278 1

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

6. 0.013 0.749 ↓ 2.9 278 1

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

7. 0.180 0.180 ↓ 2.9 278 1

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

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

Index Scan using pk_user on "user" (cost=0.29..6.68 rows=1 width=35) (actual time=0.002..0.002 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.834 0.834 ↑ 1.0 1 278

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

  • Index Cond: (id = billinglog.entityid)
12. 0.556 0.556 ↑ 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.002..0.002 rows=1 loops=278)

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

SubPlan (for Nested Loop)

14. 0.000 1.390 ↑ 1.0 1 278

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

15. 1.390 1.390 ↑ 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.005..0.005 rows=1 loops=278)

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

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

17. 0.124 1.986 ↓ 11.5 219 1

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

18. 0.120 1.643 ↓ 11.5 219 1

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

19. 0.000 1.304 ↓ 11.5 219 1

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

20. 0.272 0.868 ↓ 11.5 219 1

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

21. 0.158 0.158 ↓ 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.015..0.158 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.438 0.438 ↑ 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.002..0.002 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.219 0.876 ↑ 1.0 1 219

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

29. 0.657 0.657 ↑ 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.003..0.003 rows=1 loops=219)

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