Help for this page

Select Code to Download


  1. or download this
    EXPLAIN ANALYZE
SELECT u1.uptime_id as uid, u1.uptime_value
...
     ->  Seq Scan on uptime u2  (cost=0.00..25.00 rows=6 width=4) (act
+ual time=0.015..0.026 rows=1 loops=16)
           Filter: (uptime_id = ($0 + 1))
 Total runtime: 0.688 ms
  2. or download this
    EXPLAIN ANALYZE
SELECT u1.uptime_id as uid, u1.uptime_value
...
         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