explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZuX

Settings
# exclusive inclusive rows x rows loops node
1. 84.389 1,325,765.319 ↑ 2.7 7,525 1

Finalize GroupAggregate (cost=740,045.76..751,961.11 rows=20,039 width=229) (actual time=1,267,670.093..1,325,765.319 rows=7,525 loops=1)

  • Group Key: transactions_262_part_2019_10.country_iso, transactions_262_part_2019_10.state, transactions_262_part_2019_10.county, transactions_262_part_2019_10.locality, transactions_262_part_2019_10.tax_type, transactions_262_part_2019_10.tax_level, transactions_262_part_2019_10.rate
2. 53,675.498 1,325,680.930 ↑ 1.8 21,894 1

Gather Merge (cost=740,045.76..749,506.33 rows=40,078 width=229) (actual time=1,267,634.170..1,325,680.930 rows=21,894 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 24,602.292 1,272,005.432 ↑ 2.7 7,298 3 / 3

Partial GroupAggregate (cost=739,045.74..743,880.31 rows=20,039 width=229) (actual time=1,223,516.674..1,272,005.432 rows=7,298 loops=3)

  • Group Key: transactions_262_part_2019_10.country_iso, transactions_262_part_2019_10.state, transactions_262_part_2019_10.county, transactions_262_part_2019_10.locality, transactions_262_part_2019_10.tax_type, transactions_262_part_2019_10.tax_level, transactions_262_part_2019_10.rate
4. 112,598.297 1,247,403.140 ↓ 160.0 13,357,510 3 / 3

Sort (cost=739,045.74..739,254.48 rows=83,499 width=71) (actual time=1,223,405.806..1,247,403.140 rows=13,357,510 loops=3)

  • Sort Key: transactions_262_part_2019_10.country_iso, transactions_262_part_2019_10.state, transactions_262_part_2019_10.county, transactions_262_part_2019_10.locality, transactions_262_part_2019_10.tax_type, transactions_262_part_2019_10.tax_level, transactions_262_part_2019_10.rate
  • Sort Method: external merge Disk: 2,039,648kB
  • Worker 0: Sort Method: external merge Disk: 774,096kB
  • Worker 1: Sort Method: external merge Disk: 793,952kB
5. 2,214.974 1,134,804.843 ↓ 160.0 13,357,510 3 / 3

Result (cost=1,087.63..728,793.41 rows=83,499 width=71) (actual time=2,240.933..1,134,804.843 rows=13,357,510 loops=3)

6. 1,440.846 1,132,589.869 ↓ 160.0 13,357,510 3 / 3

Parallel Append (cost=1,087.63..727,958.42 rows=83,499 width=71) (actual time=2,240.931..1,132,589.869 rows=13,357,510 loops=3)

7. 451,542.747 452,707.269 ↓ 159.8 3,476,490 3 / 3

Parallel Bitmap Heap Scan on transactions_262_part_2019_10 (cost=1,137.37..178,810.09 rows=21,753 width=70) (actual time=1,169.929..452,707.269 rows=3,476,490 loops=3)

  • Recheck Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
  • Rows Removed by Filter: 96,052
  • Heap Blocks: exact=12,516 lossy=89,296
8. 1,164.522 1,164.522 ↓ 200.0 10,717,627 1 / 3

Bitmap Index Scan on transactions_262_part_2019_10_committed_date_clustered_idx (cost=0.00..1,124.32 rows=53,588 width=0) (actual time=3,493.567..3,493.567 rows=10,717,627 loops=1)

  • Index Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
9. 420,920.271 421,977.181 ↓ 240.0 4,988,610 2 / 3

Parallel Bitmap Heap Scan on transactions_262_part_2019_09 (cost=1,087.63..170,054.69 rows=20,785 width=71) (actual time=1,602.265..632,965.771 rows=4,988,610 loops=2)

  • Recheck Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
  • Rows Removed by Filter: 118,577
  • Heap Blocks: exact=28,493 lossy=200,296
10. 1,056.910 1,056.910 ↓ 200.0 10,214,373 1 / 3

Bitmap Index Scan on transactions_262_part_2019_09_committed_date_clustered_idx (cost=0.00..1,075.15 rows=51,072 width=0) (actual time=3,170.730..3,170.730 rows=10,214,373 loops=1)

  • Index Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
11. 205,007.369 205,352.862 ↓ 479.7 4,879,762 1 / 3

Parallel Bitmap Heap Scan on transactions_262_part_2019_12 (cost=533.39..83,769.33 rows=10,172 width=71) (actual time=1,050.049..616,058.585 rows=4,879,762 loops=1)

  • Recheck Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
  • Rows Removed by Filter: 137,183
  • Heap Blocks: exact=49,726 lossy=526,481
12. 345.493 345.493 ↓ 200.0 5,016,945 1 / 3

Bitmap Index Scan on transactions_262_part_2019_12_committed_date_clustered_idx (cost=0.00..527.28 rows=25,085 width=0) (actual time=1,036.479..1,036.479 rows=5,016,945 loops=1)

  • Index Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
13. 51,111.710 51,111.710 ↓ 480.3 14,786,077 1 / 3

Parallel Index Scan using transactions_262_part_2019_11_committed_date_clustered_idx on transactions_262_part_2019_11 (cost=0.43..294,898.67 rows=30,787 width=73) (actual time=11.454..153,335.129 rows=14,786,077 loops=1)

  • Index Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
  • Rows Removed by Filter: 182,619
14. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using transactions_262_part_2020_01_committed_date_clustered_idx on transactions_262_part_2020_01 (cost=0.12..8.14 rows=1 width=620) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
15. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on transactions_262 (cost=0.00..0.00 rows=1 width=620) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0) AND ((committed_date)::date >= '2019-09-01'::date) AND ((committed_date)::date < '2020-01-31'::date))