explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tmfi : Optimization for: plan #qZSy

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 59,148.404 ↑ 1.0 1 1

Finalize Aggregate (cost=3,989,170.96..3,989,170.97 rows=1 width=8) (actual time=59,148.402..59,148.404 rows=1 loops=1)

2. 7.214 59,151.886 ↓ 1.5 3 1

Gather (cost=3,989,170.75..3,989,170.96 rows=2 width=8) (actual time=59,148.215..59,151.886 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.017 59,144.672 ↑ 1.0 1 3

Partial Aggregate (cost=3,988,170.75..3,988,170.76 rows=1 width=8) (actual time=59,144.671..59,144.672 rows=1 loops=3)

4. 0.000 59,144.655 ↑ 3,902.4 157 3

Parallel Append (cost=0.00..3,986,639.07 rows=612,672 width=0) (actual time=40,766.536..59,144.655 rows=157 loops=3)

5. 54,729.475 54,729.475 ↑ 380.1 472 1

Parallel Seq Scan on refinitiv_2019_08 (cost=0.00..1,167,158.20 rows=179,412 width=0) (actual time=4,008.693..54,729.475 rows=472 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 86117160
6. 52,383.077 52,383.077 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_07 (cost=0.00..1,051,200.85 rows=161,565 width=0) (actual time=52,383.077..52,383.077 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 77551016
7. 13,783.316 13,783.316 ↓ 0.0 0 3

Parallel Seq Scan on refinitiv_2019_06 (cost=0.00..940,025.80 rows=144,709 width=0) (actual time=13,783.315..13,783.316 rows=0 loops=3)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 23153483
8. 25,832.092 25,832.092 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_05 (cost=0.00..585,567.23 rows=90,165 width=0) (actual time=25,832.092..25,832.092 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 43279076
9. 3,139.312 3,139.312 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_09 (cost=0.00..239,514.94 rows=36,813 width=0) (actual time=3,139.312..3,139.312 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 17670230
10. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_01 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
11. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_02 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
12. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_03 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
13. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_04 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
14. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_10 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
15. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_11 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
16. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_2019_12 (cost=0.00..15.38 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
17. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on refinitiv_default (cost=0.00..1.02 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 2
Planning time : 11.474 ms
Execution time : 59,152.026 ms