explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2cgq

Settings
# exclusive inclusive rows x rows loops node
1. 16,918.461 101,845.101 ↓ 1.1 78 1

Unique (cost=3.14..9,754,810.19 rows=73 width=16) (actual time=1.239..101,845.101 rows=78 loops=1)

  • Functions: 10
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.809 ms, Inlining 3.492 ms, Optimization 35.895 ms, Emission 38.387 ms, Total 78.583 ms
2. 37,430.777 84,926.640 ↑ 1.0 195,157,221 1

Merge Append (cost=3.14..9,266,764.36 rows=195,218,332 width=16) (actual time=1.238..84,926.640 rows=195,157,221 loops=1)

  • Sort Key: refinitiv_2019_01.code, refinitiv_2019_01.date, refinitiv_2019_01.time_ms DESC
3. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
4. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
5. 0.002 0.002 ↓ 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.002..0.002 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. 9,665.867 9,665.867 ↑ 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,717.50 rows=43,280,281 width=16) (actual time=0.307..9,665.867 rows=43,279,597 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
8. 14,960.243 14,960.243 ↓ 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,413.31 rows=69,628,394 width=16) (actual time=0.281..14,960.243 rows=69,629,756 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
9. 15,694.368 15,694.368 ↑ 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,786.47 rows=77,743,600 width=16) (actual time=0.279..15,694.368 rows=77,741,511 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
10. 7,175.289 7,175.289 ↑ 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,052,052.16 rows=4,565,255 width=16) (actual time=0.271..7,175.289 rows=4,506,355 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
11. 0.082 0.082 ↑ 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.079..0.082 rows=2 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
  • Heap Fetches: 0
Planning time : 2.837 ms
Execution time : 101,846.107 ms