explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F6qy

Settings

Optimization(s) for this plan:

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

Finalize Aggregate (cost=207,456,943.52..207,456,943.53 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=207,456,943.30..207,456,943.51 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=207,455,943.30..207,455,943.31 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on externaldatamapping (cost=4,723.11..207,455,883.28 rows=24,008 width=0) (actual rows= loops=)

  • Recheck Cond: ((data_name)::text = 'com.agriness.ais.domain.base.supply.Purchase'::text)
  • Filter: (NOT (SubPlan 1))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on externaldatamapping_data_name_idx (cost=0.00..4,708.70 rows=115,238 width=0) (actual rows= loops=)

  • Index Cond: ((data_name)::text = 'com.agriness.ais.domain.base.supply.Purchase'::text)
6.          

SubPlan (for Parallel Bitmap Heap Scan)

7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..8,360.36 rows=112,155 width=19) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on externaldatamapping externaldatamapping_1 (cost=0.00..7,141.59 rows=112,155 width=19) (actual rows= loops=)

  • Filter: ((data_name)::text = 'com.agriness.ais.domain.base.supply.Consumption'::text)