explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h8ie

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.501 ↑ 4.7 12 1

Append (cost=1.98..2,172.60 rows=56 width=299) (actual time=0.170..0.501 rows=12 loops=1)

2. 0.015 0.395 ↑ 5.1 9 1

Nested Loop (cost=1.98..1,692.73 rows=46 width=294) (actual time=0.170..0.395 rows=9 loops=1)

3. 0.009 0.209 ↑ 5.1 9 1

Nested Loop (cost=1.70..1,290.64 rows=46 width=161) (actual time=0.133..0.209 rows=9 loops=1)

4. 0.000 0.173 ↑ 5.1 9 1

Nested Loop (cost=1.27..902.17 rows=46 width=125) (actual time=0.125..0.173 rows=9 loops=1)

5. 0.007 0.155 ↑ 5.1 9 1

Nested Loop (cost=0.99..632.37 rows=46 width=96) (actual time=0.116..0.155 rows=9 loops=1)

6. 0.004 0.139 ↑ 5.1 9 1

Nested Loop (cost=0.71..362.57 rows=46 width=67) (actual time=0.110..0.139 rows=9 loops=1)

7. 0.117 0.117 ↑ 5.1 9 1

Index Scan using ix_billinglog_exportid on billinglog (cost=0.42..20.54 rows=46 width=36) (actual time=0.104..0.117 rows=9 loops=1)

  • Index Cond: (exportid = '567'::bigint)
  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 1))
  • Rows Removed by Filter: 3
8. 0.018 0.018 ↑ 1.0 1 9

Index Scan using pk_user on "user" (cost=0.29..7.44 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=9)

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

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

  • Index Cond: (id = billinglog.userorgid)
10. 0.018 0.018 ↑ 1.0 1 9

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg (cost=0.28..5.87 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=9)

  • Index Cond: (id = billinglog.topparentorgid)
11. 0.027 0.027 ↑ 1.0 1 9

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

  • Index Cond: (id = billinglog.entityid)
12. 0.018 0.018 ↑ 1.0 1 9

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

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

SubPlan (for Nested Loop)

14. 0.000 0.153 ↑ 1.0 1 9

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=9)

15. 0.153 0.153 ↑ 1.0 1 9

Index Scan using ix_billinglog_entityid on billinglog bl (cost=0.42..8.44 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=9)

  • Index Cond: (entityid = billinglog.entityid)
16. 0.003 0.105 ↑ 3.3 3 1

Nested Loop (cost=1.98..479.31 rows=10 width=324) (actual time=0.062..0.105 rows=3 loops=1)

17. 0.002 0.054 ↑ 3.3 3 1

Nested Loop (cost=1.69..391.86 rows=10 width=159) (actual time=0.035..0.054 rows=3 loops=1)

18. 0.001 0.046 ↑ 3.3 3 1

Nested Loop (cost=1.41..318.26 rows=10 width=130) (actual time=0.029..0.046 rows=3 loops=1)

19. 0.002 0.039 ↑ 3.3 3 1

Nested Loop (cost=1.13..244.67 rows=10 width=101) (actual time=0.024..0.039 rows=3 loops=1)

20. 0.003 0.031 ↑ 3.3 3 1

Nested Loop (cost=0.84..163.98 rows=10 width=70) (actual time=0.019..0.031 rows=3 loops=1)

21. 0.013 0.013 ↑ 5.7 3 1

Index Scan using ix_billinglog_exportid on billinglog billinglog_1 (cost=0.42..20.54 rows=17 width=36) (actual time=0.010..0.013 rows=3 loops=1)

  • Index Cond: (exportid = '567'::bigint)
  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 2))
  • Rows Removed by Filter: 9
22. 0.015 0.015 ↑ 1.0 1 3

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

  • Index Cond: (id = billinglog_1.entityid)
23. 0.006 0.006 ↑ 1.0 1 3

Index Scan using pk_user on "user" user_1 (cost=0.29..8.07 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = billinglog_1.userid)
24. 0.006 0.006 ↑ 1.0 1 3

Index Scan using ix_organisation_id_emailenabled on organisation userorg_1 (cost=0.28..7.36 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = billinglog_1.userorgid)
25. 0.006 0.006 ↑ 1.0 1 3

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg_1 (cost=0.28..7.36 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = billinglog_1.topparentorgid)
26. 0.009 0.009 ↑ 1.0 1 3

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

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

SubPlan (for Nested Loop)

28. 0.000 0.039 ↑ 1.0 1 3

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=3)

29. 0.039 0.039 ↑ 1.0 1 3

Index Scan using ix_billinglog_entityid on billinglog bl_1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (entityid = billinglog_1.entityid)