Skip to content

Instantly share code, notes, and snippets.

@fbettag
Created January 9, 2011 06:01
Show Gist options
  • Save fbettag/771465 to your computer and use it in GitHub Desktop.
Save fbettag/771465 to your computer and use it in GitHub Desktop.
powerdns query - before
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment