Skip to content

Instantly share code, notes, and snippets.

@fbettag
Created January 9, 2011 06:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fbettag/771466 to your computer and use it in GitHub Desktop.
Save fbettag/771466 to your computer and use it in GitHub Desktop.
powerdns query - after
pdns=> explain analyze select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='uberblo.gs';
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Index Scan using index_dns_records_name_active_rtype_zone on dns_records (cost=0.00..8.27 rows=1 width=49) (actual time=0.118..0.179 rows=1 loops=1)
Index Cond: (((name)::text = 'uberblo.gs'::text) AND ((type)::text = 'SOA'::text))
Total runtime: 0.298 ms
(3 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment