explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qumoD

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 196,660.480 ↑ 5.5 2 1

Limit (cost=5,393,382.34..5,393,382.37 rows=11 width=1,231) (actual time=196,660.473..196,660.480 rows=2 loops=1)

  • Output: project5.id, ((project5.name)::character varying(255)), ((project5.code)::character varying(50)), ((project5.slug)::character varying(255)), project5.istimeentryallowed, ((COALESCE(task6.rowcount0, '0'::bigint) > 0)), project5.startdate, project5.enddate, project5.programid, ((program7.name)::character varying(255)), ((program7.slug)::character varying(255))
  • Buffers: shared hit=484407 read=1545520 dirtied=84339 written=313
2.          

CTE task0cte

3. 53.271 194,513.435 ↑ 32.9 17 1

HashAggregate (cost=5,235,147.90..5,235,153.49 rows=559 width=4) (actual time=194,513.423..194,513.435 rows=17 loops=1)

  • Output: count(*), task0.projectid
  • Group Key: task0.projectid
  • Buffers: shared hit=24 read=1537725 dirtied=83989 written=313
4. 176.987 194,460.164 ↑ 1.3 149,388 1

Hash Join (cost=5,219,999.36..5,234,164.92 rows=196,597 width=4) (actual time=194,150.180..194,460.164 rows=149,388 loops=1)

  • Output: task0.projectid
  • Hash Cond: (task0.id = taskteammemberassignment2.taskid)
  • Buffers: shared hit=24 read=1537725 dirtied=83989 written=313
5. 163.162 163.162 ↑ 1.3 305,858 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".task task0 (cost=0.00..10,711.67 rows=396,778 width=8) (actual time=0.014..163.162 rows=305,858 loops=1)

  • Output: task0.id, task0.projectid, task0.parentid, task0.name, task0.code, task0.description, task0.isclosed, task0.orderindex, task0.percentcomplete, task0.istimeentryallowed, task0.estimatedhours, task0.timeentrystartdate, task0.timeentryenddate, task0.estimatedexpenses, task0.estimatedexpensescurrencyid, task0.expenseentrystartdate, task0.expenseentryenddate, task0.costtype, task0.estimatedcost, task0.estimatedcostcurrencyid, task0.timeandexpenseentrytype, task0.info1, task0.info2, task0.info3, task0.info4, task0.info5, task0.info6, task0.info7, task0.info8, task0.info9, task0.info10, task0.info11, task0.info12, task0.info13, task0.info14, task0.info15, task0.info16, task0.info17, task0.info18, task0.info19, task0.info20
  • Filter: (task0.istimeentryallowed AND (NOT task0.isclosed) AND (task0.timeentrystartdate <= '2019-05-19'::date) AND (task0.timeentryenddate >= '2019-05-13'::date))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2 read=4758
6. 51.031 194,120.015 ↑ 1.3 149,388 1

Hash (cost=5,217,541.90..5,217,541.90 rows=196,597 width=4) (actual time=194,120.015..194,120.015 rows=149,388 loops=1)

  • Output: taskteammemberassignment2.taskid
  • Buckets: 262144 Batches: 1 Memory Usage: 7300kB
  • Buffers: shared hit=22 read=1532967 dirtied=83989 written=313
7. 271.575 194,068.984 ↑ 1.3 149,388 1

HashAggregate (cost=5,215,575.93..5,217,541.90 rows=196,597 width=4) (actual time=194,001.686..194,068.984 rows=149,388 loops=1)

  • Output: taskteammemberassignment2.taskid
  • Group Key: taskteammemberassignment2.taskid
  • Buffers: shared hit=22 read=1532967 dirtied=83989 written=313
8. 32,603.310 193,797.409 ↑ 613.7 149,803 1

Hash Join (cost=12,904.09..4,985,742.30 rows=91,933,451 width=4) (actual time=25.695..193,797.409 rows=149,803 loops=1)

  • Output: taskteammemberassignment2.taskid
  • Hash Cond: (taskteammemberassignment2.projectteammemberid = projectteammember1.id)
  • Buffers: shared hit=22 read=1532967 dirtied=83989 written=313
9. 161,169.782 161,169.782 ↑ 2.0 91,827,028 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".taskteammemberassignment taskteammemberassignment2 (cost=0.00..3,365,184.60 rows=183,551,760 width=20) (actual time=0.014..161,169.782 rows=91,827,028 loops=1)

  • Output: taskteammemberassignment2.id, taskteammemberassignment2.taskid, taskteammemberassignment2.projectteammemberid, taskteammemberassignment2.taskallocationstartdate, taskteammemberassignment2.taskallocationenddate, taskteammemberassignment2.taskallocationduration
  • Buffers: shared hit=8 read=1529659 dirtied=83989 written=313
10. 0.023 24.317 ↑ 11,289.6 20 1

Hash (cost=10,081.69..10,081.69 rows=225,792 width=16) (actual time=24.317..24.317 rows=20 loops=1)

  • Output: projectteammember1.id
  • Buckets: 262144 Batches: 1 Memory Usage: 2049kB
  • Buffers: shared hit=11 read=3308
11. 24.245 24.294 ↑ 11,289.6 20 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".projectteammember projectteammember1 (cost=4.54..10,081.69 rows=225,792 width=16) (actual time=10.590..24.294 rows=20 loops=1)

  • Output: projectteammember1.id
  • Filter: ((projectteammember1.userid = 2) OR (hashed SubPlan 1))
  • Rows Removed by Filter: 28176
  • Buffers: shared hit=11 read=3308
12.          

SubPlan (forSeq Scan)

13. 0.025 0.049 ↑ 3.0 1 1

Nested Loop (cost=0.28..4.53 rows=3 width=4) (actual time=0.016..0.049 rows=1 loops=1)

  • Output: departmentflathierarchy3.parentid
  • Join Filter: (departmentusers4.departmentid = departmentflathierarchy3.childid)
  • Rows Removed by Join Filter: 69
  • Buffers: shared hit=4
14. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ixduuserid on "1cd6229804074db79982d523a6c316d4".departmentusers departmentusers4 (cost=0.28..2.29 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: departmentusers4.departmentid, departmentusers4.userid, departmentusers4.isprimarydepartment
  • Index Cond: (departmentusers4.userid = 2)
  • Buffers: shared hit=3
15. 0.018 0.018 ↓ 1.3 70 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".departmentflathierarchy departmentflathierarchy3 (cost=0.00..1.55 rows=55 width=8) (actual time=0.002..0.018 rows=70 loops=1)

  • Output: departmentflathierarchy3.parentid, departmentflathierarchy3.childid, departmentflathierarchy3.depth
  • Buffers: shared hit=1
16. 0.097 196,660.474 ↑ 5.5 2 1

Sort (cost=158,228.85..158,228.88 rows=11 width=1,231) (actual time=196,660.470..196,660.474 rows=2 loops=1)

  • Output: project5.id, ((project5.name)::character varying(255)), ((project5.code)::character varying(50)), ((project5.slug)::character varying(255)), project5.istimeentryallowed, ((COALESCE(task6.rowcount0, '0'::bigint) > 0)), project5.startdate, project5.enddate, project5.programid, ((program7.name)::character varying(255)), ((program7.slug)::character varying(255))
  • Sort Key: ((project5.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=484407 read=1545520 dirtied=84339 written=313
17. 0.012 196,660.377 ↑ 5.5 2 1

Nested Loop (cost=9.05..158,228.66 rows=11 width=1,231) (actual time=194,748.974..196,660.377 rows=2 loops=1)

  • Output: project5.id, project5.name, project5.code, project5.slug, project5.istimeentryallowed, (COALESCE(task6.rowcount0, '0'::bigint) > 0), project5.startdate, project5.enddate, project5.programid, program7.name, program7.slug
  • Join Filter: (project5.projectstatuslabelid = projectstatuslabel9.id)
  • Buffers: shared hit=484400 read=1545520 dirtied=84339 written=313
18. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".projectstatuslabel projectstatuslabel9 (cost=0.00..1.09 rows=1 width=16) (actual time=0.005..0.008 rows=1 loops=1)

  • Output: projectstatuslabel9.id, projectstatuslabel9.name, projectstatuslabel9.description, projectstatuslabel9.projectstatustype, projectstatuslabel9.enabled
  • Filter: (projectstatuslabel9.projectstatustype = 1)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1
19. 0.051 196,660.357 ↑ 5.5 2 1

Nested Loop Left Join (cost=9.05..158,227.41 rows=11 width=1,247) (actual time=194,748.961..196,660.357 rows=2 loops=1)

  • Output: project5.id, project5.name, project5.code, project5.slug, project5.istimeentryallowed, project5.startdate, project5.enddate, project5.programid, project5.projectstatuslabelid, program7.name, program7.slug, task6.rowcount0
  • Join Filter: (task6.projectid1 = project5.id)
  • Rows Removed by Join Filter: 32
  • Buffers: shared hit=484399 read=1545520 dirtied=84339 written=313
20. 0.007 2,146.848 ↑ 5.5 2 1

Nested Loop Left Join (cost=9.05..158,083.46 rows=11 width=1,239) (actual time=235.498..2,146.848 rows=2 loops=1)

  • Output: project5.id, project5.name, project5.code, project5.slug, project5.istimeentryallowed, project5.startdate, project5.enddate, project5.programid, project5.projectstatuslabelid, program7.name, program7.slug
  • Join Filter: (project5.programid = program7.id)
  • Buffers: shared hit=484375 read=7795 dirtied=350
21. 0.065 2,146.829 ↑ 5.5 2 1

Nested Loop (cost=9.05..158,061.04 rows=11 width=207) (actual time=235.484..2,146.829 rows=2 loops=1)

  • Output: project5.id, project5.name, project5.code, project5.slug, project5.istimeentryallowed, project5.startdate, project5.enddate, project5.programid, project5.projectstatuslabelid
  • Buffers: shared hit=484375 read=7795 dirtied=350
22. 0.044 0.087 ↑ 1.2 19 1

HashAggregate (cost=8.77..8.99 rows=22 width=4) (actual time=0.053..0.087 rows=19 loops=1)

  • Output: projectclient8.projectid
  • Group Key: projectclient8.projectid
  • Buffers: shared hit=2 read=5
23. 0.043 0.043 ↑ 1.2 19 1

Index Scan using ixpcclientid on "1cd6229804074db79982d523a6c316d4".projectclient projectclient8 (cost=0.28..8.72 rows=22 width=4) (actual time=0.019..0.043 rows=19 loops=1)

  • Output: projectclient8.id, projectclient8.projectid, projectclient8.clientid, projectclient8.costallocationpercentage, projectclient8.effectivedate, projectclient8.enddate
  • Index Cond: (projectclient8.clientid = 47)
  • Filter: ((projectclient8.effectivedate <= '2019-05-19'::date) AND (projectclient8.enddate >= '2019-05-13'::date))
  • Buffers: shared hit=2 read=5
24. 0.323 2,146.677 ↓ 0.0 0 19

Index Scan using project_pkey on "1cd6229804074db79982d523a6c316d4".project project5 (cost=0.28..7,184.17 rows=1 width=207) (actual time=112.982..112.983 rows=0 loops=19)

  • Output: project5.id, project5.guidid, project5.name, project5.slug, project5.code, project5.clientid, project5.projectleaderapproverid, project5.projectstatuslabelid, project5.isprojectleaderapprovalrequired, project5.startdate, project5.enddate, project5.programid, project5.billingtype, project5.fixedbidamount, project5.fixedbidcurrencyid, project5.fixedbidfrequency, project5.timeentrycappercent, project5.costtype, project5.clientbillingallocationmethod, project5.description, project5.percentcomplete, project5.istimeentryallowed, project5.estimatedhours, project5.estimatedexpenses, project5.estimatedexpensescurrencyid, project5.estimatedcost, project5.estimatedcostcurrencyid, project5.timeandexpenseentrytype, project5.estimationmode, project5.billingratefrequencyid, project5.billingratefrequencyduration, project5.defaultbillingcurrencyid, project5.billingcontractid, project5.projecthealthstateid, project5.projecthealthstatedescription, project5.totalestimatedcontractamount, project5.totalestimatedcontractcurrencyid, project5.budgetedhours, project5.budgetedcost, project5.budgetedcostcurrencyid, project5.info1, project5.info2, project5.info3, project5.info4, project5.info5, project5.info6, project5.info7, project5.info8, project5.info9, project5.info10, project5.info11, project5.info12, project5.info13, project5.info14, project5.info15, project5.info16, project5.info17, project5.info18, project5.info19, project5.info20
  • Index Cond: (project5.id = projectclient8.projectid)
  • Filter: ((alternatives: SubPlan 4 or hashed SubPlan 6) OR (project5.istimeentryallowed AND (alternatives: SubPlan 8 or hashed SubPlan 10)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=484373 read=7790 dirtied=350
25.          

SubPlan (forIndex Scan)

26. 7.302 2,146.354 ↓ 0.0 0 19

Nested Loop Semi Join (cost=5.53..2,524,348.55 rows=352 width=0) (actual time=112.966..112.966 rows=0 loops=19)

  • Buffers: shared hit=484328 read=7778 dirtied=350
27. 1,406.608 1,406.608 ↑ 1.2 575 19

Seq Scan on "1cd6229804074db79982d523a6c316d4".task task10 (cost=0.00..11,703.62 rows=710 width=4) (actual time=40.565..74.032 rows=575 loops=19)

  • Output: task10.id, task10.projectid, task10.parentid, task10.name, task10.code, task10.description, task10.isclosed, task10.orderindex, task10.percentcomplete, task10.istimeentryallowed, task10.estimatedhours, task10.timeentrystartdate, task10.timeentryenddate, task10.estimatedexpenses, task10.estimatedexpensescurrencyid, task10.expenseentrystartdate, task10.expenseentryenddate, task10.costtype, task10.estimatedcost, task10.estimatedcostcurrencyid, task10.timeandexpenseentrytype, task10.info1, task10.info2, task10.info3, task10.info4, task10.info5, task10.info6, task10.info7, task10.info8, task10.info9, task10.info10, task10.info11, task10.info12, task10.info13, task10.info14, task10.info15, task10.info16, task10.info17, task10.info18, task10.info19, task10.info20
  • Filter: (task10.istimeentryallowed AND (NOT task10.isclosed) AND (task10.timeentrystartdate <= '2019-05-19'::date) AND (task10.timeentryenddate >= '2019-05-13'::date) AND (task10.projectid = project5.id))
  • Rows Removed by Filter: 302774
  • Buffers: shared hit=84975 read=4758
28. 70.020 732.444 ↓ 0.0 0 10,932

Nested Loop (cost=5.53..4,712.88 rows=225,792 width=4) (actual time=0.067..0.067 rows=0 loops=10,932)

  • Output: taskteammemberassignment12.taskid
  • Buffers: shared hit=399353 read=3020 dirtied=350
29. 404.484 404.484 ↑ 155.7 6 10,932

Index Only Scan using uix2projectteammembertaskassignment on "1cd6229804074db79982d523a6c316d4".taskteammemberassignment taskteammemberassignment12 (cost=0.57..49.86 rows=934 width=20) (actual time=0.030..0.037 rows=6 loops=10,932)

  • Output: taskteammemberassignment12.taskid, taskteammemberassignment12.projectteammemberid
  • Index Cond: (taskteammemberassignment12.taskid = task10.id)
  • Heap Fetches: 107114
  • Buffers: shared hit=141876 read=2548 dirtied=350
30. 257.835 257.940 ↓ 0.0 0 64,485

Index Scan using projectteammember_pkey on "1cd6229804074db79982d523a6c316d4".projectteammember projectteammember11 (cost=4.96..4.98 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=64,485)

  • Output: projectteammember11.id, projectteammember11.projectid, projectteammember11.userid, projectteammember11.departmentid, projectteammember11.placeholderprojectroleid, projectteammember11.index, projectteammember11.placeholderdisplayname, projectteammember11.locationid, projectteammember11.divisionid, projectteammember11.costcenterid, projectteammember11.servicecenterid
  • Index Cond: (projectteammember11.id = taskteammemberassignment12.projectteammemberid)
  • Filter: ((projectteammember11.userid = 2) OR (hashed SubPlan 3))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=257477 read=472
31.          

SubPlan (forIndex Scan)

32. 0.043 0.105 ↑ 3.0 1 1

Nested Loop (cost=0.28..4.53 rows=3 width=4) (actual time=0.042..0.105 rows=1 loops=1)

  • Output: departmentflathierarchy13.parentid
  • Join Filter: (departmentusers14.departmentid = departmentflathierarchy13.childid)
  • Rows Removed by Join Filter: 69
  • Buffers: shared read=4
33. 0.025 0.025 ↑ 1.0 1 1

Index Scan using ixduuserid on "1cd6229804074db79982d523a6c316d4".departmentusers departmentusers14 (cost=0.28..2.29 rows=1 width=4) (actual time=0.024..0.025 rows=1 loops=1)

  • Output: departmentusers14.departmentid, departmentusers14.userid, departmentusers14.isprimarydepartment
  • Index Cond: (departmentusers14.userid = 2)
  • Buffers: shared read=3
34. 0.037 0.037 ↓ 1.3 70 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".departmentflathierarchy departmentflathierarchy13 (cost=0.00..1.55 rows=55 width=8) (actual time=0.009..0.037 rows=70 loops=1)

  • Output: departmentflathierarchy13.parentid, departmentflathierarchy13.childid, departmentflathierarchy13.depth
  • Buffers: shared read=1
35. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5,219,999.36..5,234,164.92 rows=196,597 width=4) (never executed)

  • Output: task10_1.projectid
  • Hash Cond: (task10_1.id = taskteammemberassignment12_1.taskid)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".task task10_1 (cost=0.00..10,711.67 rows=396,778 width=8) (never executed)

  • Output: task10_1.id, task10_1.projectid, task10_1.parentid, task10_1.name, task10_1.code, task10_1.description, task10_1.isclosed, task10_1.orderindex, task10_1.percentcomplete, task10_1.istimeentryallowed, task10_1.estimatedhours, task10_1.timeentrystartdate, task10_1.timeentryenddate, task10_1.estimatedexpenses, task10_1.estimatedexpensescurrencyid, task10_1.expenseentrystartdate, task10_1.expenseentryenddate, task10_1.costtype, task10_1.estimatedcost, task10_1.estimatedcostcurrencyid, task10_1.timeandexpenseentrytype, task10_1.info1, task10_1.info2, task10_1.info3, task10_1.info4, task10_1.info5, task10_1.info6, task10_1.info7, task10_1.info8, task10_1.info9, task10_1.info10, task10_1.info11, task10_1.info12, task10_1.info13, task10_1.info14, task10_1.info15, task10_1.info16, task10_1.info17, task10_1.info18, task10_1.info19, task10_1.info20
  • Filter: (task10_1.istimeentryallowed AND (NOT task10_1.isclosed) AND (task10_1.timeentrystartdate <= '2019-05-19'::date) AND (task10_1.timeentryenddate >= '2019-05-13'::date))
37. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,217,541.90..5,217,541.90 rows=196,597 width=4) (never executed)

  • Output: taskteammemberassignment12_1.taskid
38. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=5,215,575.93..5,217,541.90 rows=196,597 width=4) (never executed)

  • Output: taskteammemberassignment12_1.taskid
  • Group Key: taskteammemberassignment12_1.taskid
39. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=12,904.09..4,985,742.30 rows=91,933,451 width=4) (never executed)

  • Output: taskteammemberassignment12_1.taskid
  • Hash Cond: (taskteammemberassignment12_1.projectteammemberid = projectteammember11_1.id)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".taskteammemberassignment taskteammemberassignment12_1 (cost=0.00..3,365,184.60 rows=183,551,760 width=20) (never executed)

  • Output: taskteammemberassignment12_1.id, taskteammemberassignment12_1.taskid, taskteammemberassignment12_1.projectteammemberid, taskteammemberassignment12_1.taskallocationstartdate, taskteammemberassignment12_1.taskallocationenddate, taskteammemberassignment12_1.taskallocationduration
41. 0.000 0.000 ↓ 0.0 0

Hash (cost=10,081.69..10,081.69 rows=225,792 width=16) (never executed)

  • Output: projectteammember11_1.id
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".projectteammember projectteammember11_1 (cost=4.54..10,081.69 rows=225,792 width=16) (never executed)

  • Output: projectteammember11_1.id
  • Filter: ((projectteammember11_1.userid = 2) OR (hashed SubPlan 5))
43.          

SubPlan (forSeq Scan)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..4.53 rows=3 width=4) (never executed)

  • Output: departmentflathierarchy13_1.parentid
  • Join Filter: (departmentusers14_1.departmentid = departmentflathierarchy13_1.childid)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "1cd6229804074db79982d523a6c316d4".departmentusers departmentusers14_1 (cost=0.28..2.29 rows=1 width=4) (never executed)

  • Output: departmentusers14_1.departmentid, departmentusers14_1.userid, departmentusers14_1.isprimarydepartment
  • Index Cond: (departmentusers14_1.userid = 2)
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".departmentflathierarchy departmentflathierarchy13_1 (cost=0.00..1.55 rows=55 width=8) (never executed)

  • Output: departmentflathierarchy13_1.parentid, departmentflathierarchy13_1.childid, departmentflathierarchy13_1.depth
47. 0.000 0.000 ↓ 0.0 0

Index Scan using uix3ptm_projectrole on "1cd6229804074db79982d523a6c316d4".projectteammember projectteammember15 (cost=4.96..390.85 rows=402 width=0) (never executed)

  • Index Cond: (projectteammember15.projectid = project5.id)
  • Filter: ((projectteammember15.userid = 2) OR (hashed SubPlan 7))
48.          

SubPlan (forIndex Scan)

49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..4.53 rows=3 width=4) (never executed)

  • Output: departmentflathierarchy16.parentid
  • Join Filter: (departmentusers17.departmentid = departmentflathierarchy16.childid)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "1cd6229804074db79982d523a6c316d4".departmentusers departmentusers17 (cost=0.28..2.29 rows=1 width=4) (never executed)

  • Output: departmentusers17.departmentid, departmentusers17.userid, departmentusers17.isprimarydepartment
  • Index Cond: (departmentusers17.userid = 2)
51. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".departmentflathierarchy departmentflathierarchy16 (cost=0.00..1.55 rows=55 width=8) (never executed)

  • Output: departmentflathierarchy16.parentid, departmentflathierarchy16.childid, departmentflathierarchy16.depth
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".projectteammember projectteammember15_1 (cost=4.54..10,081.69 rows=225,792 width=4) (never executed)

  • Output: projectteammember15_1.projectid
  • Filter: ((projectteammember15_1.userid = 2) OR (hashed SubPlan 9))
53.          

SubPlan (forSeq Scan)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..4.53 rows=3 width=4) (never executed)

  • Output: departmentflathierarchy16_1.parentid
  • Join Filter: (departmentusers17_1.departmentid = departmentflathierarchy16_1.childid)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "1cd6229804074db79982d523a6c316d4".departmentusers departmentusers17_1 (cost=0.28..2.29 rows=1 width=4) (never executed)

  • Output: departmentusers17_1.departmentid, departmentusers17_1.userid, departmentusers17_1.isprimarydepartment
  • Index Cond: (departmentusers17_1.userid = 2)
56. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1cd6229804074db79982d523a6c316d4".departmentflathierarchy departmentflathierarchy16_1 (cost=0.00..1.55 rows=55 width=8) (never executed)

  • Output: departmentflathierarchy16_1.parentid, departmentflathierarchy16_1.childid, departmentflathierarchy16_1.depth
57. 0.011 0.012 ↓ 0.0 0 2

Materialize (cost=0.00..11.05 rows=70 width=1,048) (actual time=0.006..0.006 rows=0 loops=2)

  • Output: program7.name, program7.slug, program7.id
58. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "1cd6229804074db79982d523a6c316d4".program program7 (cost=0.00..10.70 rows=70 width=1,048) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: program7.name, program7.slug, program7.id
59. 194,513.458 194,513.458 ↑ 32.9 17 2

CTE Scan on task0cte task6 (cost=0.00..11.18 rows=559 width=12) (actual time=97,256.713..97,256.729 rows=17 loops=2)

  • Output: task6.rowcount0, task6.projectid1
  • Buffers: shared hit=24 read=1537725 dirtied=83989 written=313