explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VnKY : SolarisMCI

Settings
# exclusive inclusive rows x rows loops node
1. 12,158.004 1,477,287.818 ↑ 9.5 368,544 1

Sort (cost=9,670,226.90..9,678,992.22 rows=3,506,130 width=387) (actual time=1,477,081.759..1,477,287.818 rows=368,544 loops=1)

  • Sort Key: ((pj.code)::character varying(50)) COLLATE "en_US", ((pj.name)::character varying(255)) COLLATE "en_US", ((tk.name)::character varying(255)) COLLATE "en_US", ((tk.code)::character varying(50)) COLLATE "en_US", ((ui.externalid)::character varyin (...)
  • Sort Method: quicksort Memory: 199360kB
  • Buffers: shared hit=7384094 read=1777598 written=21812
2.          

Initplan (forSort)

3. 0.287 0.287 ↑ 1.0 1 1

Seq Scan on systeminformation (cost=0.00..1.01 rows=1 width=4) (actual time=0.286..0.287 rows=1 loops=1)

  • Buffers: shared read=1
4. 1,381.746 1,465,129.527 ↑ 9.5 368,544 1

Hash Left Join (cost=1,630,749.68..8,932,992.17 rows=3,506,130 width=387) (actual time=80,872.188..1,465,129.527 rows=368,544 loops=1)

  • Hash Cond: (tk.id = tdh.taskid)
  • Buffers: shared hit=7384082 read=1777595 written=21812
5. 664.827 1,463,375.151 ↑ 9.5 368,544 1

Hash Left Join (cost=1,626,128.15..8,880,204.44 rows=3,506,130 width=328) (actual time=80,498.938..1,463,375.151 rows=368,544 loops=1)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate11.id)
  • Buffers: shared hit=7384082 read=1774967 written=21474
6. 669.428 1,462,692.831 ↑ 9.5 368,544 1

Hash Left Join (cost=1,626,112.47..8,831,979.47 rows=3,506,130 width=319) (actual time=80,481.417..1,462,692.831 rows=368,544 loops=1)

  • Hash Cond: (pj.projectleaderapproverid = userinfo10.id)
  • Buffers: shared hit=7384082 read=1774960 written=21473
7. 826.827 1,462,021.893 ↑ 9.5 368,544 1

Hash Left Join (cost=1,626,068.95..8,783,800.97 rows=3,506,130 width=309) (actual time=80,479.886..1,462,021.893 rows=368,544 loops=1)

  • Hash Cond: (COALESCE(clients18.id, pj.clientid) = cl.id)
  • Buffers: shared hit=7384061 read=1774960 written=21473
8. 645.480 1,461,170.010 ↑ 9.5 368,544 1

Hash Left Join (cost=1,626,022.90..8,759,212.01 rows=3,506,130 width=274) (actual time=80,454.812..1,461,170.010 rows=368,544 loops=1)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata17.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:client:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata17.uri, '^urn:replicon- (...)
  • Buffers: shared hit=7384060 read=1774931 written=21456
9. 1,546.697 1,460,515.269 ↑ 9.5 368,544 1

Hash Semi Join (cost=1,626,018.97..8,712,751.86 rows=3,506,130 width=328) (actual time=80,445.529..1,460,515.269 rows=368,544 loops=1)

  • Hash Cond: (pj.id = project19.id)
  • Buffers: shared hit=7384060 read=1774929 written=21455
10. 2,082.963 1,458,964.165 ↑ 16.2 1,480,475 1

Hash Left Join (cost=1,625,797.40..8,610,588.94 rows=23,975,493 width=328) (actual time=80,441.093..1,458,964.165 rows=1,480,475 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata17.timeentryid)
  • Buffers: shared hit=7384055 read=1774753 written=21455
11. 3,078.347 1,445,809.494 ↑ 16.2 1,480,475 1

Hash Left Join (cost=1,500,075.00..8,394,958.26 rows=23,975,493 width=270) (actual time=69,369.349..1,445,809.494 rows=1,480,475 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata7.timeentryid)
  • Buffers: shared hit=7384046 read=1698644 written=17911
12. 3,277.381 1,428,797.240 ↑ 16.2 1,480,475 1

Hash Left Join (cost=1,203,981.09..4,679,024.95 rows=23,975,493 width=225) (actual time=55,430.564..1,428,797.240 rows=1,480,475 loops=1)

  • Hash Cond: (task16.id = tk.id)
  • Buffers: shared hit=7383973 read=1509182 written=17911
13. 2,945.899 1,425,310.345 ↑ 16.2 1,480,475 1

Hash Join (cost=1,198,484.89..4,343,865.73 rows=23,975,493 width=200) (actual time=55,220.869..1,425,310.345 rows=1,480,475 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=7382347 read=1509180 written=17911
14. 3,143.854 1,422,358.324 ↑ 16.2 1,480,475 1

Hash Join (cost=1,198,325.91..4,014,043.71 rows=23,975,493 width=156) (actual time=55,214.726..1,422,358.324 rows=1,480,475 loops=1)

  • Hash Cond: (ts.id = tslist.timesheetid)
  • Buffers: shared hit=7382340 read=1509138 written=17911
15. 5,237.051 1,418,829.997 ↑ 16.2 1,485,361 1

Nested Loop (cost=1,181,318.92..3,667,150.50 rows=24,035,012 width=168) (actual time=54,829.286..1,418,829.997 rows=1,485,361 loops=1)

  • Buffers: shared hit=7382336 read=1495533 written=17911
16. 3,433.465 1,376,458.921 ↑ 1.0 1,485,361 1

Hash Join (cost=1,181,318.50..1,648,105.75 rows=1,505,279 width=144) (actual time=54,826.626..1,376,458.921 rows=1,485,361 loops=1)

  • Hash Cond: (COALESCE(project14.id, task16.projectid) = pj.id)
  • Buffers: shared hit=509960 read=1493312 written=17839
17. 544,148.577 1,373,022.961 ↑ 1.0 1,486,719 1

Hash Left Join (cost=1,181,073.80..1,627,163.46 rows=1,505,279 width=84) (actual time=54,824.093..1,373,022.961 rows=1,486,719 loops=1)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata15.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ( (...)
  • Buffers: shared hit=509779 read=1493312 written=17839
18. 556,314.608 828,707.902 ↑ 1.0 1,486,719 1

Hash Left Join (cost=1,177,451.83..1,593,435.91 rows=1,505,279 width=134) (actual time=54,656.678..828,707.902 rows=1,486,719 loops=1)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata13.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::tex (...)
  • Buffers: shared hit=509777 read=1491688 written=17839
19. 3,746.433 272,384.930 ↑ 1.0 1,486,719 1

Merge Left Join (cost=1,177,358.69..1,563,237.20 rows=1,505,279 width=188) (actual time=54,640.611..272,384.930 rows=1,486,719 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata13.timeentryid)
  • Buffers: shared hit=509767 read=1491673 written=17839
20. 3,362.822 60,662.711 ↑ 1.0 1,486,719 1

Merge Left Join (cost=1,177,358.14..1,207,180.21 rows=1,492,971 width=130) (actual time=54,640.552..60,662.711 rows=1,486,719 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata15.timeentryid)
  • Buffers: shared hit=74 read=468208 written=1859
21. 3,313.336 34,630.225 ↓ 1.0 1,486,719 1

Sort (cost=742,730.91..746,444.66 rows=1,485,502 width=72) (actual time=33,375.799..34,630.225 rows=1,486,719 loops=1)

  • Sort Key: "*SELECT* 1".timeentryid
  • Sort Method: quicksort Memory: 246096kB
  • Buffers: shared hit=29 read=278718 written=1859
22. 867.914 31,316.889 ↓ 1.0 1,486,719 1

Append (cost=190,808.97..590,448.24 rows=1,485,502 width=72) (actual time=9,978.078..31,316.889 rows=1,486,719 loops=1)

  • Buffers: shared hit=29 read=278718 written=1859
23. 954.405 30,441.861 ↓ 1.0 1,486,718 1

Subquery Scan on *SELECT* 1 (cost=190,808.97..590,446.20 rows=1,485,501 width=72) (actual time=9,978.074..30,441.861 rows=1,486,718 loops=1)

  • Buffers: shared hit=29 read=278716 written=1859
24. 4,335.611 29,487.456 ↓ 1.0 1,486,718 1

Hash Left Join (cost=190,808.97..575,591.19 rows=1,485,501 width=237) (actual time=9,978.071..29,487.456 rows=1,486,718 loops=1)

  • Hash Cond: (te.id = temdbreaktype.timeentryid)
  • Buffers: shared hit=29 read=278716 written=1859
25. 16,150.507 18,289.498 ↓ 1.0 1,486,718 1

Hash Right Join (cost=65,086.57..370,023.10 rows=1,485,501 width=179) (actual time=3,092.281..18,289.498 rows=1,486,718 loops=1)

  • Hash Cond: (tembillingrate.timeentryid = te.id)
  • Buffers: shared hit=19 read=202610
  • -> Seq Scan on timeentrymetadata tembillingrate (cost=0.00..286862.65 rows=1314464 width=74) (actual time=944.023..14128 (...)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text)
  • Rows Removed by Filter: 5178376
  • Buffers: shared hit=12 read=189523
26. 825.920 2,138.991 ↓ 1.0 1,486,718 1

Hash (cost=46,517.80..46,517.80 rows=1,485,501 width=121) (actual time=2,138.991..2,138.991 rows=1,486,718 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 236922kB
  • Buffers: shared hit=7 read=13087
27. 1,312.085 1,313.071 ↓ 1.0 1,486,718 1

Nested Loop (cost=0.00..46,517.80 rows=1,485,501 width=121) (actual time=1.450..1,313.071 rows=1,486,718 loops=1)

  • Buffers: shared hit=7 read=13087
  • -> Seq Scan on timeentry te (cost=0.00..31660.76 rows=1485501 width=56) (actual time=0.464..610.917 rows=148 (...)
28. 0.986 0.986 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.03 rows=1 width=65) (actual time=0.983..0.986 rows=1 loops=1)

  • Buffers: shared read=2
  • -> Seq Scan on systeminformation si (cost=0.00..1.01 rows=1 width=33) (actual time=0.465..0.466 rows=1 (...)
  • Buffers: shared read=1
  • -> Seq Scan on projectsysteminformation psi (cost=0.00..1.01 rows=1 width=32) (actual time=0.511..0.51 (...)
  • Buffers: shared read=1
  • Filter: ((entrydate IS NOT NULL) AND ((timeallocationtype <> 2) OR (timeallocationtype IS NULL)))
  • Buffers: shared hit=7 read=13085
29. 6,862.347 6,862.347 ↓ 0.0 0 1

Hash (cost=125,722.39..125,722.39 rows=1 width=74) (actual time=6,862.347..6,862.347 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=10 read=76106 written=1859
  • -> Index Scan using ixtem2timeentryid on timeentrymetadata temdbreaktype (cost=0.56..125722.39 rows=1 width=74) (actual (...)
  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
  • Buffers: shared hit=10 read=76106 written=1859
30. 0.001 7.114 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=0.00..2.04 rows=1 width=72) (actual time=7.112..7.114 rows=1 loops=1)

  • Buffers: shared read=2
31. 0.017 7.113 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.03 rows=1 width=24) (actual time=7.111..7.113 rows=1 loops=1)

  • Join Filter: (toe.timeoffid = toff.id)
  • Buffers: shared read=2
32. 4.697 4.697 ↑ 1.0 1 1

Seq Scan on timeoffentries toe (cost=0.00..1.01 rows=1 width=24) (actual time=4.697..4.697 rows=1 loops=1)

  • Filter: (entrydate IS NOT NULL)
  • Buffers: shared read=1
33. 2.399 2.399 ↑ 1.0 1 1

Seq Scan on timeoffs toff (cost=0.00..1.01 rows=1 width=8) (actual time=2.399..2.399 rows=1 loops=1)

  • Buffers: shared read=1
34. 22,669.664 22,669.664 ↓ 1.0 1,447,332 1

Sort (cost=434,627.23..438,237.95 rows=1,444,288 width=74) (actual time=21,264.745..22,669.664 rows=1,447,332 loops=1)

  • Sort Key: timeentrymetadata15.timeentryid
  • Sort Method: quicksort Memory: 240933kB
  • Buffers: shared hit=45 read=189490
  • -> Seq Scan on timeentrymetadata timeentrymetadata15 (cost=0.00..286862.65 rows=1444288 width=74) (actual time=0.028..16795.402 rows=1447332 loo (...)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
  • Rows Removed by Filter: 5047531
  • Buffers: shared hit=45 read=189490
35. 207,975.786 207,975.786 ↓ 1.0 1,457,006 1

Materialize (cost=0.56..333,367.64 rows=1,448,911 width=74) (actual time=0.051..207,975.786 rows=1,457,006 loops=1)

  • Buffers: shared hit=509693 read=1023465 written=15980
  • -> Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata13 (cost=0.56..329745.36 rows=1448911 width=74) (actual time=0.039..206130 (...)
  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text)
  • Buffers: shared hit=509693 read=1023465 written=15980
36. 1.580 8.364 ↓ 1.0 2,832 1

Hash (cost=57.75..57.75 rows=2,831 width=4) (actual time=8.364..8.364 rows=2,832 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 132kB
  • Buffers: shared hit=10 read=15
37. 6.784 6.784 ↓ 1.0 2,832 1

Index Only Scan using project_pkey on project project14 (cost=0.28..57.75 rows=2,831 width=4) (actual time=0.860..6.784 rows=2,832 loops=1)

  • Heap Fetches: 76
  • Buffers: shared hit=10 read=15
38. 77.497 166.482 ↓ 1.0 88,724 1

Hash (cost=2,513.10..2,513.10 rows=88,710 width=8) (actual time=166.482..166.482 rows=88,724 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4490kB
  • Buffers: shared hit=2 read=1624
39. 88.985 88.985 ↓ 1.0 88,724 1

Seq Scan on task task16 (cost=0.00..2,513.10 rows=88,710 width=8) (actual time=3.429..88.985 rows=88,724 loops=1)

  • Buffers: shared hit=2 read=1624
40. 1.157 2.495 ↓ 1.0 2,832 1

Hash (cost=209.31..209.31 rows=2,831 width=68) (actual time=2.495..2.495 rows=2,832 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 319kB
  • Buffers: shared hit=181
41. 1.338 1.338 ↓ 1.0 2,832 1

Seq Scan on project pj (cost=0.00..209.31 rows=2,831 width=68) (actual time=0.004..1.338 rows=2,832 loops=1)

  • Buffers: shared hit=181
42. 37,134.025 37,134.025 ↑ 16.0 1 1,485,361

Index Scan using ixtsuseridstartdateenddate on timesheet ts (cost=0.42..1.18 rows=16 width=28) (actual time=0.025..0.025 rows=1 loops=1,485,361)

  • Index Cond: ((userid = "*SELECT* 1".userid) AND ("*SELECT* 1".entrydate >= startdate) AND ("*SELECT* 1".entrydate <= enddate))
  • Buffers: shared hit=6872376 read=2221 written=72
43. 54.664 384.473 ↑ 1.0 135,751 1

Hash (cost=15,310.10..15,310.10 rows=135,751 width=20) (actual time=384.473..384.473 rows=135,751 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8942kB
  • Buffers: shared hit=4 read=13605
44. 329.809 329.809 ↑ 1.0 135,751 1

Seq Scan on dm_timesheetlist_facts tslist (cost=0.00..15,310.10 rows=135,751 width=20) (actual time=0.507..329.809 rows=135,751 loops=1)

  • Filter: (timesheetstatus = 2)
  • Rows Removed by Filter: 341
  • Buffers: shared hit=4 read=13605
45. 0.536 6.122 ↑ 1.0 1,001 1

Hash (cost=146.47..146.47 rows=1,001 width=56) (actual time=6.122..6.122 rows=1,001 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 97kB
  • Buffers: shared hit=7 read=42
46. 0.544 5.586 ↑ 1.0 1,001 1

Hash Join (cost=74.17..146.47 rows=1,001 width=56) (actual time=2.705..5.586 rows=1,001 loops=1)

  • Hash Cond: (du.departmentid = dep.id)
  • Buffers: shared hit=7 read=42
47. 0.580 5.008 ↑ 1.0 1,001 1

Hash Join (cost=72.05..130.58 rows=1,001 width=46) (actual time=2.659..5.008 rows=1,001 loops=1)

  • Hash Cond: (ui.id = du.userid)
  • Buffers: shared hit=6 read=42
48. 0.824 3.725 ↑ 1.0 1,001 1

Hash Join (cost=43.52..88.30 rows=1,001 width=38) (actual time=1.945..3.725 rows=1,001 loops=1)

  • Hash Cond: (ui.id = login.userid)
  • Buffers: shared hit=4 read=38
49. 1.547 1.547 ↑ 1.0 1,001 1

Seq Scan on userinfo ui (cost=0.00..31.01 rows=1,001 width=26) (actual time=0.574..1.547 rows=1,001 loops=1)

  • Buffers: shared hit=3 read=18
50. 0.351 1.354 ↑ 1.0 1,001 1

Hash (cost=31.01..31.01 rows=1,001 width=12) (actual time=1.354..1.354 rows=1,001 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 53kB
  • Buffers: shared hit=1 read=20
51. 1.003 1.003 ↑ 1.0 1,001 1

Seq Scan on login (cost=0.00..31.01 rows=1,001 width=12) (actual time=0.022..1.003 rows=1,001 loops=1)

  • Buffers: shared hit=1 read=20
52. 0.310 0.703 ↑ 1.0 1,001 1

Hash (cost=16.01..16.01 rows=1,001 width=8) (actual time=0.703..0.703 rows=1,001 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=2 read=4
53. 0.393 0.393 ↑ 1.0 1,001 1

Seq Scan on departmentusers du (cost=0.00..16.01 rows=1,001 width=8) (actual time=0.003..0.393 rows=1,001 loops=1)

  • Buffers: shared hit=2 read=4
54. 0.021 0.034 ↑ 1.0 50 1

Hash (cost=1.50..1.50 rows=50 width=18) (actual time=0.034..0.034 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
55. 0.013 0.013 ↑ 1.0 50 1

Seq Scan on departments dep (cost=0.00..1.50 rows=50 width=18) (actual time=0.002..0.013 rows=50 loops=1)

  • Buffers: shared hit=1
56. 59.875 209.514 ↓ 1.0 88,724 1

Hash (cost=4,387.32..4,387.32 rows=88,710 width=29) (actual time=209.514..209.514 rows=88,724 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 6570kB
  • Buffers: shared hit=1626 read=2
57. 107.385 149.639 ↓ 1.0 88,724 1

Hash Left Join (cost=2.44..4,387.32 rows=88,710 width=29) (actual time=0.850..149.639 rows=88,724 loops=1)

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=1626 read=2
58. 41.439 41.439 ↓ 1.0 88,724 1

Seq Scan on task tk (cost=0.00..2,513.10 rows=88,710 width=33) (actual time=0.007..41.439 rows=88,724 loops=1)

  • Buffers: shared hit=1626
59. 0.007 0.815 ↑ 1.0 7 1

Hash (cost=2.35..2.35 rows=7 width=4) (actual time=0.815..0.815 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=2
60. 0.808 0.808 ↑ 1.0 7 1

Seq Scan on exchangerate (cost=0.00..2.35 rows=7 width=4) (actual time=0.789..0.808 rows=7 loops=1)

  • Filter: ((variablecurrencyid = $0) AND (('now'::cstring)::date >= effectivedate) AND (('now'::cstring)::date <= enddate))
  • Rows Removed by Filter: 42
  • Buffers: shared read=2
61. 790.680 13,933.907 ↓ 1.0 738,600 1

Hash (cost=286,862.65..286,862.65 rows=738,501 width=61) (actual time=13,933.907..13,933.907 rows=738,600 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 75551kB
  • Buffers: shared hit=73 read=189462
62. 13,143.227 13,143.227 ↓ 1.0 738,600 1

Seq Scan on timeentrymetadata timeentrymetadata7 (cost=0.00..286,862.65 rows=738,501 width=61) (actual time=2,085.566..13,143.227 rows=738,600 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:COMMENTS'::text)
  • Rows Removed by Filter: 5756263
  • Buffers: shared hit=73 read=189462
63. 0.002 11,071.708 ↓ 0.0 0 1

Hash (cost=125,722.39..125,722.39 rows=1 width=74) (actual time=11,071.708..11,071.708 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=9 read=76109 written=3544
64. 11,071.706 11,071.706 ↓ 0.0 0 1

Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata17 (cost=0.56..125,722.39 rows=1 width=74) (actual time=11,071.706..11,071.706 rows=0 loops=1)

  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:CLIENT'::text)
  • Buffers: shared hit=9 read=76109 written=3544
65. 0.128 4.407 ↑ 1.0 414 1

Hash (cost=216.39..216.39 rows=414 width=4) (actual time=4.407..4.407 rows=414 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=5 read=176
66. 4.279 4.279 ↑ 1.0 414 1

Seq Scan on project project19 (cost=0.00..216.39 rows=414 width=4) (actual time=0.023..4.279 rows=414 loops=1)

  • Filter: (projectstatuslabelid = 'f6918709-d5cf-436b-b0ff-2191cd2dd6a9'::uuid)
  • Rows Removed by Filter: 2418
  • Buffers: shared hit=5 read=176
67. 0.035 9.261 ↑ 1.0 65 1

Hash (cost=3.12..3.12 rows=65 width=4) (actual time=9.261..9.261 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared read=2 written=1
68. 9.226 9.226 ↑ 1.0 65 1

Index Only Scan using clients_pkey on clients clients18 (cost=0.14..3.12 rows=65 width=4) (actual time=9.199..9.226 rows=65 loops=1)

  • Heap Fetches: 0
  • Buffers: shared read=2 written=1
69. 0.049 25.056 ↑ 1.0 65 1

Hash (cost=45.24..45.24 rows=65 width=43) (actual time=25.056..25.056 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1 read=29 written=17
70. 0.472 25.007 ↑ 1.0 65 1

Hash Right Join (cost=10.46..45.24 rows=65 width=43) (actual time=24.973..25.007 rows=65 loops=1)

  • Hash Cond: (userinfo9.id = cl.clientmanageruserid)
  • Buffers: shared hit=1 read=29 written=17
71. 8.624 8.624 ↑ 1.0 1,001 1

Seq Scan on userinfo userinfo9 (cost=0.00..31.01 rows=1,001 width=18) (actual time=3.998..8.624 rows=1,001 loops=1)

  • Buffers: shared hit=1 read=20 written=13
72. 0.046 15.911 ↑ 1.0 65 1

Hash (cost=9.65..9.65 rows=65 width=33) (actual time=15.911..15.911 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared read=9 written=4
73. 15.865 15.865 ↑ 1.0 65 1

Seq Scan on clients cl (cost=0.00..9.65 rows=65 width=33) (actual time=7.911..15.865 rows=65 loops=1)

  • Buffers: shared read=9 written=4
74. 0.606 1.510 ↑ 1.0 1,001 1

Hash (cost=31.01..31.01 rows=1,001 width=18) (actual time=1.510..1.510 rows=1,001 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
  • Buffers: shared hit=21
75. 0.904 0.904 ↑ 1.0 1,001 1

Seq Scan on userinfo userinfo10 (cost=0.00..31.01 rows=1,001 width=18) (actual time=0.004..0.904 rows=1,001 loops=1)

  • Buffers: shared hit=21
76. 0.254 17.493 ↑ 1.0 386 1

Hash (cost=10.86..10.86 rows=386 width=41) (actual time=17.493..17.493 rows=386 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared read=7 written=1
77. 17.239 17.239 ↑ 1.0 386 1

Seq Scan on billingrate billingrate11 (cost=0.00..10.86 rows=386 width=41) (actual time=13.308..17.239 rows=386 loops=1)

  • Buffers: shared read=7 written=1
78. 108.851 372.630 ↓ 1.0 88,724 1

Hash (cost=3,514.01..3,514.01 rows=88,601 width=63) (actual time=372.630..372.630 rows=88,724 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 9462kB
  • Buffers: shared read=2628 written=338
79. 263.779 263.779 ↓ 1.0 88,724 1

Seq Scan on taskdenormalizedhierarchy tdh (cost=0.00..3,514.01 rows=88,601 width=63) (actual time=3.207..263.779 rows=88,724 loops=1)

  • Buffers: shared read=2628 written=338
Planning time : 144.733 ms
Execution time : 1,477,509.367 ms