explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qxcC

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

Finalize GroupAggregate (cost=720,820.70..720,872.87 rows=200 width=41) (actual rows= loops=)

  • Group Key: fact_sales_transaction_product_2018.product_id
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=720,820.70..720,867.37 rows=400 width=41) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=719,820.68..719,821.18 rows=200 width=41) (actual rows= loops=)

  • Sort Key: fact_sales_transaction_product_2018.product_id
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=719,810.53..719,813.03 rows=200 width=41) (actual rows= loops=)

  • Group Key: fact_sales_transaction_product_2018.product_id
5. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..656,197.75 rows=12,722,557 width=15) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fact_sales_transaction_product_2018 (cost=0.00..454,691.48 rows=9,861,158 width=13) (actual rows= loops=)

  • Filter: (trn_date >= '2018-01-01'::date)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fact_sales_transaction_product_2019 (cost=0.00..137,893.48 rows=2,861,399 width=21) (actual rows= loops=)

  • Filter: (trn_date >= '2018-01-01'::date)