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