Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.85 KB | None | 0 0
  1. explain analyze SELECT "main_host"."id", "main_host"."created", "main_host"."modified", "main_host"."description", "main_host"."created_by_id", "main_host"."modified_by_id", "main_host"."name", "main_host"."inventory_id", "main_host"."enabled", "main_host"."instance_id", "main_host"."variables", "main_host"."last_job_id", "main_host"."last_job_host_summary_id", "main_host"."has_active_failures", "main_host"."has_inventory_sources", "main_host"."ansible_facts", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", T4."id", T4."password", T4."last_login", T4."is_superuser", T4."username", T4."first_name", T4."last_name", T4."email", T4."is_staff", T4."is_active", T4."date_joined", "main_inventory"."id", "main_inventory"."created", "main_inventory"."modified", "main_inventory"."description", "main_inventory"."created_by_id", "main_inventory"."modified_by_id", "main_inventory"."name", "main_inventory"."organization_id", "main_inventory"."variables", "main_inventory"."has_active_failures", "main_inventory"."total_hosts", "main_inventory"."hosts_with_active_failures", "main_inventory"."total_groups", "main_inventory"."groups_with_active_failures", "main_inventory"."has_inventory_sources", "main_inventory"."total_inventory_sources", "main_inventory"."inventory_sources_with_failures", "main_inventory"."admin_role_id", "main_inventory"."update_role_id", "main_inventory"."adhoc_role_id", "main_inventory"."use_role_id", "main_inventory"."read_role_id", "main_unifiedjob"."id", "main_unifiedjob"."polymorphic_ctype_id", "main_unifiedjob"."created", "main_unifiedjob"."modified", "main_unifiedjob"."description", "main_unifiedjob"."created_by_id", "main_unifiedjob"."modified_by_id", "main_unifiedjob"."name", "main_unifiedjob"."old_pk", "main_unifiedjob"."unified_job_template_id", "main_unifiedjob"."launch_type", "main_unifiedjob"."schedule_id", "main_unifiedjob"."execution_node", "main_unifiedjob"."cancel_flag", "main_unifiedjob"."status", "main_unifiedjob"."failed", "main_unifiedjob"."started", "main_unifiedjob"."finished", "main_unifiedjob"."elapsed", "main_unifiedjob"."job_args", "main_unifiedjob"."job_cwd", "main_unifiedjob"."job_env", "main_unifiedjob"."job_explanation", "main_unifiedjob"."start_args", "main_unifiedjob"."result_stdout_text", "main_unifiedjob"."result_stdout_file", "main_unifiedjob"."result_traceback", "main_unifiedjob"."celery_task_id", "main_job"."unifiedjob_ptr_id", "main_job"."survey_passwords", "main_job"."job_type", "main_job"."inventory_id", "main_job"."project_id", "main_job"."playbook", "main_job"."credential_id", "main_job"."cloud_credential_id", "main_job"."network_credential_id", "main_job"."forks", "main_job"."limit", "main_job"."verbosity", "main_job"."extra_vars", "main_job"."job_tags", "main_job"."force_handlers", "main_job"."skip_tags", "main_job"."start_at_task", "main_job"."become_enabled", "main_job"."allow_simultaneous", "main_job"."timeout", "main_job"."job_template_id", "main_job"."artifacts", "main_job"."scm_revision", "main_job"."project_update_id", "main_unifiedjobtemplate"."id", "main_unifiedjobtemplate"."polymorphic_ctype_id", "main_unifiedjobtemplate"."created", "main_unifiedjobtemplate"."modified", "main_unifiedjobtemplate"."description", "main_unifiedjobtemplate"."created_by_id", "main_unifiedjobtemplate"."modified_by_id", "main_unifiedjobtemplate"."name", "main_unifiedjobtemplate"."old_pk", "main_unifiedjobtemplate"."current_job_id", "main_unifiedjobtemplate"."last_job_id", "main_unifiedjobtemplate"."last_job_failed", "main_unifiedjobtemplate"."last_job_run", "main_unifiedjobtemplate"."next_job_run", "main_unifiedjobtemplate"."next_schedule_id", "main_unifiedjobtemplate"."status", "main_jobtemplate"."unifiedjobtemplate_ptr_id", "main_jobtemplate"."survey_enabled", "main_jobtemplate"."survey_spec", "main_jobtemplate"."job_type", "main_jobtemplate"."inventory_id", "main_jobtemplate"."project_id", "main_jobtemplate"."playbook", "main_jobtemplate"."credential_id", "main_jobtemplate"."cloud_credential_id", "main_jobtemplate"."network_credential_id", "main_jobtemplate"."forks", "main_jobtemplate"."limit", "main_jobtemplate"."verbosity", "main_jobtemplate"."extra_vars", "main_jobtemplate"."job_tags", "main_jobtemplate"."force_handlers", "main_jobtemplate"."skip_tags", "main_jobtemplate"."start_at_task", "main_jobtemplate"."become_enabled", "main_jobtemplate"."allow_simultaneous", "main_jobtemplate"."timeout", "main_jobtemplate"."host_config_key", "main_jobtemplate"."ask_variables_on_launch", "main_jobtemplate"."ask_limit_on_launch", "main_jobtemplate"."ask_tags_on_launch", "main_jobtemplate"."ask_skip_tags_on_launch", "main_jobtemplate"."ask_job_type_on_launch", "main_jobtemplate"."ask_inventory_on_launch", "main_jobtemplate"."ask_credential_on_launch", "main_jobtemplate"."admin_role_id", "main_jobtemplate"."execute_role_id", "main_jobtemplate"."read_role_id", "main_jobhostsummary"."id", "main_jobhostsummary"."created", "main_jobhostsummary"."modified", "main_jobhostsummary"."job_id", "main_jobhostsummary"."host_id", "main_jobhostsummary"."host_name", "main_jobhostsummary"."changed", "main_jobhostsummary"."dark", "main_jobhostsummary"."failures", "main_jobhostsummary"."ok", "main_jobhostsummary"."processed", "main_jobhostsummary"."skipped", "main_jobhostsummary"."failed", T11."id", T11."polymorphic_ctype_id", T11."created", T11."modified", T11."description", T11."created_by_id", T11."modified_by_id", T11."name", T11."old_pk", T11."unified_job_template_id", T11."launch_type", T11."schedule_id", T11."execution_node", T11."cancel_flag", T11."status", T11."failed", T11."started", T11."finished", T11."elapsed", T11."job_args", T11."job_cwd", T11."job_env", T11."job_explanation", T11."start_args", T11."result_stdout_text", T11."result_stdout_file", T11."result_traceback", T11."celery_task_id", T10."unifiedjob_ptr_id", T10."survey_passwords", T10."job_type", T10."inventory_id", T10."project_id", T10."playbook", T10."credential_id", T10."cloud_credential_id", T10."network_credential_id", T10."forks", T10."limit", T10."verbosity", T10."extra_vars", T10."job_tags", T10."force_handlers", T10."skip_tags", T10."start_at_task", T10."become_enabled", T10."allow_simultaneous", T10."timeout", T10."job_template_id", T10."artifacts", T10."scm_revision", T10."project_update_id" FROM "main_host" INNER JOIN "main_inventory" ON ( "main_host"."inventory_id" = "main_inventory"."id" ) LEFT OUTER JOIN "auth_user" ON ( "main_host"."created_by_id" = "auth_user"."id" ) LEFT OUTER JOIN "auth_user" T4 ON ( "main_host"."modified_by_id" = T4."id" ) LEFT OUTER JOIN "main_job" ON ( "main_host"."last_job_id" = "main_job"."unifiedjob_ptr_id" ) LEFT OUTER JOIN "main_unifiedjob" ON ( "main_job"."unifiedjob_ptr_id" = "main_unifiedjob"."id" ) LEFT OUTER JOIN "main_jobtemplate" ON ( "main_job"."job_template_id" = "main_jobtemplate"."unifiedjobtemplate_ptr_id" ) LEFT OUTER JOIN "main_unifiedjobtemplate" ON ( "main_jobtemplate"."unifiedjobtemplate_ptr_id" = "main_unifiedjobtemplate"."id" ) LEFT OUTER JOIN "main_jobhostsummary" ON ( "main_host"."last_job_host_summary_id" = "main_jobhostsummary"."id" ) LEFT OUTER JOIN "main_job" T10 ON ( "main_jobhostsummary"."job_id" = T10."unifiedjob_ptr_id" ) LEFT OUTER JOIN "main_unifiedjob" T11 ON ( T10."unifiedjob_ptr_id" = T11."id" ) WHERE ("main_host"."inventory_id" IN (SELECT W0."id" FROM "main_inventory" W0 WHERE W0."id" IN (SELECT DISTINCT V0."object_id" FROM "main_rbac_role_ancestors" V0 WHERE (V0."ancestor_id" IN (SELECT U0."id" FROM "main_rbac_roles" U0 INNER JOIN "main_rbac_roles_members" U1 ON ( U0."id" = U1."role_id" ) WHERE U1."user_id" = 1) AND V0."content_type_id" = 45 AND V0."role_field" = 'read_role'))) AND "main_host"."ansible_facts" @> '{"ansible_processor_vcpus": 8}' AND "main_host"."id" >= 9000) ORDER BY "main_host"."name" ASC LIMIT 25;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement