Skip to content

Instantly share code, notes, and snippets.

@rmloveland

rmloveland/top-25-employees-force-index

Created January 31, 2020 19:00
Show Gist options
  • Save rmloveland/68fcec475f366a49b408a89e4ace38c4 to your computer and use it in GitHub Desktop.
Save rmloveland/68fcec475f366a49b408a89e4ace38c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
top-25-employees-force-index
Version: CockroachDB CCL v19.2.2 (x86_64-apple-darwin14, built 2019/12/11 01:27:47, go1.12.12)
CREATE TABLE salaries (
emp_no INT4 NOT NULL,
salary INT4 NOT NULL,
from_date DATE NOT NULL,
to_date DATE NOT NULL,
CONSTRAINT "primary" PRIMARY KEY (emp_no ASC, from_date ASC),
CONSTRAINT salaries_ibfk_1 FOREIGN KEY (emp_no) REFERENCES employees(emp_no) ON DELETE CASCADE,
INDEX salaries_salary_idx (salary ASC) STORING (to_date),
INDEX salaries_to_date_idx (to_date ASC),
FAMILY "primary" (emp_no, salary, from_date, to_date)
);
ALTER TABLE employees.public.salaries INJECT STATISTICS '[
{
"columns": [
"emp_no"
],
"created_at": "2020-01-31 17:44:02.384807+00:00",
"distinct_count": 301542,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"salary"
],
"created_at": "2020-01-31 17:44:02.384807+00:00",
"distinct_count": 84756,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"from_date"
],
"created_at": "2020-01-31 17:44:02.384807+00:00",
"distinct_count": 6382,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"to_date"
],
"created_at": "2020-01-31 17:44:02.384807+00:00",
"distinct_count": 6118,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"emp_no"
],
"created_at": "2020-01-31 17:46:06.944846+00:00",
"distinct_count": 301542,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"salary"
],
"created_at": "2020-01-31 17:46:06.944846+00:00",
"distinct_count": 84756,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"from_date"
],
"created_at": "2020-01-31 17:46:06.944846+00:00",
"distinct_count": 6382,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"to_date"
],
"created_at": "2020-01-31 17:46:06.944846+00:00",
"distinct_count": 6118,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"emp_no"
],
"created_at": "2020-01-31 17:47:09.731581+00:00",
"distinct_count": 301542,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"salary"
],
"created_at": "2020-01-31 17:47:09.731581+00:00",
"distinct_count": 84756,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"to_date"
],
"created_at": "2020-01-31 17:47:09.731581+00:00",
"distinct_count": 6118,
"histo_col_type": "DATE",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
},
{
"columns": [
"from_date"
],
"created_at": "2020-01-31 17:47:09.731581+00:00",
"distinct_count": 6382,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 2844047
}
]';
CREATE TABLE employees (
emp_no INT4 NOT NULL,
birth_date DATE NOT NULL,
first_name VARCHAR(14) NOT NULL,
last_name VARCHAR(16) NOT NULL,
gender STRING NOT NULL,
hire_date DATE NOT NULL,
CONSTRAINT "primary" PRIMARY KEY (emp_no ASC),
FAMILY "primary" (emp_no, birth_date, first_name, last_name, gender, hire_date),
CONSTRAINT imported_from_enum_gender CHECK (gender IN ('M':::STRING, 'F':::STRING))
);
ALTER TABLE employees.public.employees INJECT STATISTICS '[
{
"columns": [
"emp_no"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 301542,
"histo_col_type": "INT8",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
},
{
"columns": [
"birth_date"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 4743,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
},
{
"columns": [
"first_name"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 1275,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
},
{
"columns": [
"last_name"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 1637,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
},
{
"columns": [
"gender"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 2,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
},
{
"columns": [
"hire_date"
],
"created_at": "2020-01-31 17:43:59.797731+00:00",
"distinct_count": 5389,
"histo_col_type": "",
"name": "__auto__",
"null_count": 0,
"row_count": 300024
}
]';
EXPLAIN (OPT, ENV, VERBOSE) SELECT e.last_name, s.salary FROM (SELECT emp_no, salary FROM salaries@{FORCE_INDEX=salaries_salary_idx,DESC} WHERE to_date > now() ORDER BY salary DESC LIMIT 25) AS s JOIN employees AS e ON e.emp_no = s.emp_no WHERE s.salary > (SELECT max(salaries.salary) * 0.9 FROM salaries);
----
project
├── columns: last_name:8 salary:2
├── side-effects
├── stats: [rows=8.33333333]
├── cost: 3681373.06
├── prune: (2,8)
└── inner-join (lookup employees)
├── columns: salaries.emp_no:1 salary:2 to_date:4 e.emp_no:5 last_name:8
├── key columns: [1] = [5]
├── side-effects
├── stats: [rows=8.33333333, distinct(1)=8.33328734, null(1)=0, distinct(5)=8.33328734, null(5)=0]
├── cost: 3681372.97
├── fd: (5)-->(8), (1)==(5), (5)==(1)
├── select
│ ├── columns: salaries.emp_no:1 salary:2 to_date:4
│ ├── cardinality: [0 - 25]
│ ├── side-effects
│ ├── stats: [rows=8.33333333, distinct(1)=8.33328734, null(1)=0, distinct(2)=8.33333333, null(2)=0, distinct(4)=8.33013361, null(4)=0]
│ ├── cost: 3681322.29
│ ├── prune: (1)
│ ├── interesting orderings: (-2)
│ ├── limit
│ │ ├── columns: salaries.emp_no:1 salary:2 to_date:4
│ │ ├── internal-ordering: -2
│ │ ├── cardinality: [0 - 25]
│ │ ├── side-effects
│ │ ├── stats: [rows=25, distinct(1)=24.9992702, null(1)=0, distinct(2)=24.9966428, null(2)=0, distinct(4)=24.949319, null(4)=0]
│ │ ├── cost: 3681320.9
│ │ ├── prune: (1)
│ │ ├── interesting orderings: (-2)
│ │ ├── select
│ │ │ ├── columns: salaries.emp_no:1 salary:2 to_date:4
│ │ │ ├── side-effects
│ │ │ ├── stats: [rows=948015.667, distinct(1)=294957.667, null(1)=0, distinct(2)=84755.8955, null(2)=0, distinct(4)=6118, null(4)=0]
│ │ │ ├── cost: 3681320.64
│ │ │ ├── ordering: -2
│ │ │ ├── prune: (1,2)
│ │ │ ├── interesting orderings: (+1) (+2,+1) (+4,+1)
│ │ │ ├── scan salaries@salaries_salary_idx,rev
│ │ │ │ ├── columns: salaries.emp_no:1 salary:2 to_date:4
│ │ │ │ ├── flags: force-index=salaries_salary_idx,rev
│ │ │ │ ├── stats: [rows=2844047, distinct(1)=301542, null(1)=0, distinct(2)=84756, null(2)=0, distinct(4)=6118, null(4)=0]
│ │ │ │ │ histogram(1)= 0 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13651 568 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13651 568 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 13935 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284 14220 284
│ │ │ │ │ <--- 10004 ------- 11631 ------- 12977 ------- 14252 ------- 15366 ------- 17004 ------- 18731 ------- 20364 ------- 21755 ------- 23283 ------- 24615 ------- 26044 ------- 27688 ------- 28915 ------- 30367 ------- 31683 ------- 33369 ------- 35096 ------- 36705 ------- 38161 ------- 39566 ------- 41269 ------- 42667 ------- 44397 ------- 45869 ------- 47362 ------- 48572 ------- 50195 ------- 51474 ------- 52951 ------- 54324 ------- 55522 ------- 57113 ------- 58158 ------- 59800 ------- 61420 ------- 62534 ------- 63890 ------- 65587 ------- 67244 ------- 68541 ------- 70348 ------- 71842 ------- 73111 ------- 74835 ------- 76605 ------- 78166 ------- 79388 ------- 80978 ------- 82604 ------- 83914 ------- 85342 ------- 86823 ------- 88227 ------- 89839 ------- 90972 ------- 92448 ------- 94080 ------- 95793 ------- 97603 ------- 98930 ------- 100151 ------- 101384 ------- 102649 ------- 103891 ------- 105086 ------- 106692 ------- 108390 ------- 109716 ------- 201213 ------- 202902 ------- 204329 ------- 206044 ------- 207438 ------- 209121 ------- 210842 ------- 212281 ------- 213863 ------- 215639 ------- 217337 ------- 218995 ------- 220600 ------- 222010 ------- 223579 ------- 224926 ------- 226455 ------- 228041 ------- 229438 ------- 231154 ------- 232378 ------- 233743 ------- 235633 ------- 237417 ------- 238971 ------- 240412 ------- 241822 ------- 243304 ------- 244590 ------- 246116 ------- 247677 ------- 249353 ------- 250872 ------- 252382 ------- 253964 ------- 255642 ------- 256889 ------- 258294 ------- 259690 ------- 261153 ------- 263018 ------- 264649 ------- 266146 ------- 267541 ------- 269177 ------- 270948 ------- 272912 ------- 274562 ------- 276122 ------- 277485 ------- 279421 ------- 280786 ------- 282592 ------- 283818 ------- 285165 ------- 286692 ------- 288527 ------- 289716 ------- 291050 ------- 292761 ------- 294267 ------- 295516 ------- 296958 ------- 298665 ------- 400185 ------- 402024 ------- 403608 ------- 405216 ------- 406759 ------- 408848 ------- 410339 ------- 412328 ------- 413653 ------- 415102 ------- 416234 ------- 417614 ------- 419101 ------- 420218 ------- 421652 ------- 423020 ------- 424303 ------- 425462 ------- 426745 ------- 427985 ------- 429486 ------- 431439 ------- 433063 ------- 435160 ------- 436726 ------- 438421 ------- 439729 ------- 441207 ------- 442243 ------- 443770 ------- 445188 ------- 446761 ------- 448079 ------- 449369 ------- 450792 ------- 452193 ------- 453517 ------- 454970 ------- 456640 ------- 457900 ------- 459511 ------- 461054 ------- 462505 ------- 463813 ------- 465632 ------- 466977 ------- 468805 ------- 470096 ------- 471861 ------- 473381 ------- 474703 ------- 476554 ------- 478171 ------- 479700 ------- 481199 ------- 482753 ------- 484105 ------- 485621 ------- 487088 ------- 488628 ------- 490255 ------- 491606 ------- 493088 ------- 494800 ------- 496628 ------- 498334 ------- 499889
│ │ │ │ │ histogram(2)= 0 284 10807 1.075e+05 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13082 568 13367 284 13367 284 13082 853 13367 284 13367 284 13082 568 13367 284 13367 284 13367 284 13367 568 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13082 568 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 568 13367 284 13367 284 13367 284 13367 284 13367 568 13082 568 13367 284 13367 284 13367 284 13367 284 13367 284 13082 568 13367 284 13082 853 13367 284 13082 568 13367 284 13367 284 13367 284 13367 284 13367 284 13082 853 13367 568 13367 284 13367 284 12798 853 13367 284 13367 284 13367 568 13367 284 13367 284 13082 568 13367 284 13082 568 13082 568 13367 284 13367 284 13367 284 13082 853 13082 568 13367 284 13367 853 13367 284 13367 284 13082 568 13367 568 13367 284 13367 284 13367 284 13082 568 13367 284 13082 568 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13367 284 13082 853 13367 284 13082 568 13367 568 13367 284 13367 284 13367 284 13082 568 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 568 13367 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13367 568 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 568 13367 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13367 853 13367 284 13651 284 13367 568 13651 284 13651 284 13651 568 13367 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284 13651 284
│ │ │ │ │ <--- 39287 -------- 40000 -------- 40410 ------- 40824 ------- 41189 ------- 41563 ------- 41854 ------- 42141 ------- 42373 ------- 42606 ------- 42930 ------- 43138 ------- 43314 ------- 43576 ------- 43779 ------- 43957 ------- 44124 ------- 44291 ------- 44551 ------- 44780 ------- 45039 ------- 45279 ------- 45479 ------- 45688 ------- 45961 ------- 46245 ------- 46463 ------- 46649 ------- 46839 ------- 47067 ------- 47272 ------- 47437 ------- 47602 ------- 47852 ------- 48070 ------- 48285 ------- 48490 ------- 48696 ------- 48947 ------- 49125 ------- 49328 ------- 49544 ------- 49730 ------- 49902 ------- 50117 ------- 50317 ------- 50492 ------- 50681 ------- 50899 ------- 51154 ------- 51342 ------- 51549 ------- 51729 ------- 51942 ------- 52172 ------- 52355 ------- 52512 ------- 52719 ------- 52901 ------- 53087 ------- 53272 ------- 53484 ------- 53698 ------- 53908 ------- 54119 ------- 54329 ------- 54543 ------- 54745 ------- 54926 ------- 55096 ------- 55261 ------- 55473 ------- 55713 ------- 55938 ------- 56103 ------- 56334 ------- 56516 ------- 56669 ------- 56873 ------- 57061 ------- 57244 ------- 57482 ------- 57729 ------- 57942 ------- 58194 ------- 58394 ------- 58567 ------- 58780 ------- 59003 ------- 59260 ------- 59427 ------- 59663 ------- 59870 ------- 60115 ------- 60342 ------- 60580 ------- 60837 ------- 61060 ------- 61279 ------- 61455 ------- 61711 ------- 61943 ------- 62160 ------- 62380 ------- 62650 ------- 62875 ------- 63128 ------- 63327 ------- 63569 ------- 63776 ------- 64032 ------- 64174 ------- 64390 ------- 64632 ------- 64850 ------- 65103 ------- 65321 ------- 65563 ------- 65748 ------- 65937 ------- 66229 ------- 66509 ------- 66835 ------- 67080 ------- 67262 ------- 67534 ------- 67771 ------- 68013 ------- 68264 ------- 68471 ------- 68772 ------- 69033 ------- 69311 ------- 69507 ------- 69800 ------- 70080 ------- 70390 ------- 70661 ------- 71018 ------- 71341 ------- 71679 ------- 71904 ------- 72216 ------- 72484 ------- 72792 ------- 73107 ------- 73430 ------- 73774 ------- 74069 ------- 74396 ------- 74734 ------- 75066 ------- 75385 ------- 75695 ------- 76112 ------- 76393 ------- 76773 ------- 77150 ------- 77458 ------- 77900 ------- 78374 ------- 78717 ------- 79067 ------- 79392 ------- 79800 ------- 80316 ------- 80656 ------- 81064 ------- 81467 ------- 81836 ------- 82339 ------- 82782 ------- 83343 ------- 83929 ------- 84555 ------- 85261 ------- 85825 ------- 86561 ------- 87191 ------- 87863 ------- 88489 ------- 89066 ------- 89724 ------- 90372 ------- 91350 ------- 92147 ------- 92967 ------- 93888 ------- 94968 ------- 95887 ------- 96804 ------- 97884 ------- 99050 ------- 100339 ------- 102161 ------- 103928 ------- 106944 ------- 111063 ------- 115295 ------- 141842
│ │ │ │ │ histogram(4)= 0 284 13935 284 13935 284 13935 284 13935 284 13935 284 13367 853 13935 284 13935 284 13935 284 13935 568 13935 568 13935 853 13935 568 13935 284 13935 568 13935 568 13367 853 13651 568 13935 284 13367 1137 13651 1137 13651 568 13651 1137 13651 568 13935 568 13651 568 13935 284 13935 284 13082 1422 13935 853 13935 284 13651 568 13651 853 13935 284 13935 1137 13367 853 13935 568 13651 568 13367 1137 13651 568 13935 284 13935 568 13935 568 13367 853 13935 1137 13367 853 13651 568 13651 853 13935 284 13935 284 13935 284 13935 568 13651 853 13935 284 13651 568 13935 1137 13651 853 13935 568 13651 568 13935 568 13651 568 13082 1706 13935 284 13651 568 13082 1137 13935 1422 13935 284 12798 1706 13651 568 13651 853 13935 284 13082 1422 13082 1422 13651 853 13935 853 13935 284 13935 568 13651 853 13367 1137 13651 568 12798 2275 13651 853 13367 1137 13651 1137 13651 853 13082 853 12798 1422 13651 568 13082 853 13082 853 13651 853 13651 284 13651 568 13651 284 13367 568 13367 1137 12513 1422 13082 853 13651 853 13367 568 13367 1422 13651 284 13651 568 13367 568 13367 853 13367 568 13651 568 13651 568 13651 568 13082 1137 13082 1422 13367 853 13367 568 13651 284 13651 568 13367 1422 13367 853 13367 1137 12798 1137 13651 568 13651 568 13651 568 13651 284 13367 568 12798 1137 13651 1137 13082 853 12229 1706 13082 1706 12513 1422 13367 568 13651 1706 13367 853 13651 284 13651 568 13651 284 13082 1422 13082 1422 13651 1422 13367 1706 13082 1137 13367 568 13651 568 13651 853 13367 853 13651 568 13651 1422 13651 284 13367 1706 13082 853 13651 568 13367 568 13651 284 13651 568 13367 568 13651 1422 12798 1422 12798 1706 13367 568 12229 1706 13367 1137 13651 568 13651 284 12513 1422 13367 568 12798 1422 12798 1137 13651 568 13651 568 13367 568 13367 568 12513 1422 13651 568 12513 1706 12798 1137 13367 568 13651 1422 13367 853 13367 1706 12798 1706 13651 284 13651 1137 3412 2.3406e+05
│ │ │ │ │ <--- '1986-02-02' ------- '1986-08-27' ------- '1987-02-22' ------- '1987-07-18' ------- '1987-11-29' ------- '1988-03-03' ------- '1988-05-22' ------- '1988-08-28' ------- '1988-11-19' ------- '1989-02-14' ------- '1989-05-03' ------- '1989-07-10' ------- '1989-09-16' ------- '1989-11-18' ------- '1990-01-08' ------- '1990-02-25' ------- '1990-04-07' ------- '1990-06-05' ------- '1990-07-24' ------- '1990-09-12' ------- '1990-11-13' ------- '1990-12-25' ------- '1991-02-16' ------- '1991-03-24' ------- '1991-05-12' ------- '1991-06-28' ------- '1991-08-15' ------- '1991-09-23' ------- '1991-10-25' ------- '1991-12-01' ------- '1992-01-08' ------- '1992-02-23' ------- '1992-03-31' ------- '1992-05-09' ------- '1992-06-21' ------- '1992-07-20' ------- '1992-09-07' ------- '1992-10-10' ------- '1992-11-12' ------- '1992-12-21' ------- '1993-02-05' ------- '1993-03-14' ------- '1993-04-14' ------- '1993-05-22' ------- '1993-06-21' ------- '1993-07-25' ------- '1993-08-26' ------- '1993-09-24' ------- '1993-10-22' ------- '1993-11-19' ------- '1993-12-26' ------- '1994-02-01' ------- '1994-03-01' ------- '1994-03-25' ------- '1994-04-27' ------- '1994-05-27' ------- '1994-06-28' ------- '1994-07-28' ------- '1994-08-25' ------- '1994-09-24' ------- '1994-11-07' ------- '1994-12-11' ------- '1995-01-10' ------- '1995-02-07' ------- '1995-03-10' ------- '1995-04-15' ------- '1995-05-16' ------- '1995-06-17' ------- '1995-07-18' ------- '1995-08-21' ------- '1995-09-23' ------- '1995-10-19' ------- '1995-11-17' ------- '1995-12-19' ------- '1996-01-17' ------- '1996-02-10' ------- '1996-03-01' ------- '1996-03-26' ------- '1996-04-22' ------- '1996-05-15' ------- '1996-06-06' ------- '1996-06-28' ------- '1996-07-30' ------- '1996-08-25' ------- '1996-09-22' ------- '1996-10-24' ------- '1996-11-18' ------- '1996-12-10' ------- '1997-01-11' ------- '1997-02-05' ------- '1997-02-26' ------- '1997-03-24' ------- '1997-04-14' ------- '1997-05-08' ------- '1997-06-03' ------- '1997-06-28' ------- '1997-07-21' ------- '1997-08-09' ------- '1997-09-03' ------- '1997-09-25' ------- '1997-10-19' ------- '1997-11-07' ------- '1997-12-05' ------- '1998-01-01' ------- '1998-01-28' ------- '1998-02-16' ------- '1998-03-15' ------- '1998-04-07' ------- '1998-05-02' ------- '1998-05-27' ------- '1998-06-21' ------- '1998-07-13' ------- '1998-08-09' ------- '1998-08-28' ------- '1998-09-16' ------- '1998-10-12' ------- '1998-11-07' ------- '1998-12-02' ------- '1998-12-25' ------- '1999-01-16' ------- '1999-02-09' ------- '1999-03-01' ------- '1999-03-19' ------- '1999-04-11' ------- '1999-05-06' ------- '1999-05-31' ------- '1999-06-17' ------- '1999-07-04' ------- '1999-07-21' ------- '1999-08-07' ------- '1999-08-27' ------- '1999-09-26' ------- '1999-10-17' ------- '1999-11-07' ------- '1999-11-24' ------- '1999-12-14' ------- '2000-01-11' ------- '2000-01-31' ------- '2000-02-20' ------- '2000-03-11' ------- '2000-03-27' ------- '2000-04-17' ------- '2000-05-06' ------- '2000-05-25' ------- '2000-06-16' ------- '2000-07-03' ------- '2000-07-25' ------- '2000-08-15' ------- '2000-08-31' ------- '2000-09-22' ------- '2000-10-13' ------- '2000-11-03' ------- '2000-11-23' ------- '2000-12-11' ------- '2001-01-04' ------- '2001-01-25' ------- '2001-02-16' ------- '2001-03-08' ------- '2001-03-29' ------- '2001-04-21' ------- '2001-05-11' ------- '2001-06-02' ------- '2001-06-20' ------- '2001-07-13' ------- '2001-08-01' ------- '2001-08-19' ------- '2001-09-08' ------- '2001-09-27' ------- '2001-10-19' ------- '2001-11-06' ------- '2001-11-25' ------- '2001-12-13' ------- '2002-01-02' ------- '2002-01-22' ------- '2002-02-13' ------- '2002-03-03' ------- '2002-03-25' ------- '2002-04-14' ------- '2002-05-05' ------- '2002-05-26' ------- '2002-06-13' ------- '2002-07-11' ------- '2002-07-27' ------ '9999-01-01'
│ │ │ │ ├── cost: 3652880.16
│ │ │ │ ├── ordering: -2
│ │ │ │ ├── prune: (1,2,4)
│ │ │ │ └── interesting orderings: (+1) (+2,+1) (+4,+1)
│ │ │ └── filters
│ │ │ └── to_date > now() [outer=(4), side-effects, constraints=(/4: (/NULL - ])]
│ │ └── const: 25
│ └── filters
│ └── gt [outer=(2), subquery, constraints=(/2: (/NULL - ])]
│ ├── variable: salary
│ └── subquery
│ └── project
│ ├── columns: "?column?":16
│ ├── cardinality: [1 - 1]
│ ├── stats: [rows=1]
│ ├── cost: 1.13
│ ├── key: ()
│ ├── fd: ()-->(16)
│ ├── scalar-group-by
│ │ ├── columns: max:15
│ │ ├── cardinality: [1 - 1]
│ │ ├── stats: [rows=1]
│ │ ├── cost: 1.1
│ │ ├── key: ()
│ │ ├── fd: ()-->(15)
│ │ ├── scan salaries@salaries_salary_idx,rev
│ │ │ ├── columns: salary:12
│ │ │ ├── limit: 1(rev)
│ │ │ ├── stats: [rows=1]
│ │ │ ├── cost: 1.07
│ │ │ ├── key: ()
│ │ │ └── fd: ()-->(12)
│ │ └── aggregations
│ │ └── const-agg [outer=(12)]
│ │ └── variable: salary
│ └── projections
│ └── max * 0.9 [outer=(15)]
└── filters (true)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment