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