explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SA46

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 102,608.350 ↑ 4.8 169 1

Finalize GroupAggregate (cost=6,696,947.36..6,697,358.07 rows=807 width=12) (actual time=102,607.963..102,608.350 rows=169 loops=1)

  • Output: f_fica_toll_transaction_202002.toll_date, count(*)
  • Group Key: f_fica_toll_transaction_202002.toll_date
2. 24.767 102,613.903 ↑ 8.4 383 1

Gather Merge (cost=6,696,947.36..6,697,333.86 rows=3,228 width=12) (actual time=102,607.953..102,613.903 rows=383 loops=1)

  • Output: f_fica_toll_transaction_202002.toll_date, (PARTIAL count(*))
  • Workers Planned: 4
  • Workers Launched: 4
3. 0.090 102,589.136 ↑ 10.5 77 5 / 5

Sort (cost=6,695,947.30..6,695,949.32 rows=807 width=12) (actual time=102,589.127..102,589.136 rows=77 loops=5)

  • Output: f_fica_toll_transaction_202002.toll_date, (PARTIAL count(*))
  • Sort Key: f_fica_toll_transaction_202002.toll_date
  • Sort Method: quicksort Memory: 32kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
  • Worker 2: Sort Method: quicksort Memory: 27kB
  • Worker 3: Sort Method: quicksort Memory: 28kB
  • Worker 0: actual time=102,585.085..102585.091 rows=60 loops=1
  • Worker 1: actual time=102,586.831..102586.835 rows=29 loops=1
  • Worker 2: actual time=102,584.827..102584.834 rows=60 loops=1
  • Worker 3: actual time=102,584.911..102584.921 rows=78 loops=1
4. 4,524.286 102,589.046 ↑ 10.5 77 5 / 5

Partial HashAggregate (cost=6,695,900.27..6,695,908.34 rows=807 width=12) (actual time=102,589.016..102,589.046 rows=77 loops=5)

  • Output: f_fica_toll_transaction_202002.toll_date, PARTIAL count(*)
  • Group Key: f_fica_toll_transaction_202002.toll_date
  • Worker 0: actual time=102,585.010..102585.028 rows=60 loops=1
  • Worker 1: actual time=102,586.744..102586.761 rows=29 loops=1
  • Worker 2: actual time=102,584.703..102584.730 rows=60 loops=1
  • Worker 3: actual time=102,584.767..102584.800 rows=78 loops=1
5. 1,936.671 98,064.760 ↑ 1.3 22,681,916 5 / 5

Parallel Append (cost=0.00..6,553,612.50 rows=28,457,554 width=4) (actual time=1.123..98,064.760 rows=22,681,916 loops=5)

  • Worker 0: actual time=1.694..97509.634 rows=21,265,350 loops=1
  • Worker 1: actual time=2.469..98277.622 rows=17,712,389 loops=1
  • Worker 2: actual time=0.110..98819.921 rows=18,948,625 loops=1
  • Worker 3: actual time=1.271..98642.583 rows=17,449,907 loops=1
6. 27,481.187 27,481.187 ↑ 1.2 4,775,822 5 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202002 (cost=0.00..1,283,469.66 rows=5,969,772 width=4) (actual time=13.123..27,481.187 rows=4,775,822 loops=5)

  • Output: f_fica_toll_transaction_202002.toll_date
  • Filter: ((f_fica_toll_transaction_202002.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202002.toll_date >= '2020-01-01'::date))
  • Worker 0: actual time=6.651..1954.996 rows=442,087 loops=1
  • Worker 1: actual time=2.467..96446.837 rows=17,712,389 loops=1
  • Worker 2: actual time=43.187..35107.977 rows=5,231,204 loops=1
  • Worker 3: actual time=6.642..1947.606 rows=264,453 loops=1
7. 21,073.139 21,073.139 ↓ 1.3 7,462,587 3 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202001 (cost=0.00..1,203,264.11 rows=5,596,937 width=4) (actual time=2.574..35,121.898 rows=7,462,587 loops=3)

  • Output: f_fica_toll_transaction_202001.toll_date
  • Filter: ((f_fica_toll_transaction_202001.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202001.toll_date >= '2020-01-01'::date))
  • Worker 0: actual time=1.692..93443.740 rows=20,823,263 loops=1
  • Worker 3: actual time=3.004..5958.002 rows=765,889 loops=1
8. 23,317.441 23,317.441 ↓ 2.0 9,921,244 2 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202003 (cost=0.00..1,066,545.39 rows=4,960,746 width=4) (actual time=11.361..58,293.602 rows=9,921,244 loops=2)

  • Output: f_fica_toll_transaction_202003.toll_date
  • Filter: ((f_fica_toll_transaction_202003.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202003.toll_date >= '2020-01-01'::date))
  • Rows Removed by Filter: 1,209
  • Worker 3: actual time=1.266..89068.938 rows=16,419,565 loops=1
9. 21,834.063 21,834.063 ↓ 2.0 9,503,682 2 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202005 (cost=0.00..1,021,886.46 rows=4,752,758 width=4) (actual time=5.804..54,585.157 rows=9,503,682 loops=2)

  • Output: f_fica_toll_transaction_202005.toll_date
  • Filter: ((f_fica_toll_transaction_202005.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202005.toll_date >= '2020-01-01'::date))
  • Rows Removed by Filter: 3,180
  • Worker 2: actual time=0.106..62090.561 rows=13,717,421 loops=1
10. 1,268.530 1,268.530 ↓ 3.9 12,571,391 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202006 (cost=0.00..990,938.36 rows=3,247,066 width=4) (actual time=0.049..6,342.648 rows=12,571,391 loops=1)

  • Output: f_fica_toll_transaction_202006.toll_date
  • Filter: ((f_fica_toll_transaction_202006.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202006.toll_date >= '2020-01-01'::date))
  • Rows Removed by Filter: 5,867,374
11. 1,153.729 1,153.729 ↓ 4.0 15,721,469 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202004 (cost=0.00..845,158.11 rows=3,930,263 width=4) (actual time=0.063..5,768.647 rows=15,721,469 loops=1)

  • Output: f_fica_toll_transaction_202004.toll_date
  • Filter: ((f_fica_toll_transaction_202004.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202004.toll_date >= '2020-01-01'::date))
  • Rows Removed by Filter: 4,426
12. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202007 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202007.toll_date
  • Filter: ((f_fica_toll_transaction_202007.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202007.toll_date >= '2020-01-01'::date))
13. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202008 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202008.toll_date
  • Filter: ((f_fica_toll_transaction_202008.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202008.toll_date >= '2020-01-01'::date))
14. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202009 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202009.toll_date
  • Filter: ((f_fica_toll_transaction_202009.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202009.toll_date >= '2020-01-01'::date))
15. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202010 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202010.toll_date
  • Filter: ((f_fica_toll_transaction_202010.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202010.toll_date >= '2020-01-01'::date))
16. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202011 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202011.toll_date
  • Filter: ((f_fica_toll_transaction_202011.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202011.toll_date >= '2020-01-01'::date))
17. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_202012 (cost=0.00..10.44 rows=4 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: f_fica_toll_transaction_202012.toll_date
  • Filter: ((f_fica_toll_transaction_202012.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_202012.toll_date >= '2020-01-01'::date))
18. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on edw.f_fica_toll_transaction_p (cost=0.00..0.00 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: f_fica_toll_transaction_p.toll_date
  • Filter: ((f_fica_toll_transaction_p.bitcr_date < '2020-06-18'::date) AND (f_fica_toll_transaction_p.toll_date >= '2020-01-01'::date))
Planning time : 2.876 ms
Execution time : 102,620.591 ms