http://wiki.docking.org/index.php?action=history&feed=atom&title=Code_to_report_wynton_usage_by_yearCode to report wynton usage by year - Revision history2026-04-08T17:29:46ZRevision history for this page on the wikiMediaWiki 1.39.1http://wiki.docking.org/index.php?title=Code_to_report_wynton_usage_by_year&diff=16541&oldid=prevFrodo: asdf2025-02-06T19:52:10Z<p>asdf</p>
<p><b>New page</b></p><div><pre><br />
select sge_project,<br />
sge_owner, <br />
sge_qname, <br />
sge_granted_pe, <br />
sge_slots, <br />
round(sum ( gen_slot_hours)) as sum_slot_hours, <br />
round(avg(gen_cpu_time_div_wallclock)::numeric,2) as avg_threadiness,<br />
count(*) <br />
from accounting <br />
where gen_end_time >= '2024-01-01'<br />
and gen_end_time <= '2024-12-31' <br />
and sge_qname not like '%gpu%' <br />
group by 1,2,3,4,5 <br />
order by count desc ;<br />
</pre><br />
<br />
[[Category:Internal]]</div>Frodo