explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSI

Settings
# exclusive inclusive rows x rows loops node
1. 81.941 20,048.006 ↓ 228.9 45,775 1

Finalize GroupAggregate (cost=720,820.70..720,872.87 rows=200 width=41) (actual time=19,866.929..20,048.006 rows=45,775 loops=1)

  • Group Key: fact_sales_transaction_product_2018.product_id
2. 0.000 19,966.065 ↓ 291.9 116,768 1

Gather Merge (cost=720,820.70..720,867.37 rows=400 width=41) (actual time=19,866.897..19,966.065 rows=116,768 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,264.128 59,593.209 ↓ 194.6 38,923 3

Sort (cost=719,820.68..719,821.18 rows=200 width=41) (actual time=19,834.313..19,864.403 rows=38,923 loops=3)

  • Sort Key: fact_sales_transaction_product_2018.product_id
  • Sort Method: external merge Disk: 2624kB
  • Worker 0: Sort Method: external merge Disk: 2200kB
  • Worker 1: Sort Method: external merge Disk: 2608kB
4. 31,710.855 58,329.081 ↓ 194.6 38,923 3

Partial HashAggregate (cost=719,810.53..719,813.03 rows=200 width=41) (actual time=19,378.716..19,443.027 rows=38,923 loops=3)

  • Group Key: fact_sales_transaction_product_2018.product_id
5. 4,875.919 26,618.226 ↑ 1.2 10,178,046 3

Parallel Append (cost=0.00..656,197.75 rows=12,722,557 width=15) (actual time=0.112..8,872.742 rows=10,178,046 loops=3)

6. 16,793.421 16,793.421 ↑ 1.2 7,888,927 3

Parallel Seq Scan on fact_sales_transaction_product_2018 (cost=0.00..454,691.48 rows=9,861,158 width=13) (actual time=0.163..5,597.807 rows=7,888,927 loops=3)

  • Filter: (trn_date >= '2018-01-01'::date)
7. 4,948.886 4,948.886 ↓ 1.2 3,433,678 2

Parallel Seq Scan on fact_sales_transaction_product_2019 (cost=0.00..137,893.48 rows=2,861,399 width=21) (actual time=0.097..2,474.443 rows=3,433,678 loops=2)

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