You can join the table with itself i.e on sensor id and add lift. timestamp < right. timestamp as join condition. Then you pick the rows, where right. id is null. Voila, you got...

You can use the "Batch Requests/Sec." PMON counter for an overall measure of database requests processed per second. That may or may not be a transaction from a perspective of...