explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2BBR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=66.62..70.39 rows=52 width=1,012) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=66.62..66.75 rows=52 width=1,012) (actual rows= loops=)

  • Sort Key: jobs_job.id, jobs_job.date_inserted, jobs_job.date_modified, jobs_job.name, jobs_job.cloned_from_id, jobs_job.param_file_id, jobs_job.case_file_id, jobs_job.owner_id, jobs_job.is_template_dry_run, jobs_job.monte_carlo_iterations, jobs_job.encoded_encryption_key, jobs_job.is_public, jobs_job.use_spot_pricing, jobs_job.run_low_priority, jobs_job.latest_job_status_id, jobs_job.indexed_latest_or_completed_job_status, jobs_job.latest_cluster_status_id, jobs_job.visibility, jobs_job.visibility_modification_date, jobs_job.tutorial_id, jobs_job.input_file_parse_task, jobs_job.include_nominal_run, jobs_job.start_job_on_hour, jobs_job.cidr_rule, jobs_job.public_key, jobs_job.ssh_port, jobs_job.remote_viz_config_id, jobs_job.project_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on jobs_job (cost=54.09..65.14 rows=52 width=1,012) (actual rows= loops=)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2))
4.          

SubPlan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on billing_projectassignment u0 (cost=4.21..14.33 rows=7 width=4) (actual rows= loops=)

  • Recheck Cond: (project_id IS NULL)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on billing_projectassignment_project_id_ba64ce92 (cost=0.00..4.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (project_id IS NULL)
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.36..39.57 rows=67 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.21..33.55 rows=7 width=4) (actual rows= loops=)

  • Join Filter: (v0.id = u0_1.cluster_id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on clusters_cluster v0 (cost=0.00..10.80 rows=80 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Materialize (cost=4.21..14.37 rows=7 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on billing_projectassignment u0_1 (cost=4.21..14.33 rows=7 width=4) (actual rows= loops=)

  • Recheck Cond: (project_id IS NULL)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on billing_projectassignment_project_id_ba64ce92 (cost=0.00..4.21 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (project_id IS NULL)
13. 0.000 0.000 ↓ 0.0

Index Only Scan using clusters_cluster_jobs_cluster_id_job_id_cd1a076a_uniq on clusters_cluster_jobs v1 (cost=0.15..0.82 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (cluster_id = v0.id)