explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Htdh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 769.297 ↓ 1.0 75 1

Finalize GroupAggregate (cost=106,626.98..106,645.73 rows=74 width=12) (actual time=769.180..769.297 rows=75 loops=1)

  • Group Key: refinitiv_2019_01.code
2. 0.000 788.227 ↓ 1.5 219 1

Gather Merge (cost=106,626.98..106,644.25 rows=148 width=12) (actual time=769.162..788.227 rows=219 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.237 2,247.789 ↑ 1.0 73 3

Sort (cost=105,626.96..105,627.14 rows=74 width=12) (actual time=749.258..749.263 rows=73 loops=3)

  • Sort Key: refinitiv_2019_01.code
  • Sort Method: quicksort Memory: 28kB
  • Worker 0: Sort Method: quicksort Memory: 28kB
  • Worker 1: Sort Method: quicksort Memory: 28kB
4. 978.075 2,247.552 ↑ 1.0 73 3

Partial HashAggregate (cost=105,623.92..105,624.66 rows=74 width=12) (actual time=749.173..749.184 rows=73 loops=3)

  • Group Key: refinitiv_2019_01.code
5. 328.721 1,269.477 ↑ 1.2 1,380,814 3

Parallel Append (cost=1.27..97,221.76 rows=1,680,432 width=12) (actual time=0.092..423.159 rows=1,380,814 loops=3)

6. 0.132 0.134 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_01 (cost=1.27..4.44 rows=2 width=12) (actual time=0.134..0.134 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
7. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_01_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
8. 0.000 0.006 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_02 (cost=1.27..4.44 rows=2 width=12) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
9. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_02_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
10. 0.002 0.007 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_03 (cost=1.27..4.44 rows=2 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
11. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_03_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
12. 0.001 0.002 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_04 (cost=1.27..4.44 rows=2 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
13. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_04_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
14. 0.002 0.007 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_10 (cost=1.27..4.44 rows=2 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
15. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_10_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
16. 0.000 0.004 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_11 (cost=1.27..4.44 rows=2 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
17. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_11_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
18. 0.000 0.005 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on refinitiv_2019_12 (cost=1.27..4.44 rows=2 width=12) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
19. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on refinitiv_2019_12_date_idx (cost=0.00..1.27 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
20. 940.551 940.551 ↑ 1.2 1,380,814 3

Parallel Index Scan using refinitiv_2019_08_date_idx on refinitiv_2019_08 (cost=0.57..88,612.40 rows=1,679,344 width=12) (actual time=0.022..313.517 rows=1,380,814 loops=3)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
21. 0.006 0.006 ↓ 0.0 0 1

Parallel Index Scan using refinitiv_2019_07_date_idx on refinitiv_2019_07 (cost=0.57..168.88 rows=1,521 width=12) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
22. 0.007 0.007 ↓ 0.0 0 1

Parallel Index Scan using refinitiv_2019_06_date_idx on refinitiv_2019_06 (cost=0.57..1.68 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
23. 0.007 0.007 ↓ 0.0 0 1

Parallel Index Scan using refinitiv_2019_05_date_idx on refinitiv_2019_05 (cost=0.56..2.78 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
24. 0.010 0.010 ↓ 0.0 0 1

Parallel Index Scan using refinitiv_2019_09_date_idx on refinitiv_2019_09 (cost=0.44..1.76 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
25. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: (date(timezone('UTC'::text, refinitiv_time)) = '2019-08-27'::date)
  • Rows Removed by Filter: 2
Planning time : 0.435 ms
Execution time : 788.393 ms