EXPLAIN ANALYZE
SELECT u1.uptime_id as uid, u1.uptime_value
  FROM uptime u1, uptime u2
 WHERE u2.uptime_id = u1.uptime_id+1
   AND u1.uptime_value > u2.uptime_value;

                                                     QUERY PLAN                                                                                 
--------------------------------------------------------------------------------------------------------------------
 Merge Join  (cost=139.66..247.18 rows=1667 width=8) (actual time=0.453..0.654 rows=3 loops=1)
   Merge Cond: ("outer"."?column3?" = "inner".uptime_id)
   Join Filter: ("outer".uptime_value > "inner".uptime_value)
   ->  Sort  (cost=69.83..72.33 rows=1000 width=8) (actual time=0.193..0.250 rows=16 loops=1)
         Sort Key: (u1.uptime_id + 1)
         ->  Seq Scan on uptime u1  (cost=0.00..20.00 rows=1000 width=8) (actual time=0.020..0.102 rows=16 loops=1)
   ->  Sort  (cost=69.83..72.33 rows=1000 width=8) (actual time=0.159..0.221 rows=16 loops=1)
         Sort Key: u2.uptime_id
         ->  Seq Scan on uptime u2  (cost=0.00..20.00 rows=1000 width=8) (actual time=0.005..0.076 rows=16 loops=1)
 Total runtime: 0.765 ms