explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SCob

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 143.503 ↑ 4.7 12 1

Append (cost=1,001.56..518,245.28 rows=56 width=299) (actual time=13.924..143.503 rows=12 loops=1)

2. 19.950 74.519 ↑ 5.1 9 1

Gather (cost=1,001.56..420,909.50 rows=46 width=294) (actual time=13.923..74.519 rows=9 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.007 14.105 ↑ 6.3 3 3 / 3

Nested Loop (cost=1.56..6,937.60 rows=19 width=191) (actual time=5.946..14.105 rows=3 loops=3)

4. 0.005 14.092 ↑ 6.3 3 3 / 3

Nested Loop (cost=1.28..6,931.89 rows=19 width=161) (actual time=5.944..14.092 rows=3 loops=3)

5. 0.005 14.072 ↑ 6.3 3 3 / 3

Nested Loop (cost=0.85..6,771.43 rows=19 width=125) (actual time=5.940..14.072 rows=3 loops=3)

6. 0.004 14.061 ↑ 6.3 3 3 / 3

Nested Loop (cost=0.57..6,659.99 rows=19 width=96) (actual time=5.938..14.061 rows=3 loops=3)

7. 0.011 14.045 ↑ 6.3 3 3 / 3

Nested Loop (cost=0.29..6,548.55 rows=19 width=67) (actual time=5.934..14.045 rows=3 loops=3)

8. 14.016 14.016 ↑ 6.3 3 3 / 3

Parallel Seq Scan on billinglog (cost=0.00..6,407.27 rows=19 width=36) (actual time=5.926..14.016 rows=3 loops=3)

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

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

  • Index Cond: (id = billinglog.userid)
10. 0.012 0.012 ↑ 1.0 1 9 / 3

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

  • Index Cond: (id = billinglog.userorgid)
11. 0.006 0.006 ↑ 1.0 1 9 / 3

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)
12. 0.015 0.015 ↑ 1.0 1 9 / 3

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

  • Index Cond: (id = billinglog.entityid)
13. 0.006 0.006 ↑ 1.0 1 9 / 3

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)
14.          

SubPlan (for Gather)

15. 0.090 40.464 ↑ 1.0 1 9

Limit (cost=0.00..8,977.55 rows=1 width=8) (actual time=4.496..4.496 rows=1 loops=9)

16. 40.374 40.374 ↑ 1.0 1 9

Seq Scan on billinglog bl (cost=0.00..8,977.55 rows=1 width=8) (actual time=4.486..4.486 rows=1 loops=9)

  • Filter: (entityid = billinglog.entityid)
  • Rows Removed by Filter: 65028
17. 45.216 68.976 ↑ 3.3 3 1

Gather (cost=1,001.55..97,335.22 rows=10 width=324) (actual time=11.211..68.976 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 0.003 11.349 ↑ 4.0 1 3 / 3

Nested Loop (cost=1.55..6,558.72 rows=4 width=189) (actual time=1.680..11.349 rows=1 loops=3)

19. 0.001 11.342 ↑ 4.0 1 3 / 3

Nested Loop (cost=1.27..6,557.49 rows=4 width=159) (actual time=1.676..11.342 rows=1 loops=3)

20. 0.002 11.339 ↑ 4.0 1 3 / 3

Nested Loop (cost=0.99..6,528.05 rows=4 width=130) (actual time=1.675..11.339 rows=1 loops=3)

21. 0.002 11.334 ↑ 4.0 1 3 / 3

Nested Loop (cost=0.71..6,498.62 rows=4 width=101) (actual time=1.673..11.334 rows=1 loops=3)

22. 0.005 11.328 ↑ 4.0 1 3 / 3

Nested Loop (cost=0.42..6,466.34 rows=4 width=70) (actual time=1.670..11.328 rows=1 loops=3)

23. 11.314 11.314 ↑ 7.0 1 3 / 3

Parallel Seq Scan on billinglog billinglog_1 (cost=0.00..6,407.27 rows=7 width=36) (actual time=1.664..11.314 rows=1 loops=3)

  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 2) AND (exportid = '567'::bigint))
  • Rows Removed by Filter: 137080
24. 0.009 0.009 ↑ 1.0 1 3 / 3

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

  • Index Cond: (id = billinglog_1.entityid)
25. 0.004 0.004 ↑ 1.0 1 3 / 3

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

  • Index Cond: (id = billinglog_1.userid)
26. 0.003 0.003 ↑ 1.0 1 3 / 3

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

  • Index Cond: (id = billinglog_1.userorgid)
27. 0.002 0.002 ↑ 1.0 1 3 / 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)
28. 0.004 0.004 ↑ 1.0 1 3 / 3

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

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

SubPlan (for Gather)

30. 0.024 12.411 ↑ 1.0 1 3

Limit (cost=0.00..8,977.55 rows=1 width=8) (actual time=4.137..4.137 rows=1 loops=3)

31. 12.387 12.387 ↑ 1.0 1 3

Seq Scan on billinglog bl_1 (cost=0.00..8,977.55 rows=1 width=8) (actual time=4.129..4.129 rows=1 loops=3)

  • Filter: (entityid = billinglog_1.entityid)
  • Rows Removed by Filter: 60851