explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uE6G

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

Finalize GroupAggregate (cost=21,702,987.68..21,702,987.73 rows=2 width=15) (actual rows= loops=)

  • Group Key: source_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=21,702,987.68..21,702,987.69 rows=4 width=15) (actual rows= loops=)

  • Sort Key: source_id
3. 0.000 0.000 ↓ 0.0

Gather (cost=21,702,987.22..21,702,987.64 rows=4 width=15) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=21,701,987.22..21,701,987.24 rows=2 width=15) (actual rows= loops=)

  • Group Key: source_id
5. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on store_stock_balance d (cost=412,901.31..21,671,428.53 rows=6,111,738 width=7) (actual rows= loops=)

  • Recheck Cond: ((business_timestamp >= '2020-03-01 00:00:00'::timestamp without time zone) AND (business_timestamp < '2020-04-01 00:00:00'::timestamp without time zone))
  • -> Bitmap Index Scan on idx_store_stock_balance_date (cost=0.00..409234.27 rows=14668170 width=0)" Index Cond: ((business_timestamp >= '2020-03-01 00:00:00'::timestamp without time zone) AND (business_timestamp < '2020-04-01 00:00:00'::timestamp without time zone))