explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FV1Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 102,531.766 ↑ 3.0 169 1

Sort (cost=8,411,439.47..8,411,440.73 rows=506 width=12) (actual time=102,531.756..102,531.766 rows=169 loops=1)

  • Output: f_fica_toll_transaction_p.toll_date, (count(*))
  • Sort Key: f_fica_toll_transaction_p.toll_date
  • Sort Method: quicksort Memory: 32kB
2. 16,974.691 102,531.720 ↑ 3.0 169 1

HashAggregate (cost=8,411,411.68..8,411,416.74 rows=506 width=12) (actual time=102,531.692..102,531.720 rows=169 loops=1)

  • Output: f_fica_toll_transaction_p.toll_date, count(*)
  • Group Key: f_fica_toll_transaction_p.toll_date
3. 7,971.567 85,557.029 ↑ 1.0 113,409,580 1

Append (cost=0.00..7,840,512.79 rows=114,179,778 width=4) (actual time=1.047..85,557.029 rows=113,409,580 loops=1)

4. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_p (cost=0.00..0.00 rows=1 width=4) (actual time=0.003..0.003 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))
5. 14,786.153 14,786.153 ↑ 1.0 22,387,762 1

Seq Scan on edw.f_fica_toll_transaction_202001 (cost=0.00..1,455,130.42 rows=22,387,927 width=4) (actual time=1.043..14,786.153 rows=22,387,762 loops=1)

  • 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))
6. 15,801.168 15,801.168 ↓ 1.0 23,879,108 1

Seq Scan on edw.f_fica_toll_transaction_202002 (cost=0.00..1,550,623.38 rows=23,780,025 width=4) (actual time=1.291..15,801.168 rows=23,879,108 loops=1)

  • 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))
7. 12,245.140 12,245.140 ↑ 1.0 19,842,487 1

Seq Scan on edw.f_fica_toll_transaction_202003 (cost=0.00..1,289,820.10 rows=19,845,944 width=4) (actual time=1.195..12,245.140 rows=19,842,487 loops=1)

  • 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: 2,484
8. 10,081.449 10,081.449 ↑ 1.0 15,721,469 1

Seq Scan on edw.f_fica_toll_transaction_202004 (cost=0.00..1,022,090.21 rows=15,726,410 width=4) (actual time=1.219..10,081.449 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,560
9. 12,013.695 12,013.695 ↑ 1.0 19,007,363 1

Seq Scan on edw.f_fica_toll_transaction_202005 (cost=0.00..1,235,836.23 rows=19,014,974 width=4) (actual time=1.020..12,013.695 rows=19,007,363 loops=1)

  • 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: 6,844
10. 12,657.839 12,657.839 ↑ 1.1 12,571,391 1

Seq Scan on edw.f_fica_toll_transaction_202006 (cost=0.00..1,286,947.95 rows=13,424,461 width=4) (actual time=0.935..12,657.839 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: 7,230,376
11. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202007 (cost=0.00..10.75 rows=6 width=4) (actual time=0.007..0.007 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))
12. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202008 (cost=0.00..10.75 rows=6 width=4) (actual time=0.003..0.003 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))
13. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202009 (cost=0.00..10.75 rows=6 width=4) (actual time=0.001..0.001 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))
14. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202010 (cost=0.00..10.75 rows=6 width=4) (actual time=0.001..0.001 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))
15. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202011 (cost=0.00..10.75 rows=6 width=4) (actual time=0.001..0.001 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))
16. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on edw.f_fica_toll_transaction_202012 (cost=0.00..10.75 rows=6 width=4) (actual time=0.002..0.002 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))
Planning time : 1.773 ms
Execution time : 102,534.699 ms