explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tsxr

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 21.028 ↓ 0.0 0 1

Append (cost=1.98..1,277,278.90 rows=115 width=299) (actual time=21.028..21.028 rows=0 loops=1)

2. 0.000 21.009 ↓ 0.0 0 1

Nested Loop (cost=1.98..1,066,049.70 rows=96 width=294) (actual time=21.009..21.009 rows=0 loops=1)

3. 0.001 21.009 ↓ 0.0 0 1

Nested Loop (cost=1.70..2,363.62 rows=96 width=161) (actual time=21.009..21.009 rows=0 loops=1)

4. 0.000 21.008 ↓ 0.0 0 1

Nested Loop (cost=1.27..1,556.90 rows=96 width=125) (actual time=21.008..21.008 rows=0 loops=1)

5. 0.000 21.008 ↓ 0.0 0 1

Nested Loop (cost=0.99..1,108.09 rows=96 width=96) (actual time=21.008..21.008 rows=0 loops=1)

6. 0.001 21.008 ↓ 0.0 0 1

Nested Loop (cost=0.71..659.29 rows=96 width=67) (actual time=21.008..21.008 rows=0 loops=1)

7. 21.007 21.007 ↓ 0.0 0 1

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

  • Index Cond: (exportid = '4457'::bigint)
  • Filter: (entitytypeid = 1)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on "user" (cost=0.29..6.68 rows=1 width=35) (never executed)

  • Index Cond: (id = billinglog.userid)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation userorg (cost=0.28..4.67 rows=1 width=33) (never executed)

  • Index Cond: (id = billinglog.userorgid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg (cost=0.28..4.67 rows=1 width=33) (never executed)

  • Index Cond: (id = billinglog.topparentorgid)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_request on roadworkrequest (cost=0.43..8.40 rows=1 width=40) (never executed)

  • Index Cond: (id = billinglog.entityid)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation roadworkpsmorg (cost=0.28..0.30 rows=1 width=34) (never executed)

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

SubPlan (for Nested Loop)

14. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..11,079.76 rows=1 width=8) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on billinglog bl (cost=0.00..11,079.76 rows=1 width=8) (never executed)

  • Filter: (entityid = billinglog.entityid)
16. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=1.98..211,227.47 rows=19 width=326) (actual time=0.015..0.015 rows=0 loops=1)

17. 0.001 0.015 ↓ 0.0 0 1

Nested Loop (cost=1.69..706.18 rows=19 width=161) (actual time=0.015..0.015 rows=0 loops=1)

18. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.41..583.22 rows=19 width=132) (actual time=0.014..0.014 rows=0 loops=1)

19. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.13..460.26 rows=19 width=103) (actual time=0.014..0.014 rows=0 loops=1)

20. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.84..313.33 rows=19 width=72) (actual time=0.014..0.014 rows=0 loops=1)

21. 0.014 0.014 ↓ 0.0 0 1

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

  • Index Cond: (exportid = '4457'::bigint)
  • Filter: (entitytypeid = 2)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_permit on permit (cost=0.42..8.44 rows=1 width=40) (never executed)

  • Index Cond: (id = billinglog_1.entityid)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on "user" user_1 (cost=0.29..7.73 rows=1 width=35) (never executed)

  • Index Cond: (id = billinglog_1.userid)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation userorg_1 (cost=0.28..6.47 rows=1 width=33) (never executed)

  • Index Cond: (id = billinglog_1.userorgid)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation topparentorg_1 (cost=0.28..6.47 rows=1 width=33) (never executed)

  • Index Cond: (id = billinglog_1.topparentorgid)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_id_emailenabled on organisation permitpsmorg (cost=0.28..0.31 rows=1 width=34) (never executed)

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

SubPlan (for Nested Loop)

28. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..11,079.76 rows=1 width=8) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on billinglog bl_1 (cost=0.00..11,079.76 rows=1 width=8) (never executed)

  • Filter: (entityid = billinglog_1.entityid)