explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vt8

Settings
# exclusive inclusive rows x rows loops node
1. 0.840 36,977.602 ↓ 34.9 1,747 1

Append (cost=1,001.56..368,129.11 rows=50 width=299) (actual time=26.636..36,977.602 rows=1,747 loops=1)

2. 29,277.137 29,348.355 ↓ 34.0 1,395 1

Gather (cost=1,001.56..297,426.69 rows=41 width=294) (actual time=26.635..29,348.355 rows=1,395 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 5.240 50.226 ↓ 29.1 698 2

Nested Loop (cost=1.56..6,588.47 rows=24 width=191) (actual time=10.296..50.226 rows=698 loops=2)

4. 9.957 44.981 ↓ 29.1 698 2

Nested Loop (cost=1.28..6,581.19 rows=24 width=161) (actual time=10.281..44.981 rows=698 loops=2)

5. 3.074 35.011 ↓ 29.1 698 2

Nested Loop (cost=0.85..6,378.51 rows=24 width=126) (actual time=10.248..35.011 rows=698 loops=2)

6. 4.081 31.934 ↓ 29.1 698 2

Nested Loop (cost=0.57..6,221.45 rows=24 width=97) (actual time=10.233..31.934 rows=698 loops=2)

7. 8.438 27.849 ↓ 29.1 698 2

Nested Loop (cost=0.29..6,064.39 rows=24 width=68) (actual time=10.204..27.849 rows=698 loops=2)

8. 19.402 19.402 ↓ 29.1 698 2

Parallel Seq Scan on billinglog (cost=0.00..5,886.15 rows=24 width=36) (actual time=10.150..19.402 rows=698 loops=2)

  • Filter: (CASE WHEN (exportid IS NOT NULL) THEN true ELSE false END AND (entitytypeid = 1) AND (exportid = '2680'::bigint))
  • Rows Removed by Filter: 156518
9. 0.009 0.009 ↑ 1.0 1 1,395

Index Scan using pk_user on "user" (cost=0.29..7.43 rows=1 width=36) (actual time=0.009..0.009 rows=1 loops=1,395)

  • Index Cond: (id = billinglog.userid)
10. 0.004 0.004 ↑ 1.0 1 1,395

Index Scan using pk_organisation on organisation userorg (cost=0.28..6.54 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=1,395)

  • Index Cond: (id = billinglog.userorgid)
11. 0.003 0.003 ↑ 1.0 1 1,395

Index Scan using pk_organisation on organisation topparentorg (cost=0.28..6.54 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=1,395)

  • Index Cond: (id = billinglog.topparentorgid)
12. 0.013 0.013 ↑ 1.0 1 1,395

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

  • Index Cond: (id = billinglog.entityid)
13. 0.005 0.005 ↑ 1.0 1 1,395

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

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

SubPlan (forGather)

15. 0.005 20.992 ↑ 1.0 1 1,395

Limit (cost=0.00..7,069.12 rows=1 width=8) (actual time=20.992..20.992 rows=1 loops=1,395)

16. 20.987 20.987 ↑ 1.0 1 1,395

Seq Scan on billinglog bl (cost=0.00..7,069.12 rows=1 width=8) (actual time=20.987..20.987 rows=1 loops=1,395)

  • Filter: (entityid = billinglog.entityid)
  • Rows Removed by Filter: 304045
17. 7,587.794 7,628.407 ↓ 39.1 352 1

Gather (cost=1,001.55..70,701.92 rows=9 width=324) (actual time=33.753..7,628.407 rows=352 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
18. 0.757 18.993 ↓ 35.2 176 2

Nested Loop (cost=1.55..6,078.90 rows=5 width=189) (actual time=12.114..18.993 rows=176 loops=2)

19. 0.408 18.233 ↓ 35.2 176 2

Nested Loop (cost=1.27..6,077.28 rows=5 width=159) (actual time=12.097..18.233 rows=176 loops=2)

20. 0.502 17.823 ↓ 35.2 176 2

Nested Loop (cost=0.99..6,039.78 rows=5 width=130) (actual time=12.080..17.823 rows=176 loops=2)

21. 0.671 17.319 ↓ 35.2 176 2

Nested Loop (cost=0.71..6,002.28 rows=5 width=101) (actual time=12.052..17.319 rows=176 loops=2)

22. 1.807 16.645 ↓ 35.2 176 2

Nested Loop (cost=0.42..5,962.08 rows=5 width=69) (actual time=12.024..16.645 rows=176 loops=2)

23. 14.829 14.829 ↓ 19.6 176 2

Parallel Seq Scan on billinglog billinglog_1 (cost=0.00..5,886.15 rows=9 width=36) (actual time=11.991..14.829 rows=176 loops=2)

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

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

  • Index Cond: (id = billinglog_1.entityid)
25. 0.003 0.003 ↑ 1.0 1 352

Index Scan using pk_user on "user" user_1 (cost=0.29..8.04 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=352)

  • Index Cond: (id = billinglog_1.userid)
26. 0.002 0.002 ↑ 1.0 1 352

Index Scan using pk_organisation on organisation userorg_1 (cost=0.28..7.50 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=352)

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

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

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

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

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

SubPlan (forGather)

30. 0.004 21.620 ↑ 1.0 1 352

Limit (cost=0.00..7,069.12 rows=1 width=8) (actual time=21.620..21.620 rows=1 loops=352)

31. 21.616 21.616 ↑ 1.0 1 352

Seq Scan on billinglog bl_1 (cost=0.00..7,069.12 rows=1 width=8) (actual time=21.616..21.616 rows=1 loops=352)

  • Filter: (entityid = billinglog_1.entityid)
  • Rows Removed by Filter: 305067
Planning time : 3.725 ms