-- explain (analyze,buffers)
select 
	to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle + axis_offset.x, y_axis_angle + axis_offset.y, sensor_temperature, power_source_voltage, zc.pn
from zc
join axis_offset on (zc.pn = axis_offset.pn)
where zc.pn in (
2012230015,
2009210010,
2008050077,
2012230028,
2012230011
)
and time > '2022-01-14 14:00'
order by time asc 

