explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qWep

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

Finalize GroupAggregate (cost=23,846,253.42..30,087,352.66 rows=34,297,648 width=114) (actual rows= loops=)

  • Group Key: runs.simulation_id, "LHS".period, "LHS".compartment, ((((runs.parameters -> 'transmissibility'::text) ->> 'ALLOMARK'::text))::numeric), ((((runs.parameters -> 'transmissibility'::text) ->> 'MARK'::text))::numeric)
  • Functions: 20
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=23,846,253.42..28,473,918.09 rows=33,250,734 width=114) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=23,845,253.39..24,634,958.33 rows=16,625,367 width=114) (actual rows= loops=)

  • Group Key: runs.simulation_id, "LHS".period, "LHS".compartment, ((((runs.parameters -> 'transmissibility'::text) ->> 'ALLOMARK'::text))::numeric), ((((runs.parameters -> 'transmissibility'::text) ->> 'MARK'::text))::numeric)
4. 0.000 0.000 ↓ 0.0

Sort (cost=23,845,253.39..23,886,816.81 rows=16,625,367 width=86) (actual rows= loops=)

  • Sort Key: runs.simulation_id, "LHS".period, "LHS".compartment, ((((runs.parameters -> 'transmissibility'::text) ->> 'ALLOMARK'::text))::numeric), ((((runs.parameters -> 'transmissibility'::text) ->> 'MARK'::text))::numeric)
5. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=305,204.76..19,464,649.74 rows=16,625,367 width=86) (actual rows= loops=)

  • Hash Cond: ("LHS".run_id = runs.id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on compartment_counts "LHS" (cost=0.00..12,011,420.31 rows=475,010,831 width=22) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=302,061.46..302,061.46 rows=85,144 width=172) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on runs (cost=0.00..302,061.46 rows=85,144 width=172) (actual rows= loops=)

  • Filter: ((simulation_id)::numeric = ANY ('{2.0,3.0,4.0,5.0,6.0,7.0,8.0}'::numeric[]))