gistfile1.txt

explain analyze select results.* from (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 = 'Sshkey') AND (catalog_resources.exported = true) AND (certnames.deactivated IS NULL) AND (NOT ((certname_catalogs.certname = 'any node name here'))) AND (catalog_resources.resource IN (SELECT rp.resource FROM resource_params rp WHERE rp.name = 'type' AND rp.value = '"rsa"'))) results