Handling/SWinfastructure/pSQL/index
#Basic pSQL commands to access GOLEM data
Last 100 discharges:
SELECT * FROM public.shots ORDER BY shot_no DESC LIMIT 100
Search for the longest discharge:
SELECT shot_no,t_plasma_duration FROM public.shots WHERE t_plasma_duration>1 ORDER BY t_plasma_duration DESC LIMIT 100