gistfile1.txt

explain analyze SELECT certname_catalogs.certname, catalog_resources.resource, catalog_resources.type, catalog_resources.title,catalog_resources.tags, catalog_resources.exported, catalog_resources.sourcefile, catalog_resources.sourceline, rp.name, rp.value FROM catalog_resources JOIN certname_catalogs USING(catalog) LEFT OUTER JOIN resource_params rp USING(resource) INNER JOIN certnames ON certname_catalogs.certname = certnames.name WHERE (catalog_resources.type = 'Ssh_key') AND (catalog_resources.exported = true) AND (certnames.deactivated IS NULL) AND (NOT ((certname_catalogs.certname = 'some.host.name')))