explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oo9C

Settings
# exclusive inclusive rows x rows loops node
1. 56.457 14,545.628 ↑ 18.1 4,346 1

Sort (cost=743,544.46..743,741.30 rows=78,733 width=409) (actual time=14,543.521..14,545.628 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)) COLLATE "en_US", ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", ui.duplicatename, ((login.loginname)::character varying(255)) COLLATE "en_US", ((ui.externalid)::character varying(255)) COLLATE "en_US", ((ui.info5)::character varying(255)) COLLATE "en_US", ((dep.name)::character varying(255)) COLLATE "en_US", "*SELECT* 1".entrydate, ts.startdate, ts.enddate, tslist.timesheetstatus, ((tdh.hierarchysorting)::text) COLLATE "en_US", ((tdh.hierarchytaskname)::text) COLLATE "en_US", ((timeentrymetadata9.text)::text) COLLATE "en_US", ((userinfo10.displayname)::text) COLLATE "en_US", "*SELECT* 1".timeentryid, ((billingrate11.name)::character varying(50)) COLLATE "en_US
  • Sort Method: quicksort Memory: 2743kB
  • Buffers: shared hit=108465 read=252412, temp read=10409 written=10323
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. 5.322 14,489.168 ↑ 18.1 4,346 1

Hash Left Join (cost=273,664.97..722,339.12 rows=78,733 width=409) (actual time=13,311.636..14,489.168 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate11.id)
  • Buffers: shared hit=108465 read=252412, temp read=10409 written=10323
5. 4.130 14,483.493 ↑ 18.1 4,346 1

Hash Left Join (cost=273,652.49..721,244.06 rows=78,733 width=400) (actual time=13,311.272..14,483.493 rows=4,346 loops=1)

  • Hash Cond: (pj.projectleaderapproverid = userinfo10.id)
  • Buffers: shared hit=108461 read=252412, temp read=10409 written=10323
6. 4.505 14,478.258 ↑ 18.1 4,346 1

Hash Join (cost=273,612.12..720,123.10 rows=78,733 width=390) (actual time=13,310.143..14,478.258 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=108443 read=252412, temp read=10409 written=10323
7. 16.035 14,470.157 ↑ 18.1 4,346 1

Hash Left Join (cost=273,513.93..718,942.34 rows=78,733 width=372) (actual time=13,306.537..14,470.157 rows=4,346 loops=1)

  • Hash Cond: (tk.id = tdh.taskid)
  • Buffers: shared hit=108418 read=252412, temp read=10409 written=10323
8. 90.854 14,361.410 ↑ 18.1 4,346 1

Hash Left Join (cost=268,106.43..705,060.25 rows=78,733 width=312) (actual time=13,213.730..14,361.410 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata9.timeentryid)
  • Buffers: shared hit=105893 read=252412, temp read=9591 written=9511
9. 4.737 7,734.888 ↑ 18.1 4,346 1

Hash Join (cost=27,479.51..387,300.83 rows=78,733 width=268) (actual time=6,445.790..7,734.888 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=104238 read=126222, temp read=2338 written=2320
10. 4.191 7,728.996 ↑ 18.1 4,346 1

Hash Left Join (cost=27,439.15..386,177.88 rows=78,733 width=229) (actual time=6,444.628..7,728.996 rows=4,346 loops=1)

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=104220 read=126222, temp read=2338 written=2320
11. 4.501 7,724.770 ↑ 18.1 4,346 1

Hash Left Join (cost=27,436.71..384,503.05 rows=78,733 width=233) (actual time=6,444.586..7,724.770 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(clients17.id, pj.clientid) = cl.id)
  • Buffers: shared hit=104218 read=126222, temp read=2338 written=2320
12. 4.205 7,720.207 ↑ 18.1 4,346 1

Hash Left Join (cost=27,434.23..383,945.50 rows=78,733 width=225) (actual time=6,444.515..7,720.207 rows=4,346 loops=1)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata16.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:client:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata16.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:client:(.*)$'::text))::integer ELSE NULL::integer END = clients17.id)
  • Buffers: shared hit=104217 read=126222, temp read=2338 written=2320
13. 4.098 7,715.937 ↑ 18.1 4,346 1

Nested Loop Left Join (cost=27,431.74..382,895.86 rows=78,733 width=278) (actual time=6,444.429..7,715.937 rows=4,346 loops=1)

  • Join Filter: ("*SELECT* 1".timeentryid = timeentrymetadata16.timeentryid)
  • Buffers: shared hit=104216 read=126222, temp read=2338 written=2320
14. 15.555 1,853.431 ↑ 18.1 4,346 1

Hash Left Join (cost=27,431.74..158,044.35 rows=78,733 width=221) (actual time=588.883..1,853.431 rows=4,346 loops=1)

  • Hash Cond: (task15.id = tk.id)
  • Buffers: shared hit=102593, temp read=2338 written=2320
15. 233.890 1,739.802 ↑ 18.1 4,346 1

Hash Join (cost=23,043.24..147,880.27 rows=78,733 width=176) (actual time=490.698..1,739.802 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ts.userid)
  • Join Filter: (("*SELECT* 1".entrydate >= ts.startdate) AND ("*SELECT* 1".entrydate <= ts.enddate))
  • Rows Removed by Join Filter: 1342193
  • Buffers: shared hit=101002, temp read=1650 written=1638
16. 6.202 1,022.063 ↑ 1.1 4,346 1

Hash Left Join (cost=392.35..110,403.37 rows=4,708 width=160) (actual time=6.641..1,022.063 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(project13.id, task15.projectid) = pj.id)
  • Buffers: shared hit=91240
17. 463.997 1,012.544 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=227.98..110,174.26 rows=4,708 width=84) (actual time=3.315..1,012.544 rows=4,346 loops=1)

  • Buffers: shared hit=91138
18. 96.620 535.509 ↑ 1.1 4,346 1

Hash Left Join (cost=227.68..108,399.43 rows=4,708 width=133) (actual time=3.189..535.509 rows=4,346 loops=1)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata12.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata12.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:project:(.*)$'::text))::integer ELSE NULL::integer END = project13.id)
  • Buffers: shared hit=78579
19. 5.588 436.340 ↑ 1.1 4,346 1

Nested Loop Left Join (cost=63.31..108,140.90 rows=4,708 width=186) (actual time=0.369..436.340 rows=4,346 loops=1)

  • Buffers: shared hit=78477
20. 6.806 409.022 ↓ 1.2 4,346 1

Nested Loop Left Join (cost=62.75..77,926.11 rows=3,569 width=129) (actual time=0.363..409.022 rows=4,346 loops=1)

  • Buffers: shared hit=60636
21. 3.594 376.140 ↓ 1.6 4,346 1

Append (cost=62.19..54,255.46 rows=2,796 width=72) (actual time=0.355..376.140 rows=4,346 loops=1)

  • Buffers: shared hit=38985
22. 3.974 372.539 ↓ 1.6 4,346 1

Subquery Scan on *SELECT* 1 (cost=62.19..54,253.42 rows=2,795 width=72) (actual time=0.354..372.539 rows=4,346 loops=1)

  • Buffers: shared hit=38984
23. 297.066 368.565 ↓ 1.6 4,346 1

Nested Loop Left Join (cost=62.19..54,225.47 rows=2,795 width=235) (actual time=0.353..368.565 rows=4,346 loops=1)

  • Buffers: shared hit=38984
24. 7.274 49.769 ↓ 1.6 4,346 1

Nested Loop Left Join (cost=61.63..30,423.75 rows=2,795 width=178) (actual time=0.345..49.769 rows=4,346 loops=1)

  • Buffers: shared hit=21555
25. 3.957 7.727 ↓ 1.6 4,346 1

Nested Loop (cost=61.08..6,761.69 rows=2,795 width=121) (actual time=0.330..7.727 rows=4,346 loops=1)

  • Buffers: shared hit=84
26. 0.005 0.011 ↑ 1.0 1 1

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

  • Buffers: shared hit=2
27. 0.003 0.003 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
28. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on projectsysteminformation psi (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
29. 3.451 3.759 ↓ 1.6 4,346 1

Bitmap Heap Scan on timeentry te (cost=61.08..6,731.71 rows=2,795 width=56) (actual time=0.320..3.759 rows=4,346 loops=1)

  • Recheck Cond: ((entrydate >= '2019-03-30'::date) AND (entrydate <= '2019-04-05'::date))
  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
  • Heap Blocks: exact=67
  • Buffers: shared hit=82
30. 0.308 0.308 ↓ 1.6 4,346 1

Bitmap Index Scan on ixte2entrydate (cost=0.00..60.38 rows=2,795 width=0) (actual time=0.308..0.308 rows=4,346 loops=1)

  • Index Cond: ((entrydate >= '2019-03-30'::date) AND (entrydate <= '2019-04-05'::date))
  • Buffers: shared hit=15
31. 34.768 34.768 ↑ 1.0 1 4,346

Index Scan using ixtem2timeentryid on timeentrymetadata tembillingrate (cost=0.56..8.46 rows=1 width=73) (actual time=0.007..0.008 rows=1 loops=4,346)

  • Index Cond: ((timeentryid = te.id) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text))
  • Buffers: shared hit=21471
32. 21.730 21.730 ↓ 0.0 0 4,346

Index Scan using ixtem2timeentryid on timeentrymetadata temdbreaktype (cost=0.56..8.46 rows=1 width=73) (actual time=0.005..0.005 rows=0 loops=4,346)

  • Index Cond: ((timeentryid = te.id) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text))
  • Buffers: shared hit=17429
33. 0.000 0.007 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..2.05 rows=1 width=72) (actual time=0.007..0.007 rows=0 loops=1)

  • Buffers: shared hit=1
34. 0.002 0.007 ↓ 0.0 0 1

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

  • Join Filter: (toe.timeoffid = toff.id)
  • Buffers: shared hit=1
35. 0.005 0.005 ↓ 0.0 0 1

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

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

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

37. 26.076 26.076 ↑ 1.0 1 4,346

Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata14 (cost=0.56..8.46 rows=1 width=73) (actual time=0.005..0.006 rows=1 loops=4,346)

  • Index Cond: (("*SELECT* 1".timeentryid = timeentryid) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text))
  • Buffers: shared hit=21651
38. 21.730 21.730 ↓ 0.0 0 4,346

Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata12 (cost=0.56..8.46 rows=1 width=73) (actual time=0.005..0.005 rows=0 loops=4,346)

  • Index Cond: (("*SELECT* 1".timeentryid = timeentryid) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text))
  • Buffers: shared hit=17841
39. 1.233 2.549 ↑ 1.0 2,772 1

Hash (cost=129.72..129.72 rows=2,772 width=4) (actual time=2.549..2.549 rows=2,772 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=102
40. 1.316 1.316 ↑ 1.0 2,772 1

Seq Scan on project project13 (cost=0.00..129.72 rows=2,772 width=4) (actual time=0.003..1.316 rows=2,772 loops=1)

  • Buffers: shared hit=102
41. 13.038 13.038 ↑ 1.0 1 4,346

Index Scan using task_pkey on task task15 (cost=0.30..0.37 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=4,346)

  • Index Cond: (CASE WHEN ("substring"(timeentrymetadata14.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata14.uri, '^urn:replicon-tenant:d39c603ba5ee46da9a42069eec872cf2:task:(.*)$'::text))::integer ELSE NULL::integer END = id)
  • Buffers: shared hit=12559
42. 1.497 3.317 ↑ 1.0 2,772 1

Hash (cost=129.72..129.72 rows=2,772 width=84) (actual time=3.317..3.317 rows=2,772 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 361kB
  • Buffers: shared hit=102
43. 1.820 1.820 ↑ 1.0 2,772 1

Seq Scan on project pj (cost=0.00..129.72 rows=2,772 width=84) (actual time=0.002..1.820 rows=2,772 loops=1)

  • Buffers: shared hit=102
44. 68.964 483.849 ↓ 1.0 135,256 1

Hash (cost=20,303.30..20,303.30 rows=135,007 width=16) (actual time=483.849..483.849 rows=135,256 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2387kB
  • Buffers: shared hit=9762, temp read=1101 written=1560
45. 166.404 414.885 ↓ 1.0 135,256 1

Hash Join (cost=5,368.07..20,303.30 rows=135,007 width=16) (actual time=133.437..414.885 rows=135,256 loops=1)

  • Hash Cond: (tslist.timesheetid = ts.id)
  • Buffers: shared hit=9762, temp read=1101 written=1095
46. 115.155 115.155 ↓ 1.0 135,256 1

Seq Scan on dm_timesheetlist_facts tslist (cost=0.00..10,568.33 rows=135,154 width=20) (actual time=0.005..115.155 rows=135,256 loops=1)

  • Filter: (timesheetstatus = ANY ('{0,1,2,3,4}'::integer[]))
  • Buffers: shared hit=8366
47. 71.499 133.326 ↑ 1.0 135,256 1

Hash (cost=2,749.81..2,749.81 rows=135,381 width=28) (actual time=133.326..133.326 rows=135,256 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2487kB
  • Buffers: shared hit=1396, temp written=594
48. 61.827 61.827 ↑ 1.0 135,256 1

Seq Scan on timesheet ts (cost=0.00..2,749.81 rows=135,381 width=28) (actual time=0.005..61.827 rows=135,256 loops=1)

  • Buffers: shared hit=1396
49. 49.217 98.074 ↑ 1.0 86,689 1

Hash (cost=2,457.89..2,457.89 rows=86,689 width=49) (actual time=98.074..98.074 rows=86,689 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2391kB
  • Buffers: shared hit=1591, temp written=604
50. 48.857 48.857 ↑ 1.0 86,689 1

Seq Scan on task tk (cost=0.00..2,457.89 rows=86,689 width=49) (actual time=0.010..48.857 rows=86,689 loops=1)

  • Buffers: shared hit=1591
51. 2.869 5,858.408 ↓ 0.0 0 4,346

Materialize (cost=0.00..223,670.52 rows=1 width=73) (actual time=1.348..1.348 rows=0 loops=4,346)

  • Buffers: shared hit=1623 read=126222
52. 5,855.539 5,855.539 ↓ 0.0 0 1

Seq Scan on timeentrymetadata timeentrymetadata16 (cost=0.00..223,670.52 rows=1 width=73) (actual time=5,855.539..5,855.539 rows=0 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:CLIENT'::text)
  • Rows Removed by Filter: 6384855
  • Buffers: shared hit=1623 read=126222
53. 0.033 0.065 ↑ 1.0 66 1

Hash (cost=1.66..1.66 rows=66 width=4) (actual time=0.065..0.065 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
54. 0.032 0.032 ↑ 1.0 66 1

Seq Scan on clients clients17 (cost=0.00..1.66 rows=66 width=4) (actual time=0.006..0.032 rows=66 loops=1)

  • Buffers: shared hit=1
55. 0.032 0.062 ↑ 1.0 66 1

Hash (cost=1.66..1.66 rows=66 width=16) (actual time=0.062..0.062 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1
56. 0.030 0.030 ↑ 1.0 66 1

Seq Scan on clients cl (cost=0.00..1.66 rows=66 width=16) (actual time=0.002..0.030 rows=66 loops=1)

  • Buffers: shared hit=1
57. 0.009 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
58. 0.026 0.026 ↑ 1.0 7 1

Seq Scan on exchangerate (cost=0.00..2.35 rows=7 width=4) (actual time=0.019..0.026 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
59. 0.533 1.155 ↑ 1.0 994 1

Hash (cost=27.94..27.94 rows=994 width=39) (actual time=1.155..1.155 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=18
60. 0.622 0.622 ↑ 1.0 994 1

Seq Scan on userinfo ui (cost=0.00..27.94 rows=994 width=39) (actual time=0.004..0.622 rows=994 loops=1)

  • Buffers: shared hit=18
61. 419.797 6,535.668 ↑ 1.0 727,165 1

Hash (cost=223,670.52..223,670.52 rows=729,552 width=60) (actual time=6,535.668..6,535.668 rows=727,165 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2593kB
  • Buffers: shared hit=1655 read=126190, temp written=6985
62. 6,115.871 6,115.871 ↑ 1.0 727,165 1

Seq Scan on timeentrymetadata timeentrymetadata9 (cost=0.00..223,670.52 rows=729,552 width=60) (actual time=1,405.417..6,115.871 rows=727,165 loops=1)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:COMMENTS'::text)
  • Rows Removed by Filter: 5657690
  • Buffers: shared hit=1655 read=126190
63. 48.984 92.712 ↑ 1.0 86,689 1

Hash (cost=3,391.89..3,391.89 rows=86,689 width=64) (actual time=92.712..92.712 rows=86,689 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2584kB
  • Buffers: shared hit=2525, temp written=678
64. 43.728 43.728 ↑ 1.0 86,689 1

Seq Scan on taskdenormalizedhierarchy tdh (cost=0.00..3,391.89 rows=86,689 width=64) (actual time=0.006..43.728 rows=86,689 loops=1)

  • Buffers: shared hit=2525
65. 0.497 3.596 ↑ 1.0 994 1

Hash (cost=85.76..85.76 rows=994 width=30) (actual time=3.596..3.596 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
  • Buffers: shared hit=25
66. 0.842 3.099 ↑ 1.0 994 1

Hash Join (cost=30.49..85.76 rows=994 width=30) (actual time=0.944..3.099 rows=994 loops=1)

  • Hash Cond: (du.departmentid = dep.id)
  • Buffers: shared hit=25
67. 0.906 2.203 ↑ 1.0 994 1

Hash Join (cost=28.37..69.97 rows=994 width=20) (actual time=0.885..2.203 rows=994 loops=1)

  • Hash Cond: (login.userid = du.userid)
  • Buffers: shared hit=24
68. 0.423 0.423 ↑ 1.0 994 1

Seq Scan on login (cost=0.00..27.94 rows=994 width=12) (actual time=0.003..0.423 rows=994 loops=1)

  • Buffers: shared hit=18
69. 0.447 0.874 ↑ 1.0 994 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 47kB
  • Buffers: shared hit=6
70. 0.427 0.427 ↑ 1.0 994 1

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

  • Buffers: shared hit=6
71. 0.020 0.054 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
73. 0.488 1.105 ↑ 1.0 994 1

Hash (cost=27.94..27.94 rows=994 width=18) (actual time=1.105..1.105 rows=994 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
  • Buffers: shared hit=18
74. 0.617 0.617 ↑ 1.0 994 1

Seq Scan on userinfo userinfo10 (cost=0.00..27.94 rows=994 width=18) (actual time=0.006..0.617 rows=994 loops=1)

  • Buffers: shared hit=18
75. 0.200 0.353 ↑ 1.0 377 1

Hash (cost=7.77..7.77 rows=377 width=41) (actual time=0.353..0.353 rows=377 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared hit=4
76. 0.153 0.153 ↑ 1.0 377 1

Seq Scan on billingrate billingrate11 (cost=0.00..7.77 rows=377 width=41) (actual time=0.005..0.153 rows=377 loops=1)

  • Buffers: shared hit=4