Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment