explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uE3u

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 24.970 ↓ 0.0 0 1

Append (cost=1.98..291,452.94 rows=48 width=298) (actual time=24.970..24.970 rows=0 loops=1)

2. 0.001 24.947 ↓ 0.0 0 1

Nested Loop (cost=1.98..236,739.76 rows=39 width=293) (actual time=24.947..24.947 rows=0 loops=1)

3. 0.000 24.946 ↓ 0.0 0 1

Nested Loop (cost=1.70..1,126.58 rows=39 width=160) (actual time=24.946..24.946 rows=0 loops=1)

4. 0.000 24.946 ↓ 0.0 0 1

Nested Loop (cost=1.27..797.23 rows=39 width=126) (actual time=24.946..24.946 rows=0 loops=1)

5. 0.001 24.946 ↓ 0.0 0 1

Nested Loop (cost=0.99..557.52 rows=39 width=97) (actual time=24.946..24.946 rows=0 loops=1)

6. 0.001 24.945 ↓ 0.0 0 1

Nested Loop (cost=0.71..317.82 rows=39 width=68) (actual time=24.945..24.945 rows=0 loops=1)

7. 24.944 24.944 ↓ 0.0 0 1

Index Scan using ix_billinglog_exportid on billinglog (cost=0.42..25.93 rows=39 width=36) (actual time=24.944..24.944 rows=0 loops=1)

  • Index Cond: (exportid = '3443'::bigint)
  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 1))
8. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ix_organisation_id on organisation userorg (cost=0.28..6.15 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 on organisation topparentorg (cost=0.28..6.15 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.45 rows=1 width=38) (never executed)

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

Index Scan using ix_organisation_id 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..6,041.06 rows=1 width=8) (never executed)

15. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (entityid = billinglog.entityid)
16. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=1.98..54,712.71 rows=9 width=324) (actual time=0.023..0.023 rows=0 loops=1)

17. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.69..340.38 rows=9 width=159) (actual time=0.022..0.022 rows=0 loops=1)

18. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.41..273.98 rows=9 width=130) (actual time=0.022..0.022 rows=0 loops=1)

19. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.13..207.59 rows=9 width=101) (actual time=0.022..0.022 rows=0 loops=1)

20. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.84..135.61 rows=9 width=69) (actual time=0.022..0.022 rows=0 loops=1)

21. 0.022 0.022 ↓ 0.0 0 1

Index Scan using ix_billinglog_exportid on billinglog billinglog_1 (cost=0.42..25.93 rows=13 width=36) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (exportid = '3443'::bigint)
  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (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=37) (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..8.00 rows=1 width=36) (never executed)

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

Index Scan using ix_organisation_id on organisation userorg_1 (cost=0.28..7.38 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 on organisation topparentorg_1 (cost=0.28..7.38 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 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..6,041.06 rows=1 width=8) (never executed)

29. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (entityid = billinglog_1.entityid)