Database: regression

Database Objects
- Schema
- Tables
- Indexes
- Views
- Sequeces
- Triggers
Management Information
- Roles
Setting Parameters

Database Objects

Schema

ID	oid	schemaname	owner
1	2200	public	postgres
2	30035	testxmlschema	postgres

Tables

ID	oid	schemaname	tablename	owner	size
1	27659	public	a	postgres	0 bytes
2	17116	public	a_star	postgres	48 kB
3	16959	public	abstime_tbl	postgres	32 kB
4	17143	public	aggtest	postgres	40 kB
5	17182	public	array_index_op_test	postgres	104 kB
6	17176	public	array_op_test	postgres	64 kB
7	28593	public	arrtest	postgres	16 kB
8	27665	public	b	postgres	8192 bytes
9	17119	public	b_star	postgres	48 kB
10	16920	public	box_tbl	postgres	40 kB
11	27521	public	bprime	postgres	312 kB
12	17173	public	bt_f8_heap	postgres	712 kB
13	17161	public	bt_i4_heap	postgres	632 kB
14	17164	public	bt_name_heap	postgres	1264 kB
15	17167	public	bt_txt_heap	postgres	712 kB
16	27671	public	c	postgres	8192 bytes
17	17125	public	c_star	postgres	48 kB
18	16701	public	char_tbl	postgres	40 kB
19	27290	public	check2_tbl	postgres	48 kB
20	27284	public	check_tbl	postgres	40 kB
21	16935	public	circle_tbl	postgres	48 kB
22	17077	public	city	postgres	0 bytes
23	29788	public	clstr_tst	postgres	112 kB
24	29806	public	clstr_tst_inh	postgres	16 kB
25	29780	public	clstr_tst_s	postgres	24 kB
26	27329	public	copy_tbl	postgres	40 kB
27	27677	public	d	postgres	48 kB
28	17128	public	d_star	postgres	48 kB
29	16938	public	date_tbl	postgres	40 kB
30	27264	public	default_tbl	postgres	48 kB
31	27275	public	defaultexpr_tbl	postgres	40 kB
32	17080	public	dept	postgres	8192 bytes
33	30580	public	domain_test	postgres	8192 bytes
34	30553	public	domcontest	postgres	8192 bytes
35	30546	public	domnotnull	postgres	8192 bytes
36	30559	public	domtab	postgres	8192 bytes
37	40396	public	dropcolumn	postgres	0 bytes
38	40402	public	dropcolumnanother	postgres	0 bytes
39	40399	public	dropcolumnchild	postgres	0 bytes
40	40462	public	dropcolumnexists	postgres	0 bytes
41	17134	public	e_star	postgres	48 kB
42	17059	public	emp	postgres	48 kB
43	17038	public	equipment_r	postgres	48 kB
44	17137	public	f_star	postgres	48 kB
45	17089	public	fast_emp4000	postgres	488 kB
46	16731	public	float4_tbl	postgres	40 kB
47	16734	public	float8_tbl	postgres	32 kB
48	30239	public	found_test_tbl	postgres	8192 bytes
49	27607	public	func_index_heap	postgres	56 kB
50	17158	public	hash_f8_heap	postgres	1784 kB
51	17146	public	hash_i4_heap	postgres	920 kB
52	17149	public	hash_name_heap	postgres	1552 kB
53	17152	public	hash_txt_heap	postgres	1008 kB
54	17032	public	hobbies_r	postgres	48 kB
55	30140	public	hslot	postgres	40 kB
56	30133	public	hub	postgres	32 kB
57	30152	public	iface	postgres	32 kB
58	17098	public	ihighway	postgres	160 kB
59	16968	public	inet_tbl	postgres	48 kB
60	27730	public	inhe	postgres	48 kB
61	27736	public	inhf	postgres	48 kB
62	27723	public	inhx	postgres	16 kB
63	27299	public	insert_tbl	postgres	40 kB
64	16719	public	int2_tbl	postgres	40 kB
65	16722	public	int4_tbl	postgres	40 kB
66	16725	public	int8_tbl	postgres	40 kB
67	16953	public	interval_tbl	postgres	40 kB
68	27530	public	iportaltest	postgres	48 kB
69	27433	public	log_table	postgres	0 bytes
70	40789	public	lotest_stash_values	postgres	0 bytes
71	16917	public	lseg_tbl	postgres	40 kB
72	27437	public	main_table	postgres	32 kB
73	16877	public	money_data	postgres	32 kB
74	30405	public	no_oids	postgres	8192 bytes
75	16755	public	num_data	postgres	40 kB
76	16758	public	num_exp_add	postgres	56 kB
77	16764	public	num_exp_div	postgres	56 kB
78	16773	public	num_exp_ln	postgres	56 kB
79	16776	public	num_exp_log10	postgres	56 kB
80	16767	public	num_exp_mul	postgres	56 kB
81	16779	public	num_exp_power_10_ln	postgres	56 kB
82	16770	public	num_exp_sqrt	postgres	56 kB
83	16761	public	num_exp_sub	postgres	56 kB
84	16808	public	num_input_test	postgres	48 kB
85	16782	public	num_result	postgres	64 kB
86	17044	public	onek	postgres	1632 kB
87	27518	public	onek2	postgres	632 kB
88	16923	public	path_tbl	postgres	48 kB
89	17053	public	person	postgres	48 kB
90	30112	public	pfield	postgres	32 kB
91	30159	public	phone	postgres	32 kB
92	30126	public	pline	postgres	32 kB
93	16914	public	point_tbl	postgres	48 kB
94	16929	public	polygon_tbl	postgres	56 kB
95	30119	public	pslot	postgres	32 kB
96	27524	public	ramp	postgres	96 kB
97	28564	public	random_tbl	postgres	8192 bytes
98	30292	public	rc_test	postgres	8192 bytes
99	17110	public	real_city	postgres	48 kB
100	16962	public	reltime_tbl	postgres	40 kB
101	40405	public	renamecolumn	postgres	0 bytes
102	40411	public	renamecolumnanother	postgres	0 bytes
103	40408	public	renamecolumnchild	postgres	0 bytes
104	17092	public	road	postgres	920 kB
105	30101	public	room	postgres	32 kB
106	28838	public	rtest_admin	postgres	16 kB
107	28985	public	rtest_comp	postgres	16 kB
108	28848	public	rtest_emp	postgres	8192 bytes
109	28851	public	rtest_emplog	postgres	8192 bytes
110	28854	public	rtest_empmass	postgres	8192 bytes
111	28826	public	rtest_interface	postgres	16 kB
112	28915	public	rtest_nothn1	postgres	16 kB
113	28921	public	rtest_nothn2	postgres	8192 bytes
114	28927	public	rtest_nothn3	postgres	16 kB
115	28933	public	rtest_nothn4	postgres	16 kB
116	28900	public	rtest_order1	postgres	0 bytes
117	28903	public	rtest_order2	postgres	16 kB
118	28832	public	rtest_person	postgres	16 kB
119	28820	public	rtest_system	postgres	16 kB
120	28804	public	rtest_t1	postgres	8192 bytes
121	28807	public	rtest_t2	postgres	8192 bytes
122	28810	public	rtest_t3	postgres	8192 bytes
123	28860	public	rtest_t4	postgres	16 kB
124	28866	public	rtest_t5	postgres	16 kB
125	28872	public	rtest_t6	postgres	16 kB
126	28878	public	rtest_t7	postgres	16 kB
127	28884	public	rtest_t8	postgres	16 kB
128	28890	public	rtest_t9	postgres	16 kB
129	28991	public	rtest_unitfact	postgres	8192 bytes
130	28943	public	rtest_view1	postgres	16 kB
131	28949	public	rtest_view2	postgres	8192 bytes
132	28952	public	rtest_view3	postgres	16 kB
133	28958	public	rtest_view4	postgres	16 kB
134	29073	public	rule_and_refint_t1	postgres	24 kB
135	29078	public	rule_and_refint_t2	postgres	24 kB
136	29083	public	rule_and_refint_t3	postgres	32 kB
137	29066	public	ruletest_tbl	postgres	0 bytes
138	29069	public	ruletest_tbl2	postgres	8192 bytes
139	40600	public	serialtest	postgres	16 kB
140	17104	public	shighway	postgres	80 kB
141	28998	public	shoe_data	postgres	8192 bytes
142	29026	public	shoelace_arrive	postgres	8192 bytes
143	29001	public	shoelace_data	postgres	8192 bytes
144	29019	public	shoelace_log	postgres	8192 bytes
145	29029	public	shoelace_ok	postgres	0 bytes
146	17086	public	slow_emp4000	postgres	224 kB
147	17071	public	stud_emp	postgres	48 kB
148	17065	public	student	postgres	48 kB
149	28330	public	subselect_tbl	postgres	8192 bytes
150	30145	public	system	postgres	32 kB
151	17047	public	tenk1	postgres	3856 kB
152	17050	public	tenk2	postgres	3512 kB
153	29961	public	test_tsquery	postgres	40 kB
154	17188	public	test_tsvector	postgres	632 kB
155	16713	public	text_tbl	postgres	48 kB
156	16941	public	time_tbl	postgres	40 kB
157	16947	public	timestamp_tbl	postgres	32 kB
158	16950	public	timestamptz_tbl	postgres	32 kB
159	16944	public	timetz_tbl	postgres	40 kB
160	16965	public	tinterval_tbl	postgres	40 kB
161	29004	public	unit	postgres	8192 bytes
162	16710	public	varchar_tbl	postgres	40 kB
163	30108	public	wslot	postgres	24 kB
164	28517	public	xacttest	postgres	8192 bytes
165	40833	public	xmltest	postgres	16 kB
166	30036	testxmlschema	test1	postgres	16 kB
167	30043	testxmlschema	test2	postgres	16 kB

Indexes

ID	oid	schemaname	tablename	indexname	owner	size
1	27595	public	array_index_op_test	botharrayidx	postgres	40 kB
2	27574	public	bt_f8_heap	bt_f8_index	postgres	240 kB
3	27571	public	bt_i4_heap	bt_i4_index	postgres	240 kB
4	27572	public	bt_name_heap	bt_name_index	postgres	240 kB
5	27573	public	bt_txt_heap	bt_txt_index	postgres	240 kB
6	27580	public	circle_tbl	gcircleind	postgres	8192 bytes
7	29802	public	clstr_tst	clstr_tst_b	postgres	16 kB
8	29805	public	clstr_tst	clstr_tst_b_c	postgres	16 kB
9	29803	public	clstr_tst	clstr_tst_c	postgres	16 kB
10	29804	public	clstr_tst	clstr_tst_c_b	postgres	16 kB
11	29795	public	clstr_tst	clstr_tst_pkey	postgres	16 kB
12	29784	public	clstr_tst_s	clstr_tst_s_pkey	postgres	16 kB
13	27578	public	fast_emp4000	grect2ind	postgres	264 kB
14	27613	public	func_index_heap	func_index_index	postgres	16 kB
15	27599	public	hash_f8_heap	hash_f8_index	postgres	528 kB
16	27614	public	hash_f8_heap	hash_f8_index_1	postgres	240 kB
17	27615	public	hash_f8_heap	hash_f8_index_2	postgres	328 kB
18	27616	public	hash_f8_heap	hash_f8_index_3	postgres	216 kB
19	27596	public	hash_i4_heap	hash_i4_index	postgres	528 kB
20	27597	public	hash_name_heap	hash_name_index	postgres	528 kB
21	27598	public	hash_txt_heap	hash_txt_index	postgres	528 kB
22	30144	public	hslot	hslot_hubname	postgres	16 kB
23	30143	public	hslot	hslot_name	postgres	16 kB
24	30139	public	hub	hub_name	postgres	16 kB
25	30158	public	iface	iface_name	postgres	16 kB
26	27569	public	ihighway	iix	postgres	48 kB
27	27744	public	inhx	inhx_pkey	postgres	8192 bytes
28	16785	public	num_exp_add	num_exp_add_idx	postgres	16 kB
29	16787	public	num_exp_div	num_exp_div_idx	postgres	16 kB
30	16790	public	num_exp_ln	num_exp_ln_idx	postgres	16 kB
31	16791	public	num_exp_log10	num_exp_log10_idx	postgres	16 kB
32	16788	public	num_exp_mul	num_exp_mul_idx	postgres	16 kB
33	16792	public	num_exp_power_10_ln	num_exp_power_10_ln_idx	postgres	16 kB
34	16789	public	num_exp_sqrt	num_exp_sqrt_idx	postgres	16 kB
35	16786	public	num_exp_sub	num_exp_sub_idx	postgres	16 kB
36	27559	public	onek	onek_hundred	postgres	120 kB
37	27560	public	onek	onek_stringu1	postgres	120 kB
38	27557	public	onek	onek_unique1	postgres	128 kB
39	27558	public	onek	onek_unique2	postgres	128 kB
40	27577	public	onek2	onek2_stu1_prtl	postgres	16 kB
41	27575	public	onek2	onek2_u1_prtl	postgres	16 kB
42	27576	public	onek2	onek2_u2_prtl	postgres	16 kB
43	30118	public	pfield	pfield_name	postgres	16 kB
44	30165	public	phone	phone_name	postgres	16 kB
45	30132	public	pline	pline_name	postgres	16 kB
46	27581	public	point_tbl	gpointind	postgres	8192 bytes
47	27579	public	polygon_tbl	gpolygonind	postgres	8192 bytes
48	30125	public	pslot	pslot_name	postgres	16 kB
49	27568	public	road	rix	postgres	312 kB
50	30107	public	room	room_rno	postgres	16 kB
51	29076	public	rule_and_refint_t1	rule_and_refint_t1_pkey	postgres	16 kB
52	29081	public	rule_and_refint_t2	rule_and_refint_t2_pkey	postgres	16 kB
53	29089	public	rule_and_refint_t3	rule_and_refint_t3_pkey	postgres	16 kB
54	27570	public	shighway	six	postgres	16 kB
55	30151	public	system	system_name	postgres	16 kB
56	27563	public	tenk1	tenk1_hundred	postgres	240 kB
57	27564	public	tenk1	tenk1_thous_tenthous	postgres	240 kB
58	27561	public	tenk1	tenk1_unique1	postgres	240 kB
59	27562	public	tenk1	tenk1_unique2	postgres	240 kB
60	27567	public	tenk2	tenk2_hundred	postgres	240 kB
61	27565	public	tenk2	tenk2_unique1	postgres	240 kB
62	27566	public	tenk2	tenk2_unique2	postgres	240 kB
63	29967	public	test_tsquery	bt_tsq	postgres	16 kB
64	29968	public	test_tsquery	qq	postgres	8192 bytes
65	29960	public	test_tsvector	wowidx	postgres	392 kB
66	30111	public	wslot	wslot_name	postgres	16 kB

Views

ID	oid	schemaname	viewname	owner
1	30563	public	domview	postgres
2	28110	public	iexit	postgres
3	30234	public	pfield_v1	postgres
4	28813	public	rtest_v1	postgres
5	28994	public	rtest_vcomp	postgres
6	28964	public	rtest_vview1	postgres
7	28968	public	rtest_vview2	postgres
8	28972	public	rtest_vview3	postgres
9	28976	public	rtest_vview4	postgres
10	28981	public	rtest_vview5	postgres
11	29007	public	shoe	postgres
12	29015	public	shoe_ready	postgres
13	29011	public	shoelace	postgres
14	29037	public	shoelace_candelete	postgres
15	29033	public	shoelace_obsolete	postgres
16	28106	public	street	postgres
17	28114	public	toyemp	postgres
18	40839	public	xmlview1	postgres
19	40843	public	xmlview2	postgres
20	40847	public	xmlview3	postgres
21	40851	public	xmlview4	postgres
22	40855	public	xmlview5	postgres
23	40859	public	xmlview6	postgres
24	40863	public	xmlview7	postgres
25	40867	public	xmlview8	postgres
26	40871	public	xmlview9	postgres

Sequeces

ID	oid	schemaname	sequencename
1	27288	public	check_seq
2	29786	public	clstr_tst_a_seq
3	29778	public	clstr_tst_s_rf_a_seq
4	27273	public	default_seq
5	27297	public	insert_seq
6	28909	public	rtest_seq
7	40623	public	sequence_test2
8	40598	public	serialtest_f2_foo

Triggers

ID	schemaname	tablename	triggername

Management Information

Roles

ID	oid	rolname	rolinherit	rolcreaterole	rolcreatedb	rolcatupdate	rolcanlogin	rolconnlimit	rolvaliduntil	rolconfig
1	10	postgres	t	t	t	t	t	-1

Setting Parameters

Only non-default parameters are listed below.

ID	name	setting	unit	source
1	application_name	pg_reporter		client
2	default_text_search_config	pg_catalog.english		configuration file
3	lc_messages	C		database
4	log_autovacuum_min_duration	0	ms	configuration file
5	log_checkpoints	on		configuration file
6	log_timezone	Japan		command line
7	max_stack_depth	2048	kB	environment variable
8	pg_statsinfo.textlog_min_messages	debug		configuration file
9	shared_buffers	4096	8kB	configuration file
10	shared_preload_libraries	pg_statsinfo, pg_stat_statements		configuration file
11	TimeZone	Japan		command line
12	timezone_abbreviations	Default		database
13	track_functions	all		configuration file