hstore-rendering=> explain analyze select count(*) from berlin_osm_dual_point where not amenity is null;
                                                           QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1544.99..1545.00 rows=1 width=0) (actual time=24.222..24.223 rows=1 loops=1)
   ->  Seq Scan on berlin_osm_dual_point  (cost=0.00..1516.84 rows=11257 width=0) (actual time=0.022..20.606 rows=11528 loops=1)
         Filter: (NOT (amenity IS NULL))
 Total runtime: 24.330 ms
(4 Zeilen)

hstore-rendering=> explain analyze select count(*) from berlin_osm_dual_point where (tags ? 'amenity');
                                                          QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1642.68..1642.69 rows=1 width=0) (actual time=55.125..55.125 rows=1 loops=1)
   ->  Seq Scan on berlin_osm_dual_point  (cost=0.00..1642.55 rows=50 width=0) (actual time=0.036..52.040 rows=11528 loops=1)
         Filter: (tags ? 'amenity'::text)
 Total runtime: 55.229 ms
(4 Zeilen)


hstore-rendering=> explain analyze select count(*) from berlin_osm_dual_point where amenity = 'restaurant';
                                                          QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1645.41..1645.42 rows=1 width=0) (actual time=24.642..24.643 rows=1 loops=1)
   ->  Seq Scan on berlin_osm_dual_point  (cost=0.00..1642.55 rows=1143 width=0) (actual time=0.062..24.153 rows=1221 loops=1)
         Filter: (amenity = 'restaurant'::text)
 Total runtime: 24.753 ms
(4 Zeilen)


hstore-rendering=> explain analyze select count(*) from berlin_osm_dual_point where (tags->'amenity' = 'restaurant');
                                                          QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1768.89..1768.90 rows=1 width=0) (actual time=61.786..61.786 rows=1 loops=1)
   ->  Seq Scan on berlin_osm_dual_point  (cost=0.00..1768.26 rows=251 width=0) (actual time=0.161..61.329 rows=1221 loops=1)
         Filter: ((tags -> 'amenity'::text) = 'restaurant'::text)
 Total runtime: 61.892 ms
(4 Zeilen)