explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ND8 : Solaris

Settings
# exclusive inclusive rows x rows loops node
1. 75.211 559,447.272 ↑ 564.4 4,346 1

Sort (cost=3,102,952.73..3,109,084.90 rows=2,452,866 width=410) (actual time=559,444.898..559,447.272 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=105143 read=788128 written=1297
2.          

Initplan (forSort)

3. 0.498 0.498 ↑ 1.0 1 1

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

  • Buffers: shared read=1
4. 14.087 559,371.563 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,784.16..2,579,136.60 rows=2,452,866 width=410) (actual time=555,374.467..559,371.563 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate11.id)
  • Buffers: shared hit=105128 read=788125 written=1297
5. 6.227 559,354.965 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,768.68..2,545,394.21 rows=2,452,866 width=401) (actual time=555,371.931..559,354.965 rows=4,346 loops=1)

  • Hash Cond: (pj.projectleaderapproverid = userinfo10.id)
  • Buffers: shared hit=105128 read=788118 written=1297
6. 8.048 559,346.619 ↑ 564.4 4,346 1

Hash Left Join (cost=1,450,725.31..2,511,686.08 rows=2,452,866 width=391) (actual time=555,369.785..559,346.619 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata9.timeentryid)
  • Buffers: shared hit=105127 read=788098 written=1297
7. 12.187 552,339.228 ↑ 564.4 4,346 1

Hash Left Join (cost=1,165,179.06..1,894,454.43 rows=2,452,866 width=346) (actual time=548,370.234..552,339.228 rows=4,346 loops=1)

  • Hash Cond: (tk.id = tdh.taskid)
  • Buffers: shared hit=105058 read=598632 written=1297
8. 7.160 552,193.419 ↑ 564.4 4,346 1

Hash Join (cost=1,160,635.66..1,856,184.12 rows=2,452,866 width=286) (actual time=548,235.987..552,193.419 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=105058 read=596060 written=1297
9. 11.293 552,181.452 ↑ 564.4 4,346 1

Hash Join (cost=1,160,536.47..1,822,358.02 rows=2,452,866 width=268) (actual time=548,231.160..552,181.452 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=105054 read=596038 written=1297
10. 10.170 552,167.841 ↑ 564.4 4,346 1

Hash Left Join (cost=1,160,493.10..1,788,587.75 rows=2,452,866 width=229) (actual time=548,228.821..552,167.841 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(clients17.id, pj.clientid) = cl.id)
  • Buffers: shared hit=105053 read=596018 written=1296
11. 5.674 552,156.305 ↑ 564.4 4,346 1

Hash Left Join (cost=1,160,482.62..1,771,284.56 rows=2,452,866 width=221) (actual time=548,227.406..552,156.305 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata16.timeentryid)
  • Buffers: shared hit=105053 read=596009 written=1296
12. 7.899 540,522.712 ↑ 564.4 4,346 1

Hash Left Join (cost=874,588.20..1,153,704.76 rows=2,452,866 width=217) (actual time=536,599.321..540,522.712 rows=4,346 loops=1)

  • Hash Cond: (task15.id = tk.id)
  • Buffers: shared hit=105016 read=406511 written=1296
13. 8.679 540,288.496 ↑ 564.4 4,346 1

Hash Join (cost=869,196.06..1,114,585.70 rows=2,452,866 width=176) (actual time=536,372.830..540,288.496 rows=4,346 loops=1)

  • Hash Cond: (ts.id = tslist.timesheetid)
  • Buffers: shared hit=105016 read=404913 written=1296
14. 22.421 539,846.912 ↑ 565.8 4,346 1

Nested Loop (cost=853,000.40..1,064,640.77 rows=2,458,830 width=188) (actual time=535,938.777..539,846.912 rows=4,346 loops=1)

  • Buffers: shared hit=105014 read=392733 written=53
15. 16.132 539,602.845 ↑ 35.4 4,346 1

Hash Left Join (cost=852,999.98..856,655.25 rows=153,778 width=160) (actual time=535,935.336..539,602.845 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(project13.id, task15.projectid) = pj.id)
  • Buffers: shared hit=81543 read=392328 written=53
16. 815.495 539,577.344 ↑ 35.4 4,346 1

Merge Left Join (cost=852,782.69..854,323.52 rows=153,778 width=84) (actual time=535,925.921..539,577.344 rows=4,346 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata12.timeentryid)
  • Buffers: shared hit=81543 read=392193 written=53
17. 789.606 295,837.538 ↑ 35.4 4,346 1

Merge Left Join (cost=564,542.29..565,504.93 rows=153,778 width=80) (actual time=294,024.668..295,837.538 rows=4,346 loops=1)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata14.timeentryid)
  • Buffers: shared hit=80583 read=202558 written=53
18. 11.144 7,250.211 ↑ 35.4 4,346 1

Sort (cost=272,905.59..273,290.03 rows=153,778 width=72) (actual time=7,247.389..7,250.211 rows=4,346 loops=1)

  • Sort Key: "*SELECT* 1".timeentryid
  • Sort Method: quicksort Memory: 775kB
  • Buffers: shared hit=80567 read=11443 written=53
19. 3.456 7,239.067 ↑ 35.4 4,346 1

Append (cost=2.14..259,657.24 rows=153,778 width=72) (actual time=15.336..7,239.067 rows=4,346 loops=1)

  • Buffers: shared hit=80567 read=11443 written=53
20. 4.408 7,231.851 ↑ 35.4 4,346 1

Subquery Scan on *SELECT* 1 (cost=2.14..259,651.70 rows=153,762 width=72) (actual time=15.332..7,231.851 rows=4,346 loops=1)

  • Buffers: shared hit=80567 read=11442 written=53
21. 484.018 7,227.443 ↑ 35.4 4,346 1

Nested Loop Left Join (cost=2.14..258,114.08 rows=153,762 width=235) (actual time=15.330..7,227.443 rows=4,346 loops=1)

  • Buffers: shared hit=80567 read=11442 written=53
22. 250.354 5,848.149 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=1.29..71,758.65 rows=4,622 width=235) (actual time=3.756..5,848.149 rows=4,346 loops=1)

  • Buffers: shared hit=35529 read=10392 written=49
  • -> Index Scan using ixtemtimeentryid on timeentrymetadata temdbreaktype (cost=0.43..5.28 rows=1 width=73) (actual time=0.056..0.056 rows=0 (...)
23. 5,389.597 5,597.795 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=0.86..47,328.55 rows=4,622 width=178) (actual time=3.735..5,597.795 rows=4,346 loops=1)

  • Buffers: shared hit=16786 read=9902 written=49
  • -> Index Scan using ixtemtimeentryid on timeentrymetadata tembillingrate (cost=0.43..5.27 rows=1 width=73) (actual time=1.236..1.238 (...)
  • 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=18743 read=490
24. 203.852 208.198 ↑ 1.1 4,346 1

Nested Loop (cost=0.43..22,944.67 rows=4,622 width=121) (actual time=2.375..208.198 rows=4,346 loops=1)

  • Buffers: shared hit=3177 read=4278 written=26
  • -> Index Scan using ixte2userid on timeentry te (cost=0.43..22884.86 rows=4622 width=56) (actual time=1.442..194.898 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=3177 read=4276 written=26
  • Index Cond: (timeentryid = te.id)
  • Filter: (key = 'urn:replicon:time-entry-metadata-key:billing-rate'::text)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=13609 read=5624 written=23
25. 3.420 4.346 ↑ 1.0 1 4,346

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

  • Buffers: shared read=2
26. 0.453 0.926 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.03 rows=1 width=65) (actual time=0.923..0.926 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.446..0.447 rows=1 loo (...)
27. 0.473 0.473 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=45038 read=1050 written=4
  • -> Index Scan using ixtsuseridstartdateenddate on timesheet ts_1 (cost=0.42..1.60 rows=16 width=28) (actual time=0.023..0.024 rows=1 loops (...)
  • Index Cond: ((userid = te.userid) AND (te.entrydate >= startdate) AND (te.entrydate <= enddate))
  • Buffers: shared hit=23472 read=404 written=3
  • -> Index Scan using ixtpsstimesheetid on timesheetpolicysettingssnapshot tspolicy (cost=0.43..2.30 rows=1 width=16) (actual time=0.155..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=21566 read=646 written=1
29. 0.002 3.760 ↓ 0.0 0 1

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

  • Buffers: shared read=1
30. 0.001 3.758 ↓ 0.0 0 1

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

  • Buffers: shared read=1
31. 0.001 3.757 ↓ 0.0 0 1

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

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

Seq Scan on timeoffentries toe (cost=0.00..1.01 rows=1 width=24) (actual time=3.756..3.756 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. 3,440.527 287,797.721 ↓ 44.7 1,425,797 1

Sort (cost=291,636.71..291,716.38 rows=31,871 width=24) (actual time=286,777.198..287,797.721 rows=1,425,797 loops=1)

  • Sort Key: timeentrymetadata14.timeentryid
  • Sort Method: quicksort Memory: 160573kB
  • Buffers: shared hit=16 read=191115
36. 267,061.974 284,357.194 ↓ 44.7 1,426,182 1

Hash Left Join (cost=3,547.16..289,252.76 rows=31,871 width=24) (actual time=7,011.250..284,357.194 rows=1,426,182 loops=1)

  • Hash Cond: (("substring"(timeentrymetadata14.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:task:(.*)$'::text))::integer = task15.id)
  • Buffers: shared hit=16 read=191115
37. 17,112.645 17,112.645 ↓ 44.7 1,426,182 1

Seq Scan on timeentrymetadata timeentrymetadata14 (cost=0.00..285,147.86 rows=31,871 width=73) (actual time=6,827.551..17,112.645 rows=1,426,182 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
  • Rows Removed by Filter: 4958423
  • Buffers: shared hit=14 read=189521
38. 46.310 182.575 ↑ 1.0 86,689 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 4411kB
  • Buffers: shared hit=2 read=1594
39. 136.265 136.265 ↑ 1.0 86,689 1

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

  • Buffers: shared hit=2 read=1594
40. 3,641.185 242,924.311 ↓ 45.7 1,455,928 1

Sort (cost=288,240.40..288,320.08 rows=31,871 width=20) (actual time=241,901.130..242,924.311 rows=1,455,928 loops=1)

  • Sort Key: timeentrymetadata12.timeentryid
  • Sort Method: quicksort Memory: 162928kB
  • Buffers: shared hit=960 read=189635
41. 223,072.040 239,283.126 ↓ 45.7 1,456,320 1

Hash Left Join (cost=150.85..285,856.45 rows=31,871 width=20) (actual time=7,114.273..239,283.126 rows=1,456,320 loops=1)

  • Hash Cond: (("substring"(timeentrymetadata12.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:project:(.*)$'::text))::integer = project13.id)
  • Buffers: shared hit=960 read=189635
42. 16,019.416 16,019.416 ↓ 45.7 1,456,320 1

Seq Scan on timeentrymetadata timeentrymetadata12 (cost=0.00..285,147.86 rows=31,871 width=73) (actual time=6,921.909..16,019.416 rows=1,456,320 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text)
  • Rows Removed by Filter: 4928285
  • Buffers: shared read=189535
43. 1.506 191.670 ↑ 1.3 2,772 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=960 read=100
44. 190.164 190.164 ↑ 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=23.158..190.164 rows=2,772 loops=1)

  • Heap Fetches: 1892
  • Buffers: shared hit=960 read=100
45. 2.070 9.369 ↑ 1.3 2,772 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 361kB
  • Buffers: shared read=135
46. 7.299 7.299 ↑ 1.3 2,772 1

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

  • Buffers: shared read=135
47. 221.646 221.646 ↑ 16.0 1 4,346

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

  • Index Cond: ((userid = "*SELECT* 1".userid) AND ("*SELECT* 1".entrydate >= startdate) AND ("*SELECT* 1".entrydate <= enddate))
  • Buffers: shared hit=23471 read=405
48. 61.344 432.905 ↑ 1.0 134,993 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 8904kB
  • Buffers: shared hit=2 read=12180 written=1243
49. 371.561 371.561 ↑ 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.491..371.561 rows=134,993 loops=1)

  • Filter: (timesheetstatus = ANY ('{0,1,2,3,4}'::integer[]))
  • Buffers: shared hit=2 read=12180 written=1243
50. 62.662 226.317 ↑ 1.0 86,689 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 8173kB
  • Buffers: shared read=1598
51. 105.836 163.655 ↑ 1.0 86,689 1

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

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared read=1598
52. 56.717 56.717 ↑ 1.0 86,689 1

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

  • Buffers: shared read=1596
53. 0.009 1.102 ↑ 1.0 7 1

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

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

Seq Scan on exchangerate (cost=0.00..2.35 rows=7 width=4) (actual time=1.073..1.093 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
55. 0.002 11,627.919 ↓ 0.0 0 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 256kB
  • Buffers: shared hit=37 read=189498
56. 0.002 11,627.917 ↓ 0.0 0 1

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

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

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

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:CLIENT'::text)
  • Rows Removed by Filter: 6384605
  • Buffers: shared hit=37 read=189498
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.050 1.366 ↑ 1.0 66 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared read=9
61. 1.316 1.316 ↑ 1.0 66 1

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

  • Buffers: shared read=9
62. 0.736 2.318 ↑ 1.0 994 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=1 read=20 written=1
63. 1.582 1.582 ↑ 1.0 994 1

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

  • Buffers: shared hit=1 read=20 written=1
64. 0.656 4.807 ↑ 1.0 994 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
  • Buffers: shared hit=4 read=22
65. 1.010 4.151 ↑ 1.0 994 1

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

  • Hash Cond: (du.departmentid = dep.id)
  • Buffers: shared hit=4 read=22
66. 0.999 3.080 ↑ 1.0 994 1

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

  • Hash Cond: (login.userid = du.userid)
  • Buffers: shared hit=3 read=22
67. 1.034 1.034 ↑ 1.0 994 1

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

  • Buffers: shared hit=1 read=18
68. 0.521 1.047 ↑ 1.0 994 1

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

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

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

  • Buffers: shared hit=2 read=4
70. 0.036 0.061 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
72. 57.926 133.622 ↑ 1.0 86,689 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 9293kB
  • Buffers: shared read=2572
73. 75.696 75.696 ↑ 1.0 86,689 1

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

  • Buffers: shared read=2572
74. 319.946 6,999.343 ↓ 22.8 727,126 1

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

  • Buckets: 1048576 (originally 32768) Batches: 1 (originally 1) Memory Usage: 74554kB
  • Buffers: shared hit=69 read=189466
75. 6,679.397 6,679.397 ↓ 22.8 727,126 1

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

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:COMMENTS'::text)
  • Rows Removed by Filter: 5657479
  • Buffers: shared hit=69 read=189466
76. 0.332 2.119 ↑ 1.0 994 1

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

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

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

  • Buffers: shared hit=1 read=20
78. 0.136 2.511 ↑ 1.0 377 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared read=7
79. 2.375 2.375 ↑ 1.0 377 1

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

  • Buffers: shared read=7
Planning time : 200.033 ms
Execution time : 559,606.383 ms