test=# EXPLAIN ANALYZE
test-# SELECT device_name FROM devices;
                                                        QUERY PLAN                                                        
--------------------------------------------------------------------------------------------------------------------------
 Result  (cost=0.00..25.64 rows=1264 width=43) (actual time=0.030..1.918 rows=264 loops=1)
   ->  Append  (cost=0.00..25.64 rows=1264 width=43) (actual time=0.025..1.499 rows=264 loops=1)
         ->  Seq Scan on devices  (cost=0.00..20.00 rows=1000 width=43) (actual time=0.005..0.005 rows=0 loops=1)
         ->  Seq Scan on routers devices  (cost=0.00..3.93 rows=193 width=11) (actual time=0.018..0.885 rows=193 loops=1)
         ->  Seq Scan on switches devices  (cost=0.00..1.71 rows=71 width=10) (actual time=0.009..0.339 rows=71 loops=1)
 Total runtime: 2.286 ms
(6 rows)
prev next