explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9O4j : same query on local devvm

Settings
# exclusive inclusive rows x rows loops node
1. 31.205 15,404.121 ↑ 11.9 4,346 1

Sort (cost=654,198.72..654,328.19 rows=51,788 width=407) (actual time=15,401.882..15,404.121 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=106498 read=254342, temp read=9965 written=9879
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.261 15,372.913 ↑ 11.9 4,346 1

Hash Left Join (cost=268,755.19..640,580.62 rows=51,788 width=407) (actual time=14,168.284..15,372.913 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate11.id)
  • Buffers: shared hit=106498 read=254342, temp read=9965 written=9879
5. 4.233 15,367.265 ↑ 11.9 4,346 1

Hash Left Join (cost=268,742.71..639,856.05 rows=51,788 width=398) (actual time=14,167.873..15,367.265 rows=4,346 loops=1)

  • Hash Cond: (pj.projectleaderapproverid = userinfo10.id)
  • Buffers: shared hit=106494 read=254342, temp read=9965 written=9879
6. 4.536 15,361.856 ↑ 11.9 4,346 1

Hash Join (cost=268,702.35..639,104.91 rows=51,788 width=388) (actual time=14,166.671..15,361.856 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=106476 read=254342, temp read=9965 written=9879
7. 16.365 15,353.586 ↑ 11.9 4,346 1

Hash Left Join (cost=268,604.16..638,294.64 rows=51,788 width=370) (actual time=14,162.919..15,353.586 rows=4,346 loops=1)

  • Hash Cond: (tk.id = tdh.taskid)
  • Buffers: shared hit=106451 read=254342, temp read=9965 written=9879
8. 91.353 15,241.166 ↑ 11.9 4,346 1

Hash Left Join (cost=263,196.65..626,993.05 rows=51,788 width=311) (actual time=14,066.593..15,241.166 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata9.timeentryid)
  • Buffers: shared hit=103926 read=254342, temp read=9147 written=9067
9. 4.634 8,112.366 ↑ 11.9 4,346 1

Hash Join (cost=23,155.44..333,833.99 rows=51,788 width=268) (actual time=6,839.640..8,112.366 rows=4,346 loops=1)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=103236 read=127187, temp read=1894 written=1876
10. 4.074 8,106.529 ↑ 11.9 4,346 1

Hash Left Join (cost=23,115.08..333,081.54 rows=51,788 width=229) (actual time=6,838.419..8,106.529 rows=4,346 loops=1)

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=103218 read=127187, temp read=1894 written=1876
11. 4.440 8,102.411 ↑ 11.9 4,346 1

Hash Left Join (cost=23,112.64..331,979.11 rows=51,788 width=233) (actual time=6,838.364..8,102.411 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(clients17.id, pj.clientid) = cl.id)
  • Buffers: shared hit=103216 read=127187, temp read=1894 written=1876
12. 4.046 8,097.893 ↑ 11.9 4,346 1

Hash Left Join (cost=23,110.16..331,611.52 rows=51,788 width=225) (actual time=6,838.259..8,097.893 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=103215 read=127187, temp read=1894 written=1876
13. 6.722 8,093.781 ↑ 11.9 4,346 1

Nested Loop Left Join (cost=23,107.67..330,920.25 rows=51,788 width=278) (actual time=6,838.173..8,093.781 rows=4,346 loops=1)

  • Join Filter: ("*SELECT* 1".timeentryid = timeentrymetadata16.timeentryid)
  • Buffers: shared hit=103214 read=127187, temp read=1894 written=1876
14. 15.169 1,750.591 ↑ 11.9 4,346 1

Hash Left Join (cost=23,107.67..106,525.61 rows=51,788 width=221) (actual time=501.868..1,750.591 rows=4,346 loops=1)

  • Hash Cond: (task15.id = tk.id)
  • Buffers: shared hit=102556, temp read=1894 written=1876
15. 4.684 1,627.575 ↑ 11.9 4,346 1

Hash Left Join (cost=18,719.17..98,048.02 rows=51,788 width=176) (actual time=338.521..1,627.575 rows=4,346 loops=1)

  • Hash Cond: (COALESCE(project13.id, task15.projectid) = pj.id)
  • Buffers: shared hit=100965, temp read=1206 written=1194
16. 16.605 1,619.433 ↑ 11.9 4,346 1

Hash Join (cost=18,554.80..97,171.56 rows=51,788 width=100) (actual time=335.046..1,619.433 rows=4,346 loops=1)

  • Hash Cond: (ts.id = tslist.timesheetid)
  • Buffers: shared hit=100863, temp read=1206 written=1194
17. 242.128 1,415.580 ↑ 11.9 4,346 1

Hash Join (cost=5,556.01..80,947.20 rows=51,919 width=112) (actual time=144.814..1,415.580 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: 1338224
  • Buffers: shared hit=92530, temp read=647 written=641
18. 468.669 1,038.094 ↓ 1.4 4,346 1

Nested Loop Left Join (cost=203.67..65,253.28 rows=3,098 width=84) (actual time=3.531..1,038.094 rows=4,346 loops=1)

  • Buffers: shared hit=91138
19. 98.426 552.041 ↓ 1.4 4,346 1

Hash Left Join (cost=203.37..64,085.47 rows=3,098 width=133) (actual time=3.401..552.041 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
20. 6.404 450.927 ↓ 1.4 4,346 1

Nested Loop Left Join (cost=39.00..63,859.14 rows=3,098 width=186) (actual time=0.398..450.927 rows=4,346 loops=1)

  • Buffers: shared hit=78477
21. 8.776 422.793 ↓ 2.0 4,346 1

Nested Loop Left Join (cost=38.44..45,345.64 rows=2,173 width=129) (actual time=0.392..422.793 rows=4,346 loops=1)

  • Buffers: shared hit=60636
22. 3.722 387.941 ↓ 2.7 4,346 1

Append (cost=37.88..31,756.57 rows=1,595 width=72) (actual time=0.382..387.941 rows=4,346 loops=1)

  • Buffers: shared hit=38985
23. 4.144 384.210 ↓ 2.7 4,346 1

Subquery Scan on *SELECT* 1 (cost=37.88..31,754.53 rows=1,594 width=72) (actual time=0.382..384.210 rows=4,346 loops=1)

  • Buffers: shared hit=38984
24. 304.280 380.066 ↓ 2.7 4,346 1

Nested Loop Left Join (cost=37.88..31,738.59 rows=1,594 width=235) (actual time=0.380..380.066 rows=4,346 loops=1)

  • Buffers: shared hit=38984
25. 7.099 54.056 ↓ 2.7 4,346 1

Nested Loop Left Join (cost=37.32..18,078.46 rows=1,594 width=178) (actual time=0.372..54.056 rows=4,346 loops=1)

  • Buffers: shared hit=21555
26. 4.125 7.843 ↓ 2.7 4,346 1

Nested Loop (cost=36.77..4,497.98 rows=1,594 width=121) (actual time=0.350..7.843 rows=4,346 loops=1)

  • Buffers: shared hit=84
27. 0.007 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
28. 0.001 0.001 ↑ 1.0 1 1

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

  • Buffers: shared hit=1
29. 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.002..0.003 rows=1 loops=1)

  • Buffers: shared hit=1
30. 3.381 3.707 ↓ 2.7 4,346 1

Bitmap Heap Scan on timeentry te (cost=36.77..4,480.01 rows=1,594 width=56) (actual time=0.341..3.707 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
31. 0.326 0.326 ↓ 2.7 4,346 1

Bitmap Index Scan on ixtemp_teentrydate (cost=0.00..36.37 rows=1,594 width=0) (actual time=0.326..0.326 rows=4,346 loops=1)

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

Index Scan using istemp_temdkey2 on timeentrymetadata tembillingrate (cost=0.56..8.51 rows=1 width=73) (actual time=0.008..0.009 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
33. 21.730 21.730 ↓ 0.0 0 4,346

Index Scan using istemp_temdkey2 on timeentrymetadata temdbreaktype (cost=0.56..8.51 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
34. 0.001 0.009 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
35. 0.001 0.008 ↓ 0.0 0 1

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

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

Seq Scan on timeoffentries toe (cost=0.00..1.01 rows=1 width=24) (actual time=0.007..0.007 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
37. 0.000 0.000 ↓ 0.0 0

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

38. 26.076 26.076 ↑ 1.0 1 4,346

Index Scan using istemp_temdkey2 on timeentrymetadata timeentrymetadata14 (cost=0.56..8.51 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
39. 21.730 21.730 ↓ 0.0 0 4,346

Index Scan using istemp_temdkey2 on timeentrymetadata timeentrymetadata12 (cost=0.56..8.51 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
40. 1.288 2.688 ↑ 1.0 2,772 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=102
41. 1.400 1.400 ↑ 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.400 rows=2,772 loops=1)

  • Buffers: shared hit=102
42. 17.384 17.384 ↑ 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.004 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
43. 71.756 135.358 ↑ 1.0 134,993 1

Hash (cost=2,741.93..2,741.93 rows=134,993 width=28) (actual time=135.358..135.358 rows=134,993 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2492kB
  • Buffers: shared hit=1392, temp written=592
44. 63.602 63.602 ↑ 1.0 134,993 1

Seq Scan on timesheet ts (cost=0.00..2,741.93 rows=134,993 width=28) (actual time=0.006..63.602 rows=134,993 loops=1)

  • Buffers: shared hit=1392
45. 73.555 187.248 ↓ 1.0 134,993 1

Hash (cost=10,526.64..10,526.64 rows=134,652 width=20) (actual time=187.248..187.248 rows=134,993 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2221kB
  • Buffers: shared hit=8333, temp written=493
46. 113.693 113.693 ↓ 1.0 134,993 1

Seq Scan on dm_timesheetlist_facts tslist (cost=0.00..10,526.64 rows=134,652 width=20) (actual time=0.011..113.693 rows=134,993 loops=1)

  • Filter: (timesheetstatus = ANY ('{0,1,2,3,4}'::integer[]))
  • Buffers: shared hit=8333
47. 1.589 3.458 ↑ 1.0 2,772 1

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

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

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

  • Buffers: shared hit=102
49. 53.796 107.847 ↑ 1.0 86,689 1

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

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

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

  • Buffers: shared hit=1591
51. 0.169 6,336.468 ↓ 0.0 0 4,346

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

  • Buffers: shared hit=658 read=127187
52. 6,336.299 6,336.299 ↓ 0.0 0 1

Seq Scan on timeentrymetadata timeentrymetadata16 (cost=0.00..223,617.83 rows=1 width=73) (actual time=6,336.299..6,336.299 rows=0 loops=1)

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

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

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

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

  • Buffers: shared hit=1
55. 0.031 0.078 ↑ 1.0 66 1

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

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

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

  • Buffers: shared hit=1
57. 0.008 0.044 ↑ 1.0 7 1

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

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

Seq Scan on exchangerate (cost=0.00..2.35 rows=7 width=4) (actual time=0.025..0.036 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.544 1.203 ↑ 1.0 994 1

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

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

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

  • Buffers: shared hit=18
61. 428.960 7,037.447 ↓ 1.0 727,165 1

Hash (cost=223,617.83..223,617.83 rows=706,591 width=59) (actual time=7,037.447..7,037.447 rows=727,165 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2593kB
  • Buffers: shared hit=690 read=127155, temp written=6985
62. 6,608.487 6,608.487 ↓ 1.0 727,165 1

Seq Scan on timeentrymetadata timeentrymetadata9 (cost=0.00..223,617.83 rows=706,591 width=59) (actual time=2,004.425..6,608.487 rows=727,165 loops=1)

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

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

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

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

  • Buffers: shared hit=2525
65. 0.545 3.734 ↑ 1.0 994 1

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

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

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

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

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

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

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

  • Buffers: shared hit=18
69. 0.466 0.897 ↑ 1.0 994 1

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

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

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

  • Buffers: shared hit=6
71. 0.032 0.059 ↑ 1.0 50 1

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

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

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

  • Buffers: shared hit=1
73. 0.524 1.176 ↑ 1.0 994 1

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

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

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

  • Buffers: shared hit=18
75. 0.217 0.387 ↑ 1.0 377 1

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

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

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

  • Buffers: shared hit=4
Planning time : 11.080 ms
Execution time : 15,406.228 ms