explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xPt1

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 158.968 ↑ 6.9 7 1

Append (cost=1,001.56..302,853.49 rows=48 width=299) (actual time=37.146..158.968 rows=7 loops=1)

2. 71.674 102.609 ↑ 7.8 5 1

Gather (cost=1,001.56..242,279.43 rows=39 width=294) (actual time=37.146..102.609 rows=5 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.015 15.440 ↑ 7.7 3 2

Nested Loop (cost=1.56..5,677.02 rows=23 width=191) (actual time=11.126..15.440 rows=3 loops=2)

4. 0.021 15.418 ↑ 7.7 3 2

Nested Loop (cost=1.28..5,670.10 rows=23 width=161) (actual time=11.117..15.418 rows=3 loops=2)

5. 0.012 15.386 ↑ 7.7 3 2

Nested Loop (cost=0.85..5,475.86 rows=23 width=126) (actual time=11.098..15.386 rows=3 loops=2)

6. 0.013 15.369 ↑ 7.7 3 2

Nested Loop (cost=0.57..5,334.50 rows=23 width=97) (actual time=11.088..15.369 rows=3 loops=2)

7. 0.028 15.349 ↑ 7.7 3 2

Nested Loop (cost=0.29..5,193.13 rows=23 width=68) (actual time=11.073..15.349 rows=3 loops=2)

8. 15.309 15.309 ↑ 7.7 3 2

Parallel Seq Scan on billinglog (cost=0.00..5,020.99 rows=23 width=36) (actual time=11.046..15.309 rows=3 loops=2)

  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 1) AND (exportid = '2146'::bigint))
  • Rows Removed by Filter: 138717
9. 0.012 0.012 ↑ 1.0 1 5

Index Scan using pk_user on "user" (cost=0.29..7.48 rows=1 width=36) (actual time=0.012..0.012 rows=1 loops=5)

  • Index Cond: (id = billinglog.userid)
10. 0.007 0.007 ↑ 1.0 1 5

Index Scan using pk_organisation on organisation userorg (cost=0.28..6.15 rows=1 width=33) (actual time=0.007..0.007 rows=1 loops=5)

  • Index Cond: (id = billinglog.userorgid)
11. 0.005 0.005 ↑ 1.0 1 5

Index Scan using pk_organisation on organisation topparentorg (cost=0.28..6.15 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=5)

  • Index Cond: (id = billinglog.topparentorgid)
12. 0.011 0.011 ↑ 1.0 1 5

Index Scan using pk_request on roadworkrequest (cost=0.43..8.45 rows=1 width=39) (actual time=0.011..0.011 rows=1 loops=5)

  • Index Cond: (id = billinglog.entityid)
13. 0.007 0.007 ↑ 1.0 1 5

Index Scan using pk_organisation on organisation roadworkpsmorg (cost=0.28..0.30 rows=1 width=34) (actual time=0.007..0.007 rows=1 loops=5)

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

SubPlan (forGather)

15. 0.011 15.495 ↑ 1.0 1 5

Limit (cost=0.00..6,040.99 rows=1 width=8) (actual time=15.495..15.495 rows=1 loops=5)

16. 15.484 15.484 ↑ 1.0 1 5

Seq Scan on billinglog bl (cost=0.00..6,040.99 rows=1 width=8) (actual time=15.484..15.484 rows=1 loops=5)

  • Filter: (entityid = billinglog.entityid)
  • Rows Removed by Filter: 216833
17. 29.226 56.355 ↑ 4.5 2 1

Gather (cost=1,001.55..60,573.57 rows=9 width=324) (actual time=34.291..56.355 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
18. 0.002 12.376 ↑ 5.0 1 2

Nested Loop (cost=1.55..5,203.79 rows=5 width=189) (actual time=9.209..12.376 rows=1 loops=2)

19. 0.001 12.371 ↑ 5.0 1 2

Nested Loop (cost=1.27..5,202.25 rows=5 width=159) (actual time=9.206..12.371 rows=1 loops=2)

20. 0.002 12.368 ↑ 5.0 1 2

Nested Loop (cost=0.99..5,165.37 rows=5 width=130) (actual time=9.205..12.368 rows=1 loops=2)

21. 0.001 12.363 ↑ 5.0 1 2

Nested Loop (cost=0.71..5,128.48 rows=5 width=101) (actual time=9.202..12.363 rows=1 loops=2)

22. 0.005 12.357 ↑ 5.0 1 2

Nested Loop (cost=0.42..5,088.49 rows=5 width=69) (actual time=9.198..12.357 rows=1 loops=2)

23. 12.335 12.335 ↑ 8.0 1 2

Parallel Seq Scan on billinglog billinglog_1 (cost=0.00..5,020.99 rows=8 width=36) (actual time=9.184..12.335 rows=1 loops=2)

  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 2) AND (exportid = '2146'::bigint))
  • Rows Removed by Filter: 138719
24. 0.017 0.017 ↑ 1.0 1 2

Index Scan using pk_permit on permit (cost=0.42..8.44 rows=1 width=37) (actual time=0.017..0.017 rows=1 loops=2)

  • Index Cond: (id = billinglog_1.entityid)
25. 0.005 0.005 ↑ 1.0 1 2

Index Scan using pk_user on "user" user_1 (cost=0.29..8.00 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=2)

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

Index Scan using pk_organisation on organisation userorg_1 (cost=0.28..7.38 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=2)

  • Index Cond: (id = billinglog_1.userorgid)
27. 0.002 0.002 ↑ 1.0 1 2

Index Scan using pk_organisation on organisation topparentorg_1 (cost=0.28..7.38 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=2)

  • Index Cond: (id = billinglog_1.topparentorgid)
28. 0.003 0.003 ↑ 1.0 1 2

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

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

SubPlan (forGather)

30. 0.006 14.753 ↑ 1.0 1 2

Limit (cost=0.00..6,040.99 rows=1 width=8) (actual time=14.753..14.753 rows=1 loops=2)

31. 14.747 14.747 ↑ 1.0 1 2

Seq Scan on billinglog bl_1 (cost=0.00..6,040.99 rows=1 width=8) (actual time=14.747..14.747 rows=1 loops=2)

  • Filter: (entityid = billinglog_1.entityid)
  • Rows Removed by Filter: 207404
Planning time : 9.124 ms