explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qZSy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 50,387.448 ↑ 1.0 1 1

Finalize Aggregate (cost=3,989,181.55..3,989,181.56 rows=1 width=8) (actual time=50,387.448..50,387.448 rows=1 loops=1)

2. 10.619 50,389.380 ↓ 1.5 3 1

Gather (cost=3,989,181.33..3,989,181.54 rows=2 width=8) (actual time=50,387.305..50,389.380 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.014 50,378.761 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=3,988,181.33..3,988,181.34 rows=1 width=8) (actual time=50,378.761..50,378.761 rows=1 loops=3)

4. 0.017 50,378.747 ↑ 3,902.4 157 3 / 3

Parallel Append (cost=0.00..3,986,649.66 rows=612,670 width=0) (actual time=34,851.757..50,378.747 rows=157 loops=3)

5. 16,367.372 16,367.372 ↑ 380.1 472 1 / 3

Parallel Seq Scan on refinitiv_2019_08 (cost=0.00..1,167,157.90 rows=179,412 width=0) (actual time=3,793.696..49,102.115 rows=472 loops=1)

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

Parallel Seq Scan on refinitiv_2019_07 (cost=0.00..1,051,204.35 rows=161,566 width=0) (actual time=47,438.734..47,438.734 rows=0 loops=1)

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

Parallel Seq Scan on refinitiv_2019_06 (cost=0.00..940,023.40 rows=144,708 width=0) (actual time=14,692.881..14,692.881 rows=0 loops=3)

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

Parallel Seq Scan on refinitiv_2019_05 (cost=0.00..585,564.80 rows=90,164 width=0) (actual time=7,392.001..7,392.001 rows=0 loops=1)

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

Parallel Seq Scan on refinitiv_2019_09 (cost=0.00..239,512.80 rows=36,812 width=0) (actual time=3,124.690..3,124.690 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 / 3

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 / 3

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 / 3

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 / 3

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 / 3

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 / 3

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 / 3

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.002 0.002 ↓ 0.0 0 1 / 3

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

  • Filter: ((refinitiv_time)::date = '2019-08-03'::date)
  • Rows Removed by Filter: 2
Planning time : 0.222 ms
Execution time : 50,389.468 ms