explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oVHL : SolarisMaster

Settings
# exclusive inclusive rows x rows loops node
1. 45.358 356,093.276 ↑ 564.4 4,346 1

Sort (cost=3,102,953.91..3,109,086.08 rows=2,452,866 width=410) (actual time=356,090.999..356,093.276 rows=4,346 loops=1)

  • Sort Key: ((pj.code)::character varying(50)) COLLATE "en_US", ((pj.name)::character varying(255)) COLLATE "en_US", ((cl.name)::character varying(255)) COLLATE "en_US", ((tk.name)::character varying(255)) COLLATE "en_US", ((tk.code)::character varying(50) (...)
  • Sort Method: quicksort Memory: 2780kB
  • Buffers: shared hit=311367 read=577786 dirtied=1450 written=8, temp read=25344 written=25348
2.          

Initplan (forSort)

3. 0.003 0.003 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
4. 6.488 356,047.915 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,785.34..2,579,137.78 rows=2,452,866 width=410) (actual time=354,165.902..356,047.915 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate11.id)
  • Buffers: shared hit=311349 read=577786 dirtied=1450 written=8, temp read=25344 written=25348
5. 4.110 356,040.314 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,769.86..2,545,395.39 rows=2,452,866 width=401) (actual time=354,164.767..356,040.314 rows=4,346 loops=1)

  • Hash Cond: (pj.projectleaderapproverid = userinfo10.id)
  • Buffers: shared hit=311346 read=577782 dirtied=1450 written=8, temp read=25344 written=25348
6. 5.941 356,035.289 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,726.49..2,511,687.26 rows=2,452,866 width=391) (actual time=354,163.829..356,035.289 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata9.timeentryid)
  • Buffers: shared hit=311329 read=577778 dirtied=1450 written=8, temp read=25344 written=25348
7. 6.091 349,142.067 ↑ 564.4 4,346 1

Hash Left Join (cost=1,165,180.24..1,894,455.61 rows=2,452,866 width=346) (actual time=347,276.370..349,142.067 rows=4,346 loops=1)

  • Hash Cond: (tk.id = tdh.taskid)
  • Buffers: shared hit=121794 read=577778 dirtied=1450 written=8, temp read=25344 written=25348
8. 4.840 349,028.008 ↑ 564.4 4,346 1

Hash Join (cost=1,160,636.84..1,856,185.30 rows=2,452,866 width=286) (actual time=347,167.890..349,028.008 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=121696 read=575304 dirtied=1418 written=8, temp read=25344 written=25348
9. 4.990 349,020.763 ↑ 564.4 4,346 1

Hash Join (cost=1,160,537.65..1,822,359.20 rows=2,452,866 width=268) (actual time=347,165.465..349,020.763 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=121676 read=575298 dirtied=1418 written=8, temp read=25344 written=25348
10. 4.080 349,014.804 ↑ 564.4 4,346 1

Hash Left Join (cost=1,160,494.28..1,788,588.93 rows=2,452,866 width=229) (actual time=347,164.482..349,014.804 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(clients17.id, pj.clientid) = cl.id)
  • Buffers: shared hit=121659 read=575294 dirtied=1418 written=8, temp read=25344 written=25348
11. 4.033 349,010.616 ↑ 564.4 4,346 1

Hash Left Join (cost=1,160,483.80..1,771,285.74 rows=2,452,866 width=221) (actual time=347,164.350..349,010.616 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata16.timeentryid)
  • Buffers: shared hit=121658 read=575286 dirtied=1418 written=8, temp read=25344 written=25348
12. 6.014 341,445.478 ↑ 564.4 4,346 1

Hash Left Join (cost=874,589.38..1,153,705.94 rows=2,452,866 width=217) (actual time=339,603.113..341,445.478 rows=4,346 loops=1)

  • Hash Cond: (task15.id = tk.id)
  • Buffers: shared hit=105658 read=401751 dirtied=1418 written=8, temp read=25344 written=25348
13. 6.342 341,314.862 ↑ 564.4 4,346 1

Hash Join (cost=869,197.24..1,114,586.88 rows=2,452,866 width=176) (actual time=339,478.042..341,314.862 rows=4,346 loops=1)

  • Hash Cond: (ts.id = tslist.timesheetid)
  • Buffers: shared hit=105456 read=400355 dirtied=1418 written=8, temp read=25344 written=25348
14. 8.707 340,932.938 ↑ 565.8 4,346 1

Nested Loop (cost=853,001.58..1,064,641.95 rows=2,458,830 width=188) (actual time=339,101.513..340,932.938 rows=4,346 loops=1)

  • Buffers: shared hit=105250 read=388379 dirtied=1418 written=8, temp read=25344 written=25348
15. 5.458 340,846.003 ↑ 35.4 4,346 1

Hash Left Join (cost=853,001.16..856,656.43 rows=153,778 width=160) (actual time=339,101.471..340,846.003 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(project13.id, task15.projectid) = pj.id)
  • Buffers: shared hit=83029 read=388020 dirtied=1418 written=8, temp read=25344 written=25348
16. 396.967 340,837.847 ↑ 35.4 4,346 1

Merge Left Join (cost=852,783.87..854,324.70 rows=153,778 width=84) (actual time=339,098.748..340,837.847 rows=4,346 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata12.timeentryid)
  • Buffers: shared hit=82922 read=387992 dirtied=1418 written=8, temp read=25344 written=25348
17. 387.044 169,825.766 ↑ 35.4 4,346 1

Merge Left Join (cost=564,543.47..565,506.11 rows=153,778 width=80) (actual time=168,962.535..169,825.766 rows=4,346 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata14.timeentryid)
  • Buffers: shared hit=80488 read=200223 dirtied=1418, temp read=13244 written=13246
18. 8.999 4,002.614 ↑ 35.4 4,346 1

Sort (cost=272,906.77..273,291.21 rows=153,778 width=72) (actual time=4,000.235..4,002.614 rows=4,346 loops=1)

  • Sort Key: "*SELECT* 1".timeentryid
  • Sort Method: quicksort Memory: 775kB
  • Buffers: shared hit=78410 read=11170 dirtied=650
19. 2.765 3,993.615 ↑ 35.4 4,346 1

Append (cost=2.14..259,658.42 rows=153,778 width=72) (actual time=6.984..3,993.615 rows=4,346 loops=1)

  • Buffers: shared hit=78410 read=11170 dirtied=650
20. 3.535 3,989.935 ↑ 35.4 4,346 1

Subquery Scan on *SELECT* 1 (cost=2.14..259,652.88 rows=153,762 width=72) (actual time=6.984..3,989.935 rows=4,346 loops=1)

  • Buffers: shared hit=78410 read=11169 dirtied=650
21. 322.860 3,986.400 ↑ 35.4 4,346 1

Nested Loop Left Join (cost=2.14..258,115.26 rows=153,762 width=235) (actual time=6.982..3,986.400 rows=4,346 loops=1)

  • Buffers: shared hit=78410 read=11169 dirtied=650
22. 135.069 3,142.020 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=1.29..71,759.83 rows=4,622 width=235) (actual time=4.267..3,142.020 rows=4,346 loops=1)

  • Buffers: shared hit=34618 read=10169 dirtied=643
  • -> Index Scan using ixtemtimeentryid on timeentrymetadata temdbreaktype (cost=0.43..5.28 rows=1 width=73) (actual time=0.029..0.029 rows=0 (...)
23. 2,814.348 3,006.951 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=0.86..47,329.73 rows=4,622 width=178) (actual time=4.242..3,006.951 rows=4,346 loops=1)

  • Buffers: shared hit=16239 read=9933 dirtied=164
  • -> Index Scan using ixtemtimeentryid on timeentrymetadata tembillingrate (cost=0.43..5.27 rows=1 width=73) (actual time=0.645..0.646 (...)
  • Index Cond: (timeentryid = te.id)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=18379 read=236 dirtied=479
24. 188.257 192.603 ↑ 1.1 4,346 1

Nested Loop (cost=0.43..22,945.85 rows=4,622 width=121) (actual time=2.201..192.603 rows=4,346 loops=1)

  • Buffers: shared hit=3170 read=4223 dirtied=45
  • -> Index Scan using ixte2userid on timeentry te (cost=0.43..22886.04 rows=4622 width=56) (actual time=1.766..182.319 rows=4346 (...)
  • Index Cond: ((entrydate >= '2019-03-30'::date) AND (entrydate <= '2019-04-05'::date))
  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
  • Buffers: shared hit=3170 read=4221 dirtied=45
  • Index Cond: (timeentryid = te.id)
  • Filter: (key = 'urn:replicon:time-entry-metadata-key:billing-rate'::text)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=13069 read=5710 dirtied=119
25. 3.917 4.346 ↑ 1.0 1 4,346

Materialize (cost=0.00..2.03 rows=1 width=65) (actual time=0.000..0.001 rows=1 loops=4,346)

  • Buffers: shared read=2
26. 0.420 0.429 ↑ 1.0 1 1

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

  • Buffers: shared read=2
  • -> Seq Scan on projectsysteminformation psi (cost=0.00..1.01 rows=1 width=32) (actual time=0.414..0.415 rows=1 loo (...)
27. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on systeminformation si (cost=0.00..1.01 rows=1 width=33) (actual time=0.008..0.009 rows=1 loops=1)

  • Buffers: shared read=1
  • Buffers: shared read=1
28. 521.520 521.520 ↑ 16.0 1 4,346

Nested Loop Left Join (cost=0.85..38.50 rows=16 width=12) (actual time=0.105..0.120 rows=1 loops=4,346)

  • Buffers: shared hit=43792 read=1000 dirtied=7
  • -> Index Scan using ixtsuseridstartdateenddate on timesheet ts_1 (cost=0.42..1.60 rows=16 width=28) (actual time=0.017..0.017 rows=1 loops (...)
  • Index Cond: ((userid = te.userid) AND (te.entrydate >= startdate) AND (te.entrydate <= enddate))
  • Buffers: shared hit=22214 read=366
  • -> Index Scan using ixtpsstimesheetid on timesheetpolicysettingssnapshot tspolicy (cost=0.43..2.30 rows=1 width=16) (actual time=0.086..0. (...)
  • Index Cond: (timesheetid = ts_1.id)
  • Filter: (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text)
  • Rows Removed by Filter: 23
  • Buffers: shared hit=21578 read=634 dirtied=7
29. 0.002 0.915 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.42..5.54 rows=16 width=72) (actual time=0.915..0.915 rows=0 loops=1)

  • Buffers: shared read=1
30. 0.000 0.913 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.42..5.38 rows=16 width=24) (actual time=0.913..0.913 rows=0 loops=1)

  • Buffers: shared read=1
31. 0.002 0.913 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.04 rows=1 width=24) (actual time=0.913..0.913 rows=0 loops=1)

  • Join Filter: (toe.timeoffid = toff.id)
  • Buffers: shared read=1
32. 0.911 0.911 ↓ 0.0 0 1

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

  • Filter: ((entrydate >= '2019-03-30'::date) AND (entrydate <= '2019-04-05'::date))
  • Rows Removed by Filter: 1
  • Buffers: shared read=1
33. 0.000 0.000 ↓ 0.0 0

Seq Scan on timeoffs toff (cost=0.00..1.01 rows=1 width=8) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixtsuseridstartdateenddate on timesheet ts_2 (cost=0.42..3.18 rows=16 width=12) (never executed)

  • Index Cond: ((userid = toff.userid) AND (startdate <= toe.entrydate) AND (enddate >= toe.entrydate))
  • Heap Fetches: 0
35. 4,921.873 165,436.108 ↓ 44.7 1,425,808 1

Sort (cost=291,636.71..291,716.38 rows=31,871 width=24) (actual time=164,962.209..165,436.108 rows=1,425,808 loops=1)

  • Sort Key: timeentrymetadata14.timeentryid
  • Sort Method: external sort Disk: 52984kB
  • Buffers: shared hit=2078 read=189053 dirtied=768, temp read=13244 written=13246
36. 151,250.933 160,514.235 ↓ 44.7 1,426,193 1

Hash Left Join (cost=3,547.16..289,252.76 rows=31,871 width=24) (actual time=63.500..160,514.235 rows=1,426,193 loops=1)

  • Hash Cond: (("substring"(timeentrymetadata14.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:task:(.*)$'::text))::integer = task15.id)
  • Buffers: shared hit=2078 read=189053 dirtied=768
37. 9,200.698 9,200.698 ↓ 44.7 1,426,193 1

Seq Scan on timeentrymetadata timeentrymetadata14 (cost=0.00..285,147.86 rows=31,871 width=73) (actual time=0.014..9,200.698 rows=1,426,193 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
  • Rows Removed by Filter: 4958496
  • Buffers: shared hit=1937 read=187598 dirtied=768
38. 29.407 62.604 ↑ 1.0 86,689 1

Hash (cost=2,463.18..2,463.18 rows=86,718 width=8) (actual time=62.604..62.604 rows=86,689 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4411kB
  • Buffers: shared hit=141 read=1455
39. 33.197 33.197 ↑ 1.0 86,689 1

Seq Scan on task task15 (cost=0.00..2,463.18 rows=86,718 width=8) (actual time=0.010..33.197 rows=86,689 loops=1)

  • Buffers: shared hit=141 read=1455
40. 4,873.919 170,615.114 ↓ 45.7 1,455,933 1

Sort (cost=288,240.40..288,320.08 rows=31,871 width=20) (actual time=170,136.142..170,615.114 rows=1,455,933 loops=1)

  • Sort Key: timeentrymetadata12.timeentryid
  • Sort Method: external sort Disk: 48408kB
  • Buffers: shared hit=2434 read=187769 written=8, temp read=12100 written=12102
41. 157,984.633 165,741.195 ↓ 45.7 1,456,325 1

Hash Left Join (cost=150.85..285,856.45 rows=31,871 width=20) (actual time=5.523..165,741.195 rows=1,456,325 loops=1)

  • Hash Cond: (("substring"(timeentrymetadata12.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:project:(.*)$'::text))::integer = project13.id)
  • Buffers: shared hit=2434 read=187769 written=8
42. 7,751.628 7,751.628 ↓ 45.7 1,456,325 1

Seq Scan on timeentrymetadata timeentrymetadata12 (cost=0.00..285,147.86 rows=31,871 width=73) (actual time=0.075..7,751.628 rows=1,456,325 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text)
  • Rows Removed by Filter: 4928364
  • Buffers: shared hit=1860 read=187675 written=8
43. 0.999 4.934 ↑ 1.3 2,772 1

Hash (cost=105.13..105.13 rows=3,657 width=4) (actual time=4.934..4.934 rows=2,772 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=574 read=94
44. 3.935 3.935 ↑ 1.3 2,772 1

Index Only Scan using project_pkey on project project13 (cost=0.28..105.13 rows=3,657 width=4) (actual time=0.046..3.935 rows=2,772 loops=1)

  • Heap Fetches: 1511
  • Buffers: shared hit=574 read=94
45. 1.197 2.698 ↑ 1.3 2,772 1

Hash (cost=171.57..171.57 rows=3,657 width=84) (actual time=2.698..2.698 rows=2,772 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 361kB
  • Buffers: shared hit=107 read=28
46. 1.501 1.501 ↑ 1.3 2,772 1

Seq Scan on project pj (cost=0.00..171.57 rows=3,657 width=84) (actual time=0.006..1.501 rows=2,772 loops=1)

  • Buffers: shared hit=107 read=28
47. 78.228 78.228 ↑ 16.0 1 4,346

Index Scan using ixtsuseridstartdateenddate on timesheet ts (cost=0.42..1.19 rows=16 width=28) (actual time=0.018..0.018 rows=1 loops=4,346)

  • Index Cond: ((userid = "*SELECT* 1".userid) AND ("*SELECT* 1".entrydate >= startdate) AND ("*SELECT* 1".entrydate <= enddate))
  • Buffers: shared hit=22221 read=359
48. 56.611 375.582 ↑ 1.0 134,993 1

Hash (cost=14,452.99..14,452.99 rows=139,414 width=20) (actual time=375.582..375.582 rows=134,993 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8904kB
  • Buffers: shared hit=206 read=11976
49. 318.971 318.971 ↑ 1.0 134,993 1

Seq Scan on dm_timesheetlist_facts tslist (cost=0.00..14,452.99 rows=139,414 width=20) (actual time=0.466..318.971 rows=134,993 loops=1)

  • Filter: (timesheetstatus = ANY ('{0,1,2,3,4}'::integer[]))
  • Buffers: shared hit=206 read=11976
50. 37.403 124.602 ↑ 1.0 86,689 1

Hash (cost=4,308.17..4,308.17 rows=86,718 width=45) (actual time=124.602..124.602 rows=86,689 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8173kB
  • Buffers: shared hit=202 read=1396
51. 59.994 87.199 ↑ 1.0 86,689 1

Hash Left Join (cost=2.44..4,308.17 rows=86,718 width=45) (actual time=0.057..87.199 rows=86,689 loops=1)

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=202 read=1396
52. 27.170 27.170 ↑ 1.0 86,689 1

Seq Scan on task tk (cost=0.00..2,463.18 rows=86,718 width=49) (actual time=0.007..27.170 rows=86,689 loops=1)

  • Buffers: shared hit=200 read=1396
53. 0.007 0.035 ↑ 1.0 7 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
54. 0.028 0.028 ↑ 1.0 7 1

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

  • Filter: ((variablecurrencyid = $0) AND (('now'::cstring)::date >= effectivedate) AND (('now'::cstring)::date <= enddate))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=2
55. 0.001 7,561.105 ↓ 0.0 0 1

Hash (cost=285,496.02..285,496.02 rows=31,871 width=20) (actual time=7,561.105..7,561.105 rows=0 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 256kB
  • Buffers: shared hit=16000 read=173535
56. 0.002 7,561.104 ↓ 0.0 0 1

Hash Left Join (cost=3.96..285,496.02 rows=31,871 width=20) (actual time=7,561.104..7,561.104 rows=0 loops=1)

  • Hash Cond: (("substring"(timeentrymetadata16.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:client:(.*)$'::text))::integer = clients17.id)
  • Buffers: shared hit=16000 read=173535
57. 7,561.102 7,561.102 ↓ 0.0 0 1

Seq Scan on timeentrymetadata timeentrymetadata16 (cost=0.00..285,147.86 rows=31,871 width=73) (actual time=7,561.102..7,561.102 rows=0 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:CLIENT'::text)
  • Rows Removed by Filter: 6384689
  • Buffers: shared hit=16000 read=173535
58. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.13..3.13 rows=66 width=4) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Index Only Scan using clients_pkey on clients clients17 (cost=0.14..3.13 rows=66 width=4) (never executed)

  • Heap Fetches: 0
60. 0.034 0.108 ↑ 1.0 66 1

Hash (cost=9.66..9.66 rows=66 width=16) (actual time=0.108..0.108 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1 read=8
61. 0.074 0.074 ↑ 1.0 66 1

Seq Scan on clients cl (cost=0.00..9.66 rows=66 width=16) (actual time=0.003..0.074 rows=66 loops=1)

  • Buffers: shared hit=1 read=8
62. 0.435 0.969 ↑ 1.0 994 1

Hash (cost=30.94..30.94 rows=994 width=39) (actual time=0.969..0.969 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=17 read=4
63. 0.534 0.534 ↑ 1.0 994 1

Seq Scan on userinfo ui (cost=0.00..30.94 rows=994 width=39) (actual time=0.003..0.534 rows=994 loops=1)

  • Buffers: shared hit=17 read=4
64. 0.384 2.405 ↑ 1.0 994 1

Hash (cost=86.76..86.76 rows=994 width=30) (actual time=2.405..2.405 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
  • Buffers: shared hit=20 read=6
65. 0.558 2.021 ↑ 1.0 994 1

Hash Join (cost=30.49..86.76 rows=994 width=30) (actual time=0.639..2.021 rows=994 loops=1)

  • Hash Cond: (du.departmentid = dep.id)
  • Buffers: shared hit=20 read=6
66. 0.588 1.423 ↑ 1.0 994 1

Hash Join (cost=28.37..70.97 rows=994 width=20) (actual time=0.590..1.423 rows=994 loops=1)

  • Hash Cond: (login.userid = du.userid)
  • Buffers: shared hit=19 read=6
67. 0.262 0.262 ↑ 1.0 994 1

Seq Scan on login (cost=0.00..28.94 rows=994 width=12) (actual time=0.002..0.262 rows=994 loops=1)

  • Buffers: shared hit=16 read=3
68. 0.318 0.573 ↑ 1.0 994 1

Hash (cost=15.94..15.94 rows=994 width=8) (actual time=0.573..0.573 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 47kB
  • Buffers: shared hit=3 read=3
69. 0.255 0.255 ↑ 1.0 994 1

Seq Scan on departmentusers du (cost=0.00..15.94 rows=994 width=8) (actual time=0.001..0.255 rows=994 loops=1)

  • Buffers: shared hit=3 read=3
70. 0.024 0.040 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
72. 40.666 107.968 ↑ 1.0 86,689 1

Hash (cost=3,448.18..3,448.18 rows=87,618 width=64) (actual time=107.968..107.968 rows=86,689 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 9293kB
  • Buffers: shared hit=98 read=2474 dirtied=32
73. 67.302 67.302 ↑ 1.0 86,689 1

Seq Scan on taskdenormalizedhierarchy tdh (cost=0.00..3,448.18 rows=87,618 width=64) (actual time=0.003..67.302 rows=86,689 loops=1)

  • Buffers: shared hit=98 read=2474 dirtied=32
74. 353.618 6,887.281 ↓ 22.8 727,137 1

Hash (cost=285,147.86..285,147.86 rows=31,871 width=61) (actual time=6,887.281..6,887.281 rows=727,137 loops=1)

  • Buckets: 1048576 (originally 32768) Batches: 1 (originally 1) Memory Usage: 74555kB
  • Buffers: shared hit=189535
75. 6,533.663 6,533.663 ↓ 22.8 727,137 1

Seq Scan on timeentrymetadata timeentrymetadata9 (cost=0.00..285,147.86 rows=31,871 width=61) (actual time=0.017..6,533.663 rows=727,137 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:COMMENTS'::text)
  • Rows Removed by Filter: 5657552
  • Buffers: shared hit=189535
76. 0.370 0.915 ↑ 1.0 994 1

Hash (cost=30.94..30.94 rows=994 width=18) (actual time=0.915..0.915 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
  • Buffers: shared hit=17 read=4
77. 0.545 0.545 ↑ 1.0 994 1

Seq Scan on userinfo userinfo10 (cost=0.00..30.94 rows=994 width=18) (actual time=0.007..0.545 rows=994 loops=1)

  • Buffers: shared hit=17 read=4
78. 0.154 1.113 ↑ 1.0 377 1

Hash (cost=10.77..10.77 rows=377 width=41) (actual time=1.113..1.113 rows=377 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared hit=3 read=4
79. 0.959 0.959 ↑ 1.0 377 1

Seq Scan on billingrate billingrate11 (cost=0.00..10.77 rows=377 width=41) (actual time=0.004..0.959 rows=377 loops=1)

  • Buffers: shared hit=3 read=4