resources/index_advisory.create.sql


1
2
3
4
5
6
7
8
9
10


create table index_advisory(	reloid		oid,
								attrs		integer[],
								profit		real,
								index_size	integer,
								backend_pid	integer,
								timestamp	timestamptz);

create index IA_reloid on index_advisory( reloid );
create index IA_backend_pid on index_advisory( backend_pid );