explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1fij : Optimization for: plan #AHF7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 16,917.920 100,737.159 ↓ 1.1 78 1

Unique (cost=3.14..9,748,041.95 rows=72 width=16) (actual time=1.168..100,737.159 rows=78 loops=1)

  • Functions: 10
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.823 ms, Inlining 3.372 ms, Optimization 35.821 ms, Emission 35.707 ms, Total 75.723 ms
2. 37,660.359 83,819.239 ↓ 1.0 195,157,221 1

Merge Append (cost=3.14..9,260,503.87 rows=195,015,233 width=16) (actual time=1.166..83,819.239 rows=195,157,221 loops=1)

  • Sort Key: refinitiv_2019_01.code, refinitiv_2019_01.date, refinitiv_2019_01.time_ms DESC
3. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using refinitiv_2019_01_code_date_time_ms_idx on refinitiv_2019_01 (cost=0.15..140.85 rows=200 width=44) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
4. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using refinitiv_2019_02_code_date_time_ms_idx on refinitiv_2019_02 (cost=0.15..140.85 rows=200 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
5. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using refinitiv_2019_03_code_date_time_ms_idx on refinitiv_2019_03 (cost=0.15..140.85 rows=200 width=44) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
6. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using refinitiv_2019_04_code_date_time_ms_idx on refinitiv_2019_04 (cost=0.15..140.85 rows=200 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
7. 8,594.234 8,594.234 ↓ 1.0 43,279,597 1

Index Only Scan using refinitiv_2019_05_code_date_time_ms_idx on refinitiv_2019_05 (cost=0.56..940,699.73 rows=43,279,284 width=16) (actual time=0.280..8,594.234 rows=43,279,597 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
8. 14,921.531 14,921.531 ↓ 1.0 69,629,756 1

Index Only Scan using refinitiv_2019_06_code_date_time_ms_idx on refinitiv_2019_06 (cost=0.57..1,513,417.41 rows=69,628,648 width=16) (actual time=0.262..14,921.531 rows=69,629,756 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
9. 16,624.956 16,624.956 ↑ 1.0 77,741,511 1

Index Only Scan using refinitiv_2019_07_code_date_time_ms_idx on refinitiv_2019_07 (cost=0.57..1,689,772.19 rows=77,742,784 width=16) (actual time=0.261..16,624.956 rows=77,741,511 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
10. 6,018.074 6,018.074 ↓ 1.0 4,506,355 1

Index Only Scan using refinitiv_2019_08_code_date_time_ms_idx on refinitiv_2019_08 (cost=0.57..1,050,054.16 rows=4,363,715 width=16) (actual time=0.276..6,018.074 rows=4,506,355 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
11. 0.074 0.074 ↑ 1.0 2 1

Index Only Scan using refinitiv_default_code_date_time_ms_idx on refinitiv_default (cost=0.13..2.36 rows=2 width=16) (actual time=0.070..0.074 rows=2 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
Planning time : 1.717 ms
Execution time : 100,738.128 ms