powerdns query - before

foo.sql

pdns=> explain analyze select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='uberblo.gs';
                                                         QUERY PLAN                                                           
-------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on dns_records  (cost=4.30..18.54 rows=1 width=49) (actual time=3.453..3.460 rows=1 loops=1)
  Recheck Cond: ((name)::text = 'uberblo.gs'::text)
  Filter: (upper((type)::text) = 'SOA'::text)
  ->  Bitmap Index Scan on index_dns_records_name  (cost=0.00..4.30 rows=6 width=0) (actual time=0.065..0.065 rows=6 loops=1)
        Index Cond: ((name)::text = 'uberblo.gs'::text)
Total runtime: 3.497 ms