This repository was archived by the owner on Mar 31, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathSystemCatalogReference.html
More file actions
704 lines (628 loc) · 257 KB
/
SystemCatalogReference.html
File metadata and controls
704 lines (628 loc) · 257 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<!-- Always force latest IE rendering engine or request Chrome Frame -->
<meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
<!-- REPLACE X WITH PRODUCT NAME -->
<title>System Catalog Reference | Pivotal Docs</title>
<!-- Local CSS stylesheets -->
<link href="/stylesheets/master.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/breadcrumbs.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/search.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/portal-style.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/printable.css" media="print" rel="stylesheet" type="text/css" />
<!-- Confluence HTML stylesheet -->
<link href="/stylesheets/site-conf.css" media="screen,print" rel="stylesheet" type="text/css" />
<!-- Left-navigation code -->
<!-- http://www.designchemical.com/lab/jquery-vertical-accordion-menu-plugin/examples/# -->
<link href="/stylesheets/dcaccordion.css" rel="stylesheet" type="text/css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<script src="/javascripts/jquery.cookie.js" type="text/javascript"></script>
<script src="/javascripts/jquery.hoverIntent.minified.js" type="text/javascript"></script>
<script src="/javascripts/jquery.dcjqaccordion.2.7.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function($){
$('#accordion-1').dcAccordion({
eventType: 'click',
autoClose: true,
saveState: true,
disableLink: false,
speed: 'fast',
classActive: 'test',
showCount: false
});
});
</script>
<link href="/stylesheets/grey.css" rel="stylesheet" type="text/css" />
<!-- End left-navigation code -->
<script src="/javascripts/all.js" type="text/javascript"></script>
<link href='http://www.gopivotal.com/misc/favicon.ico' rel='shortcut icon'>
<script type="text/javascript">
if (window.location.host === 'docs.gopivotal.com') {
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-39702075-1']);
_gaq.push(['_setDomainName', 'gopivotal.com']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
}
</script>
</head>
<body class="pivotalcf pivotalcf_getstarted pivotalcf_getstarted_index">
<div class="viewport">
<div class="mobile-navigation--wrapper mobile-only">
<div class="navigation-drawer--container">
<div class="navigation-item-list">
<div class="navbar-link active">
<a href="http://gopivotal.com">
Home
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/paas">
PaaS
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/big-data">
Big Data
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/agile">
Agile
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/support">
Help & Support
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/products">
Products
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/solutions">
Solutions
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/partners">
Partners
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
</div>
</div>
<div class="mobile-nav">
<div class="nav-icon js-open-nav-drawer">
<i class="icon-reorder"></i>
</div>
<div class="header-center-icon">
<a href="http://gopivotal.com">
<div class="icon icon-pivotal-logo-mobile"></div>
</a>
</div>
</div>
</div>
<div class='wrap'>
<script src="//use.typekit.net/clb0qji.js" type="text/javascript"></script>
<script type="text/javascript">
try {
Typekit.load();
} catch (e) {
}
</script>
<script type="text/javascript">
document.domain = "gopivotal.com";
</script>
<script type="text/javascript">
WebFontConfig = {
google: { families: [ 'Source+Sans+Pro:300italic,400italic,600italic,300,400,600:latin' ] }
};
(function() {
var wf = document.createElement('script');
wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
'://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
wf.type = 'text/javascript';
wf.async = 'true';
var s = document.getElementsByTagName('script')[0];
s.parentNode.insertBefore(wf, s);
})(); </script>
<div id="search-dropdown-box">
<div class="search-dropdown--container js-search-dropdown">
<div class="container-fluid">
<div class="close-menu-large"><img src="http://www.gopivotal.com/sites/all/themes/gopo13/images/icon-close.png" /></div>
<div class="search-form--container">
<div class="form-search">
<div class='gcse-search'></div>
<script src="http://www.google.com/jsapi" type="text/javascript"></script>
<script src="/javascripts/cse.js" type="text/javascript"></script>
</div>
</div>
</div>
</div>
</div>
<header class="navbar desktop-only" id="nav">
<div class="navbar-inner">
<div class="container-fluid">
<div class="pivotal-logo--container">
<a class="pivotal-logo" href="http://gopivotal.com"><span></span></a>
</div>
<ul class="nav pull-right">
<li class="navbar-link">
<a href="http://www.gopivotal.com/paas" id="paas-nav-link">PaaS</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/big-data" id="big-data-nav-link">BIG DATA</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/agile" id="agile-nav-link">AGILE</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/oss" id="oss-nav-link">OSS</a>
</li>
<li class="nav-search">
<a class="js-search-input-open" id="click-to-search"><span></span></a>
</li>
</ul>
</div>
<a href="http://www.gopivotal.com/contact">
<img id="get-started" src="http://www.gopivotal.com/sites/all/themes/gopo13/images/get-started.png">
</a>
</div>
</header>
<div class="main-wrap">
<div class="container-fluid">
<!-- Google CSE Search Box -->
<div id='docs-search'>
<gcse:search></gcse:search>
</div>
<div id='all-docs-link'>
<a href="http://docs.gopivotal.com/">All Documentation</a>
</div>
<div class="container">
<div id="sub-nav" class="nav-container">
<!-- Collapsible left-navigation-->
<ul class="accordion" id="accordion-1">
<!-- REPLACE <li/> NODES-->
<li>
<a href="index.html">Home</a></br>
<li>
<a href="PivotalHD.html">Pivotal HD 2.0.1</a>
<ul>
<li>
<a href="PHDEnterprise2.0.1ReleaseNotes.html">PHD Enterprise 2.0.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="PHDInstallationandAdministration.html">PHD Installation and Administration</a>
<ul>
<li>
<a href="OverviewofPHD.html">Overview of PHD</a>
</li>
</ul>
<ul>
<li>
<a href="InstallationOverview.html">Installation Overview</a>
</li>
</ul>
<ul>
<li>
<a href="PHDInstallationChecklist.html">PHD Installation Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingPHDUsingtheCLI.html">Installing PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradeChecklist.html">Upgrade Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradingPHDUsingtheCLI.html">Upgrading PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="AdministeringPHDUsingtheCLI.html">Administering PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="PHDFAQFrequentlyAskedQuestions.html">PHD FAQ (Frequently Asked Questions)</a>
</li>
</ul>
<ul>
<li>
<a href="PHDTroubleshooting.html">PHD Troubleshooting</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="StackandToolsReference.html">Stack and Tools Reference</a>
<ul>
<li>
<a href="OverviewofApacheStackandPivotalComponents.html">Overview of Apache Stack and Pivotal Components</a>
</li>
</ul>
<ul>
<li>
<a href="ManuallyInstallingPivotalHD2.0Stack.html">Manually Installing Pivotal HD 2.0 Stack</a>
</li>
</ul>
<ul>
<li>
<a href="ManuallyUpgradingPivotalHDStackfrom1.1.1to2.0.html">Manually Upgrading Pivotal HD Stack from 1.1.1 to 2.0</a>
</li>
</ul>
<ul>
<li>
<a href="PivotalHadoopEnhancements.html">Pivotal Hadoop Enhancements</a>
</li>
</ul>
<ul>
<li>
<a href="Security.html">Security</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="PivotalCommandCenter.html">Pivotal Command Center 2.2.1</a>
<ul>
<li>
<a href="PCC2.2.1ReleaseNotes.html">PCC 2.2.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="PCCUserGuide.html">PCC User Guide</a>
<ul>
<li>
<a href="PCCOverview.html">PCC Overview</a>
</li>
</ul>
<ul>
<li>
<a href="PCCInstallationChecklist.html">PCC Installation Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingPCC.html">Installing PCC</a>
</li>
</ul>
<ul>
<li>
<a href="UsingPCC.html">Using PCC</a>
</li>
</ul>
<ul>
<li>
<a href="CreatingaYUMEPELRepository.html">Creating a YUM EPEL Repository</a>
</li>
</ul>
<ul>
<li>
<a href="CommandLineReference.html">Command Line Reference</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="PivotalHAWQ.html">Pivotal HAWQ 1.2.0</a>
<ul>
<li>
<a href="HAWQ1.2.0.1ReleaseNotes.html">HAWQ 1.2.0.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQInstallationandUpgrade.html">HAWQ Installation and Upgrade</a>
<ul>
<li>
<a href="PreparingtoInstallHAWQ.html">Preparing to Install HAWQ</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingHAWQ.html">Installing HAWQ</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingtheHAWQComponents.html">Installing the HAWQ Components</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradingHAWQandComponents.html">Upgrading HAWQ and Components</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQConfigurationParameterReference.html">HAWQ Configuration Parameter Reference</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="HAWQAdministration.html">HAWQ Administration</a>
<ul>
<li>
<a href="HAWQOverview.html">HAWQ Overview</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQQueryProcessing.html">HAWQ Query Processing</a>
</li>
</ul>
<ul>
<li>
<a href="UsingHAWQtoQueryData.html">Using HAWQ to Query Data</a>
</li>
</ul>
<ul>
<li>
<a href="ConfiguringClientAuthentication.html">Configuring Client Authentication</a>
</li>
</ul>
<ul>
<li>
<a href="KerberosAuthentication.html">Kerberos Authentication</a>
</li>
</ul>
<ul>
<li>
<a href="ExpandingtheHAWQSystem.html">Expanding the HAWQ System</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQInputFormatforMapReduce.html">HAWQ InputFormat for MapReduce</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQFilespacesandHighAvailabilityEnabledHDFS.html">HAWQ Filespaces and High Availability Enabled HDFS</a>
</li>
</ul>
<ul>
<li>
<a href="SQLCommandReference.html">SQL Command Reference</a>
</li>
</ul>
<ul>
<li>
<a href="ManagementUtilityReference.html">Management Utility Reference</a>
</li>
</ul>
<ul>
<li>
<a href="ClientUtilityReference.html">Client Utility Reference</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQServerConfigurationParameters.html">HAWQ Server Configuration Parameters</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQEnvironmentVariables.html">HAWQ Environment Variables</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQDataTypes.html">HAWQ Data Types</a>
</li>
</ul>
<ul>
<li>
<a href="SystemCatalogReference.html">System Catalog Reference</a>
</li>
</ul>
<ul>
<li>
<a href="hawq_toolkitReference.html">hawq_toolkit Reference</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="PivotalExtensionFrameworkPXF.html">Pivotal Extension Framework (PXF)</a>
<ul>
<li>
<a href="PXFInstallationandAdministration.html">PXF Installation and Administration</a>
</li>
</ul>
<ul>
<li>
<a href="PXFExternalTableandAPIReference.html">PXF External Table and API Reference</a>
</li>
</ul>
</div><!--end of sub-nav-->
<h3 class="title-container">System Catalog Reference</h3>
<div class="content">
<!-- Python script replaces main content -->
<div id ="main"><div style="visibility:hidden; height:2px;">Pivotal Product Documentation : System Catalog Reference</div><div class="wiki-content group" id="main-content">
<p align="LEFT">This is a reference of the system catalog tables and views of the HAWQ Database. All system tables related to the parallel features of HAWQ are prefixed with <em>gp_</em><span style="font-size: medium;"> </span>. Tables prefixed with <em>pg_ </em><span style="font-size: medium;"> </span>are either standard PostgreSQL system catalog tables (also used in HAWQ Database), or are related to features HAWQ has added to enhance PostgreSQL for data warehousing workloads. Note that the global system catalog for HAWQ resides on the master instance.</p><p align="LEFT"><style type="text/css">/*<![CDATA[*/
div.rbtoc1400035796157 {padding: 0px;}
div.rbtoc1400035796157 ul {list-style: disc;margin-left: 0px;}
div.rbtoc1400035796157 li {margin-left: 0px;padding-left: 0px;}
/*]]>*/</style><div class="toc-macro rbtoc1400035796157">
<ul class="toc-indentation">
<li><a href="#SystemCatalogReference-gp_configuration_history">gp_configuration_history </a></li>
<li><a href="#SystemCatalogReference-gp_distributed_log">gp_distributed_log </a></li>
<li><a href="#SystemCatalogReference-gp_distributed_xacts">gp_distributed_xacts </a></li>
<li><a href="#SystemCatalogReference-gp_distribution_policy">gp_distribution_policy </a></li>
<li><a href="#SystemCatalogReference-gpexpand.expansion_progress">gpexpand.expansion_progress</a></li>
<li><a href="#SystemCatalogReference-gpexpand.status">gpexpand.status</a></li>
<li><a href="#SystemCatalogReference-gpexpand.status_detail">gpexpand.status_detail</a></li>
<li><a href="#SystemCatalogReference-gp_fastsequence">gp_fastsequence </a></li>
<li><a href="#SystemCatalogReference-gp_fault_strategy">gp_fault_strategy </a></li>
<li><a href="#SystemCatalogReference-gp_global_sequence">gp_global_sequence </a></li>
<li><a href="#SystemCatalogReference-gp_id">gp_id </a></li>
<li><a href="#SystemCatalogReference-gp_interfaces">gp_interfaces </a></li>
<li><a href="#SystemCatalogReference-gp_master_mirroring">gp_master_mirroring </a></li>
<li><a href="#SystemCatalogReference-gp_persistent_database_node">gp_persistent_database_node </a></li>
<li><a href="#SystemCatalogReference-gp_persistent_filespace_node">gp_persistent_filespace_node </a></li>
<li><a href="#SystemCatalogReference-gp_persistent_relation_node">gp_persistent_relation_node </a></li>
<li><a href="#SystemCatalogReference-gp_persistent_tablespace_node">gp_persistent_tablespace_node</a></li>
<li><a href="#SystemCatalogReference-gp_pgdatabase">gp_pgdatabase</a></li>
<li><a href="#SystemCatalogReference-gp_relation_node">gp_relation_node</a></li>
<li><a href="#SystemCatalogReference-gp_resqueue_status">gp_resqueue_status</a></li>
<li><a href="#SystemCatalogReference-gp_san_configuration">gp_san_configuration</a></li>
<li><a href="#SystemCatalogReference-gp_segment_configuration">gp_segment_configuration</a></li>
<li><a href="#SystemCatalogReference-gp_transaction_log">gp_transaction_log</a></li>
<li><a href="#SystemCatalogReference-gp_version_at_initdb">gp_version_at_initdb</a></li>
<li><a href="#SystemCatalogReference-pg_aggregate">pg_aggregate</a></li>
<li><a href="#SystemCatalogReference-pg_am">pg_am</a></li>
<li><a href="#SystemCatalogReference-pg_amop">pg_amop</a></li>
<li><a href="#SystemCatalogReference-pg_amproc">pg_amproc</a></li>
<li><a href="#SystemCatalogReference-pg_appendonly">pg_appendonly</a></li>
<li><a href="#SystemCatalogReference-pg_attrdef">pg_attrdef</a></li>
<li><a href="#SystemCatalogReference-pg_attribute">pg_attribute</a></li>
<li><a href="#SystemCatalogReference-pg_attribute_encoding">pg_attribute_encoding</a></li>
<li><a href="#SystemCatalogReference-pg_auth_members">pg_auth_members</a></li>
<li><a href="#SystemCatalogReference-pg_authid">pg_authid</a></li>
<li><a href="#SystemCatalogReference-pg_cast">pg_cast</a></li>
<li><a href="#SystemCatalogReference-pg_class">pg_class</a></li>
<li><a href="#SystemCatalogReference-pg_compression">pg_compression</a></li>
<li><a href="#SystemCatalogReference-pg_class.1">pg_class</a></li>
<li><a href="#SystemCatalogReference-pg_conversion">pg_conversion</a></li>
<li><a href="#SystemCatalogReference-pg_database">pg_database</a></li>
<li><a href="#SystemCatalogReference-pg_depend">pg_depend</a></li>
<li><a href="#SystemCatalogReference-pg_description">pg_description</a></li>
<li><a href="#SystemCatalogReference-pg_exttable">pg_exttable</a></li>
<li><a href="#SystemCatalogReference-pg_filespace">pg_filespace</a></li>
<li><a href="#SystemCatalogReference-pg_filespace_entry">pg_filespace_entry</a></li>
<li><a href="#SystemCatalogReference-pg_index">pg_index</a></li>
<li><a href="#SystemCatalogReference-pg_inherits">pg_inherits</a></li>
<li><a href="#SystemCatalogReference-pg_language">pg_language</a></li>
<li><a href="#SystemCatalogReference-pg_largeobject">pg_largeobject</a></li>
<li><a href="#SystemCatalogReference-pg_locks">pg_locks</a></li>
<li><a href="#SystemCatalogReference-pg_opclass">pg_opclass</a></li>
<li><a href="#SystemCatalogReference-pg_namespace">pg_namespace</a></li>
<li><a href="#SystemCatalogReference-pg_operator">pg_operator</a></li>
<li><a href="#SystemCatalogReference-pg_partition">pg_partition</a></li>
<li><a href="#SystemCatalogReference-pg_partition_columns">pg_partition_columns</a></li>
<li><a href="#SystemCatalogReference-pg_partition_encoding">pg_partition_encoding</a></li>
<li><a href="#SystemCatalogReference-pg_partition_rule">pg_partition_rule</a></li>
<li><a href="#SystemCatalogReference-pg_partition_templates">pg_partition_templates</a></li>
<li><a href="#SystemCatalogReference-pg_partitions">pg_partitions</a></li>
<li><a href="#SystemCatalogReference-pg_pltemplate">pg_pltemplate</a></li>
<li><a href="#SystemCatalogReference-pg_proc">pg_proc</a></li>
<li><a href="#SystemCatalogReference-pg_resourcetype">pg_resourcetype</a></li>
<li><a href="#SystemCatalogReference-pg_resqueue">pg_resqueue</a></li>
<li><a href="#SystemCatalogReference-pg_resqueue_attributes">pg_resqueue_attributes</a></li>
<li><a href="#SystemCatalogReference-pg_resqueuecapability">pg_resqueuecapability</a></li>
<li><a href="#SystemCatalogReference-pg_rewrite">pg_rewrite</a></li>
<li><a href="#SystemCatalogReference-pg_roles">pg_roles</a></li>
<li><a href="#SystemCatalogReference-pg_shdepend">pg_shdepend</a></li>
<li><a href="#SystemCatalogReference-pg_shdescription">pg_shdescription</a></li>
<li><a href="#SystemCatalogReference-pg_stat_activity">pg_stat_activity</a></li>
<li><a href="#SystemCatalogReference-pg_stat_last_operation">pg_stat_last_operation</a></li>
<li><a href="#SystemCatalogReference-pg_stat_last_shoperation">pg_stat_last_shoperation</a></li>
<li><a href="#SystemCatalogReference-pg_stat_operations">pg_stat_operations</a></li>
<li><a href="#SystemCatalogReference-pg_stat_partition_operations">pg_stat_partition_operations</a></li>
<li><a href="#SystemCatalogReference-pg_statistic">pg_statistic</a></li>
<li><a href="#SystemCatalogReference-pg_stat_resqueues">pg_stat_resqueues</a></li>
<li><a href="#SystemCatalogReference-pg_tablespace">pg_tablespace</a></li>
<li><a href="#SystemCatalogReference-pg_trigger">pg_trigger</a></li>
<li><a href="#SystemCatalogReference-pg_type">pg_type</a></li>
<li><a href="#SystemCatalogReference-pg_type_encoding">pg_type_encoding</a></li>
<li><a href="#SystemCatalogReference-pg_user_mapping">pg_user_mapping</a></li>
<li><a href="#SystemCatalogReference-pg_window">pg_window</a></li>
</ul>
</div></p><h2 id="SystemCatalogReference-gp_configuration_history">gp_configuration_history </h2><p>The gp_configuration_history table contains information about system changes related to fault detection and recovery operations. The fts_probe process logs data to this table, as do certain related management utilities such as gpcheck, gprecoverseg, and gpinitsystem. For example, when you add a new segment and mirror segment to the system, records for these events are logged to gp_configuration_history.</p><p>The event descriptions stored in this table may be helpful for troubleshooting serious system issues in collaboration with Pivotal support technicians.</p><p>This table is populated only on the master. This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">time</td><td class="confluenceTd">timestamp with time zone</td><td class="confluenceTd"> </td><td class="confluenceTd">Timestamp for the event recorded.</td></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">amllint</td><td class="confluenceTd">gp_segment_configuration.dbid</td><td class="confluenceTd">System-assigned ID. The unique identifier of a segment (or master) instance.</td></tr><tr><td class="confluenceTd">desc</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">Text description of the event.</td></tr></tbody></table></div><p>For information about <span>gprecoverseg</span>, see Management Utility Reference.</p><h2 id="SystemCatalogReference-gp_distributed_log">gp_distributed_log </h2><p>The gp_distributed_log view contains status information about distributed transactions and their associated local transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. HAWQ’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the status of distributed transactions.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">segment_id</td><td class="confluenceTd">smallint</td><td class="confluenceTd">gp_segment_configuration.content</td><td class="confluenceTd">The content id of the segment. The master is always -1 (no content)</td></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">small_int</td><td class="confluenceTd"><span>gp_segment_configuration.dbid</span></td><td class="confluenceTd">The unique id of the segment instance.</td></tr><tr><td class="confluenceTd">distributed_xid</td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd">The gloabl transaction id.</td></tr><tr><td class="confluenceTd">distributed_id</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">A system assigned ID for a distributed transaction (Committed or Aborted)</td></tr><tr><td class="confluenceTd">local_transaction</td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd">The local transaction ID.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_distributed_xacts">gp_distributed_xacts </h2><p>The gp_distributed_xacts view contains information about HAWQ distributed transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. HAWQ’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the currently active sessions and their associated distributed transactions.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Typ</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">distributed_xid</td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd">The transaction ID used by the distributed transaction across the HAWQ array.</td></tr><tr><td class="confluenceTd">distributed_id</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">The distributed transaction identifier. It has 2 parts - a unique timestamp and the distributed transaction number.</td></tr><tr><td class="confluenceTd">state</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">The current state of this session with regards to distributed transactions.</td></tr><tr><td class="confluenceTd">gp_session_id</td><td class="confluenceTd">int</td><td class="confluenceTd"> </td><td class="confluenceTd">The ID number of the HAWQ database session associated with the transaction.</td></tr><tr><td class="confluenceTd">xmin_distributed_snapshot</td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd">The minimum distributed transaction number found among all open transactions when this transaction was started. It is used for MVCC distributed snapshot purposes.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_distribution_policy">gp_distribution_policy </h2><p>The gp_distribution_policy table contains information about HAWQ tables and their policy for distributing table data across the segments. This table is populated only on the master. This table is not globally shared, meaning each database has its own copy of this table.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">localoid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class>oid</td><td class="confluenceTd">The table object identifier (OID).</td></tr><tr><td class="confluenceTd">attrmums</td><td class="confluenceTd">smallint[]</td><td class="confluenceTd">pg_atrribute.attnum</td><td class="confluenceTd">The column number(s) of the distribution column(s).</td></tr></tbody></table></div><h2 id="SystemCatalogReference-gpexpand.expansion_progress">gpexpand.expansion_progress</h2><p>The <em>gpexpand.expansion_progress </em><span> </span>view contains information about the status of a system expansion operation. The view provides calculations of the estimated rate of table redistribution and estimated time to completion.</p><p>Status for specific tables involved in the expansion is stored in <em>gpexpand.status_detail.</em></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">name</td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">Name for the data field provided Includes:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="theme: Confluence; brush: java; gutter: false" style="font-size:12px;">Bytes Left
Bytes Done
Estimated Expansion Rate
Estimated Time to Completion
Tables Expanded
Tables Left</pre>
</div></div></td></tr><tr><td class="confluenceTd">value</td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The value for the progress data. For example:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="theme: Confluence; brush: java; gutter: false" style="font-size:12px;">Estimated Expansion Rate - 9.75667095996092 MB/s </pre>
</div></div></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gpexpand.status">gpexpand.status</h2><p>The <em>gpexpand.status </em><span style="font-size: medium;"> </span>table contains information about the status of a system expansion operation. Status for specific tables involved in the expansion is stored in <em>gpexpand.status_detail</em><span style="font-size: medium;"> </span>.</p><p>In a normal expansion operation it is not necessary to modify the data stored in this table.</p><p><strong>Table: gpexpand.status</strong></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">status</td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">Tracks the status of an expansion operation. Valid values are:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="theme: Confluence; brush: java; gutter: false" style="font-size:12px;">SETUP
SETUP DONE
EXPANSION STARTED
EXPANSION STOPPED
COMPLETED</pre>
</div></div></td></tr><tr><td class="confluenceTd">updated</td><td class="confluenceTd">timestamp with timezone</td><td class="confluenceTd"><p align="LEFT">Timestamp of the last change in status. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gpexpand.status_detail">gpexpand.status_detail</h2><p>The <em>gpexpand.status_detail </em><span style="font-size: medium;"> </span>table contains information about the status of tables involved in a system expansion operation. You can query this table to determine the status of tables being expanded, or to view the start and end time for completed tables.</p><p>This table also stores related information about the table such as the oid, disk size, and normal distribution policy and key. Overall status information for the expansion is stored in <em>gpexpand.status</em><span style="font-size: medium;"> </span>.</p><p>In a normal expansion operation it is not necessary to modify the data stored in this table.</p><p><strong>Table: gpexpand.status_detail</strong></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">dbname</td><td class="confluenceTd"><p>text</p></td><td class="confluenceTd"><p align="LEFT">Name of the database to which the table belongs.</p></td></tr><tr><td class="confluenceTd">fq_name</td><td class="confluenceTd"><p>text</p></td><td class="confluenceTd"><p align="LEFT">Fully qualified name of the table.</p></td></tr><tr><td class="confluenceTd"> schema_oid</td><td class="confluenceTd">oid </td><td class="confluenceTd"><p align="LEFT">OID for the schema of the database to which the table belongs. </p></td></tr><tr><td class="confluenceTd">table_oid </td><td class="confluenceTd">oid </td><td class="confluenceTd">OID of the table </td></tr><tr><td class="confluenceTd">distribution_policy </td><td class="confluenceTd">smallint() </td><td class="confluenceTd">Array of column IDs for the distribution key of the table. </td></tr><tr><td class="confluenceTd">distribution_policy_names </td><td class="confluenceTd">text </td><td class="confluenceTd">Column names for the hash distribution key. </td></tr><tr><td class="confluenceTd">distribution_policy_coloids </td><td class="confluenceTd">text </td><td class="confluenceTd">Column IDs for the distribution keys of the table. </td></tr><tr><td class="confluenceTd">storage_options </td><td class="confluenceTd">text </td><td class="confluenceTd">Not enabled in this release. Do not update this field. </td></tr><tr><td class="confluenceTd">rank </td><td class="confluenceTd">int </td><td class="confluenceTd"><p align="LEFT">Rank determines the order in which tables are expanded. The expansion utility will sort on rank and expand the lowest-ranking tables first. </p></td></tr><tr><td class="confluenceTd">status </td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">Status of expansion for this table. Valid values are:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="theme: Confluence; brush: java; gutter: false" style="font-size:12px;">NOT STARTED
IN PROGRESS
FINISHED </pre>
</div></div></td></tr><tr><td class="confluenceTd">last updated </td><td class="confluenceTd">timestamp with time zone</td><td class="confluenceTd"><p align="LEFT">Timestamp of the last change in status for this table. </p></td></tr><tr><td class="confluenceTd">expansion started </td><td class="confluenceTd">timestamp with time zone </td><td class="confluenceTd"><p align="LEFT">Timestamp for the start of the expansion of this table. This field is only populated after a table is successfully expanded. </p></td></tr><tr><td class="confluenceTd">expansion finished </td><td class="confluenceTd">timestamp with time zone </td><td class="confluenceTd"><p align="LEFT">Timestamp for the completion of expansion of this table</p></td></tr><tr><td class="confluenceTd">source bytes </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The size of disk space associated with the source table. Due to table bloat in heap tables and differing numbers of segments after expansion, it is not expected that the final number of bytes will equal the source number. This information is tracked to help provide progress measurement to aid in duration estimation for the end-to-end expansion operation.</p><p align="LEFT"> </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_fastsequence">gp_fastsequence </h2><p>The gp_fastsequence table contains information about indexes on append-only column-oriented tables. It is used to track the maximum row number used by a file segment of an append-only column-oriented table.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">objid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">Object ID of the pg_aoseg.pg_aocsseq_*table used to track append-only file segments.</td></tr><tr><td class="confluenceTd">objmod</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd">Object modifier.</td></tr><tr><td class="confluenceTd">last_sequence</td><td class="confluenceTd">bihint</td><td class="confluenceTd"> </td><td class="confluenceTd">The last sequence number used by the object.</td></tr><tr><td class="confluenceTd" colspan="1">contentid</td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_fault_strategy">gp_fault_strategy </h2><p>The gp_fault_strategy table specifies the fault action.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">fault_strategy</td><td class="confluenceTd">char</td><td class="confluenceTd"><p>The mirror failover action to take when a segment failure occurs:<br/>n = nothing.<br/>f = file-based failover.<br/>s = SAN-based failover. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_global_sequence">gp_global_sequence </h2><p>The gp_global_sequence table contains the log sequence number position in the transaction log, which is used by the file replication process to determine the file blocks to replicate from a primary to a mirror segment. </p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><span style="color: rgb(0,102,0);">Column</span></th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">sequence_num</td><td class="confluenceTd">bigint</td><td class="confluenceTd">log sequence number position in the transaction log.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_id">gp_id </h2><p>The gp_id system catalog table identifies the HAWQ system name and number of segments for the system. It also has local values for the particular database instance (segment or master) on which the table resides. This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">gpname</td><td class="confluenceTd">name</td><td class="confluenceTd">The name of the HAWQ database system.</td></tr><tr><td class="confluenceTd">numsegments</td><td class="confluenceTd">integer</td><td class="confluenceTd"><span>The number of segments in the HAWQ Database system.</span></td></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">integer</td><td class="confluenceTd"><span>The unique identifier of this segment (or master) instance.</span></td></tr><tr><td class="confluenceTd">content</td><td class="confluenceTd">integer</td><td class="confluenceTd"><p>The ID for the portion of data on this segment instance. A primary and its mirror will have the same content ID.</p><p>For a segment the value is from 0-<em>N</em>, where <em>N </em>is the number of segments in the HAWQ Database.</p><p>For the master, the value is -1. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_interfaces">gp_interfaces </h2><p>The gp_interfaces table contains information about network interfaces on segment hosts. This information, joined with data from gp_db_interfaces, is used by the system to optimize the usage of available network interfaces for various purposes, including fault detection.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">interfaceid</td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p>System-assigned ID. The unique identifier of a network interface.</p></td></tr><tr><td class="confluenceTd">address</td><td class="confluenceTd">name</td><td class="confluenceTd"><p>Hostname address for the segment host containing the network interface. Can be a numeric IP address or a hostname.</p></td></tr><tr><td class="confluenceTd">status</td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p>Status for the network interface. A value of <span>0 </span>indicates that the interface is unavailable. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_master_mirroring">gp_master_mirroring </h2><p>The gp_master_mirroring table contains state information about the standby master host and its associated write-ahead log (WAL) replication process. If this synchronization process (gpsyncagent) fails on the standby master, it may not always be noticeable to users of the system. This catalog is a place where HAWQ administrators can check to see if the standby master is current and fully synchronized.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">summary_state</td><td class="confluenceTd">text</td><td class="confluenceTd"><p>The current state of the log replication process between the master and standby master - logs are either ‘Synchronized’ or ‘Not Synchronized’</p></td></tr><tr><td class="confluenceTd">detail_state</td><td class="confluenceTd">text</td><td class="confluenceTd"><p>If not synchronized, this column will have information about the cause of the error.</p></td></tr><tr><td class="confluenceTd">log_time</td><td class="confluenceTd">timestampz</td><td class="confluenceTd"><p>This contains the timestamp of the last time the master sent its logs to the standby master.</p></td></tr><tr><td class="confluenceTd">error_message</td><td class="confluenceTd">text</td><td class="confluenceTd"><p>If not synchronized, this column will have the error message from the failed synchronization attempt. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_persistent_database_node">gp_persistent_database_node </h2><p>The gp_persistent_database_node table keeps track of the status of file system objects in relation to the transaction status of database objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process.Table 3.14 pg_catalog.gp_persistent_database.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd" colspan="1">contentid</td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">tablespace_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_tablespace.oid</td><td class="confluenceTd">Table space object id.</td></tr><tr><td class="confluenceTd">database_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_database.oid</td><td class="confluenceTd">Database object id.</td></tr><tr><td class="confluenceTd">persistent_state</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>0 - free<br/>1 - create pending<br/>2 - created<br/>3 - drop pending<br/>4 - aborting create<br/>5 - “Just in Time” create pending<br/>6 - bulk load create pending</p></td></tr><tr><td class="confluenceTd" colspan="1">create_mirror_data_loss_tracking_session_num</td><td class="confluenceTd" colspan="1">bigint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">mirror_existence_state</td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">reserved</td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">parent_xid</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd">Global transaction id.</td></tr><tr><td class="confluenceTd">persistent_serial_num</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd"><span>Log sequence number position in the transaction log for a fiel block.</span></td></tr><tr><td class="confluenceTd">previous_free_tid</td><td class="confluenceTd">tid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Used by HAWQ to internally manage persistent representations of file system objects. </p></td></tr><tr><td class="confluenceTd" colspan="1">shared_storage</td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_persistent_filespace_node">gp_persistent_filespace_node </h2><p>The gp_persistent_filespace_node table keeps track of the status of file system objects in relation to the transaction status of filespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">filespace_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_filespace.oid</td><td class="confluenceTd">Object id of the filespace.</td></tr><tr><td class="confluenceTd" colspan="1">contentid </td><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">db_id_1</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd">Primary segment id.</td></tr><tr><td class="confluenceTd">location_1</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">Primary filesystem location.</td></tr><tr><td class="confluenceTd">db_id_2</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><span>Mirror segment id.</span></td></tr><tr><td class="confluenceTd">location_2</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd">Mirror filesystem location.</td></tr><tr><td class="confluenceTd">persistent_state</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>0 - free<br/>1 - create pending<br/>2 - created<br/>3 - drop pending<br/>4 - aborting create<br/>5 - “Just in Time” create pending<br/>6 - bulk load create pending</p></td></tr><tr><td class="confluenceTd" colspan="1">create_mirror_data_loss_tracking_session_num</td><td class="confluenceTd" colspan="1">bigint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">mirror_existence_state</td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">reserved</td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">parent_xid</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd">Global transaction id.</td></tr><tr><td class="confluenceTd">persistent_serial_num</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Log sequence number position in the transaction log for a file block.</p></td></tr><tr><td class="confluenceTd">previous_free_tid</td><td class="confluenceTd">tid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Used by HAWQ Database to internally manage persistent representations of file system objects. </p></td></tr><tr><td class="confluenceTd">shared_storage</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_persistent_relation_node"><strong>gp_persistent_relation_node </strong></h2><p>The <em>gp_persistent_relation_node </em>table table keeps track of the status of file system objects in relation to the transaction status of relation objects (tables, view, indexes, and so on). This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process. </p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">tablespace_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_tablespace.oid</td><td class="confluenceTd">Tablespace object id.</td></tr><tr><td class="confluenceTd">database_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_database.oid</td><td class="confluenceTd">Database object id.</td></tr><tr><td class="confluenceTd">relfilenode_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.refilenode</td><td class="confluenceTd">The object id of teh relation file node.</td></tr><tr><td class="confluenceTd">segment_file_num</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>For append-only tables, the append-only segment file number.</p></td></tr><tr><td class="confluenceTd">relation_storage_manager</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Whether the relation is heap storage or append-only storage.</p></td></tr><tr><td class="confluenceTd">persistent_state</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>0 - free<br/>1 - create pending<br/>2 - created<br/>3 - drop pending<br/>4 - aborting create<br/>5 - “Just in Time” create pending<br/>6 - bulk load create pending</p></td></tr><tr><td class="confluenceTd"><p>mirror_existence_state</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>0 - none<br/>1 - not mirrored<br/>2 - mirror create pending<br/>3 - mirrorcreated<br/>4 - mirror down before create<br/>5 - mirror down during create<br/>6 - mirror drop pending<br/>7 - only mirror drop remains</p></td></tr><tr><td class="confluenceTd">parent_xid</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd">Global transaction id.</td></tr><tr><td class="confluenceTd">persistent_serial_num</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Log sequence number position in the transaction log for a file block.</p></td></tr><tr><td class="confluenceTd">previous_free-tid</td><td class="confluenceTd">tid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p>Used by HAWQ Database to internally manage persistent representations of file system objects. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_persistent_tablespace_node">gp_persistent_tablespace_node</h2><p>The gp_persistent_tablespace_node <span> </span>table keeps track of the status of file system objects in relation to the transaction status of tablespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd" colspan="1">contentid</td><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">filespace_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_filespace_oid</td><td class="confluenceTd">Filespace object ID.</td></tr><tr><td class="confluenceTd">tablespace_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_tablespace_oid</td><td class="confluenceTd">Tablespace object ID.</td></tr><tr><td class="confluenceTd">persistent_state</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">0 - free<br/>1 - create pending<br/>2 - created<br/>3 - drop pending<br/>4 - aborting create<br/>5 - "Just in Time" create pending<br/>6 - bulk load create pending </p></td></tr><tr><td class="confluenceTd" colspan="1">create_mirror_data_loss_tracking_session_num </td><td class="confluenceTd" colspan="1"> bigint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">mirror_existence_state</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">0 - none<br/>1 - not mirrored<br/>2 - mirror create pending<br/>3 - mirrorcreated<br/>4 - mirror down before create<br/>5 - mirror down during create<br/>6 - mirror drop pending<br/>7 - only mirror drop remains </p></td></tr><tr><td class="confluenceTd">parent_xid</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd">Global transaction ID.</td></tr><tr><td class="confluenceTd">persistent_serial_number</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Log sequence number position in the transaction log for a file block. </p></td></tr><tr><td class="confluenceTd">previous_free_tid</td><td class="confluenceTd">tid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Used by HAWQ Database to internally manage persistent representations of file system objects. </p></td></tr><tr><td class="confluenceTd" colspan="1"> shared_storage</td><td class="confluenceTd" colspan="1"> boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_pgdatabase">gp_pgdatabase</h2><p>The <em>gp_pgdatabase </em><span style="font-size: medium;"> </span>view shows status information about HAWQ segment instances and whether they are acting as the mirror or the primary. This view is used internally by the HAWQ fault detection and recovery utilities to determine failed segments.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Reference</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">smallint</td><td class="confluenceTd">gp_segment_configuration.dbid</td><td class="confluenceTd">System-assigned ID. The unique identifier of a segment (or master) instance.</td></tr><tr><td class="confluenceTd">isprimary</td><td class="confluenceTd">boolean</td><td class="confluenceTd">gp_segment_configuration.role</td><td class="confluenceTd">Whether or not this instance is active. Is it currently acting as the primary segment (as opposed to the mirror).</td></tr><tr><td class="confluenceTd">content</td><td class="confluenceTd">smallint</td><td class="confluenceTd">gp_segment_configuration.content</td><td class="confluenceTd"><p align="LEFT">The ID for the portion of data on an instance. A primary segment instance and its mirror will have the same content ID.</p><p align="LEFT">For a segment the value is from 0-<em>N</em><span style="font-size: xx-small;"> </span>, where <em>N </em><span style="font-size: xx-small;"> </span>is the number of segments in HAWQ Database.</p><p align="LEFT">For the master, the value is -1. </p></td></tr><tr><td class="confluenceTd" colspan="1">valid </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">definedprimary</td><td class="confluenceTd">boolean</td><td class="confluenceTd">gp_segment_configuration.preferred_role</td><td class="confluenceTd"><p align="LEFT">Whether or not this instance was defined as the primary (as opposed to the mirror) at the time the system was initialized.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_relation_node">gp_relation_node</h2><p>The <em>gp_relation_node </em><span style="font-size: medium;"> </span>table contains information about the file system objects for a relation (table, view, index, and so on).</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">relfilenode_oid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.relfilenode</td><td class="confluenceTd"><p align="LEFT">The object id of the relation file node. </p></td></tr><tr><td class="confluenceTd">segment_file_num</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For append-only tables, the append-only segment file number. </p></td></tr><tr><td class="confluenceTd" colspan="1"> create_mirror_data_loss_tracking_session_num</td><td class="confluenceTd" colspan="1">bigint </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd">persistent_tid</td><td class="confluenceTd">tid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Used by HAWQ Database to internally manage persistent representations of file system objects. </p></td></tr><tr><td class="confluenceTd">persistent_serial_num</td><td class="confluenceTd">bigint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Log sequence number position in the transaction log for a file block.</p></td></tr><tr><td class="confluenceTd" colspan="1">contentid </td><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_resqueue_status">gp_resqueue_status</h2><p>The <em>gp_toolkit.gp_resqueue_status </em><span style="font-size: medium;"> </span>view allows administrators to see status and activity for a workload management resource queue. It shows how many queries are waiting to run and how many queries are currently active in the system from a particular resource queue.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Reference</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">queueid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_queueid</p></td><td class="confluenceTd">The ID of the resource queue.</td></tr><tr><td class="confluenceTd">rsqname</td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqname</p></td><td class="confluenceTd">The name of the resource queue.</td></tr><tr><td class="confluenceTd">rsqcountlimit</td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqcountlimit</p></td><td class="confluenceTd"><p align="LEFT">The active query threshold of the resource queue. A value of -1 means no limit.</p></td></tr><tr><td class="confluenceTd"><p>rsqcountvalue</p></td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqcountvalue</p></td><td class="confluenceTd"><p align="LEFT">The number of active query slots currently being used in the resource queue.</p></td></tr><tr><td class="confluenceTd"><p>rsqcostlimit</p></td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqcostlimit</p></td><td class="confluenceTd"><p align="LEFT">The query cost threshold of the resource queue. A value of -1 means no limit.</p></td></tr><tr><td class="confluenceTd"><p>rsqcostvalue</p></td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqcostvalue</p></td><td class="confluenceTd"><p align="LEFT">The total cost of all statements currently in the resource queue.</p></td></tr><tr><td class="confluenceTd"><p>rsqmemorylimit</p></td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqmemorylimit</p></td><td class="confluenceTd"><p align="LEFT">The memory limit for the resource queue.</p></td></tr><tr><td class="confluenceTd"><p>rsqmemoryvalue</p></td><td class="confluenceTd">real</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqmemoryvalue</p></td><td class="confluenceTd"><p align="LEFT">The total memory used by all statements currently in the resource queue.</p></td></tr><tr><td class="confluenceTd">rsqwaiters</td><td class="confluenceTd">integer</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqwaiter</p></td><td class="confluenceTd"><p align="LEFT">The number of statements currently waiting in the resource queue.</p></td></tr><tr><td class="confluenceTd">rsqholders</td><td class="confluenceTd">integer</td><td class="confluenceTd"><p align="LEFT">gp_toolkit.gp_resqueue_rsqholders</p></td><td class="confluenceTd"><p align="LEFT">The number of statements currently running on the system from this resource queue.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_san_configuration">gp_san_configuration</h2><p>The <em>gp_san_configuration </em><span style="font-size: medium;"> </span>table contains mount-point information for SAN failover.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">mountid</td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">A value that identifies the mountpoint for the primary and mirror hosts. This is the primary key which is referred to by the value that appears in the san_mounts structure in gp_segment_configuration.</p></td></tr><tr><td class="confluenceTd">active_host</td><td class="confluenceTd">char</td><td class="confluenceTd"><p align="LEFT">The current active host. p indidcates primary, and m indicates mirror.</p></td></tr><tr><td class="confluenceTd">san_type</td><td class="confluenceTd">char</td><td class="confluenceTd"><p align="LEFT">The type of shared storage in use.</p><p align="LEFT">n indicates NFS, and e indicates EMC SAN.</p></td></tr><tr><td class="confluenceTd"><p>primary_host</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The name of the primary host system.</p></td></tr><tr><td class="confluenceTd">primary_mountpoint</td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The mount point for the primary host.</p></td></tr><tr><td class="confluenceTd">primary_device</td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">A string specifying the device to mount on the primary mountpoint. For NFS, this string is similar to:</p><p align="LEFT">nfs-server:/exported/fs.</p><p align="LEFT">For EMC this is a larger string that includes the WWN for the storage processor, the storage-processor IP, and the storage-group name.</p><p align="LEFT">The primary_device field is identical to the mirror_device field.</p></td></tr><tr><td class="confluenceTd"><p>mirror_host</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The name or the mirror/backup host system. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_segment_configuration">gp_segment_configuration</h2><p>The <em>gp_segment_configuration </em><span style="font-size: medium;"> </span>table contains information about mirroring and segment configuration.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The unique identifier of a segment (or master) instance. </p></td></tr><tr><td class="confluenceTd">content</td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The content identifier for a segment instance. A primary segment instance and its corresponding mirror will always have the same content identifier.</p><p align="LEFT">For a segment the value is from 0-</p><p align="LEFT"><em>N</em><span style="font-size: xx-small;"> </span>, where <em>N </em><span style="font-size: xx-small;"> </span>is the number of primary segments in the system.</p><p align="LEFT">For the master, the value is always -1.</p></td></tr><tr><td class="confluenceTd">role</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The role that a segment is currently running as. Values are p (primary) or m (mirror).</p></td></tr><tr><td class="confluenceTd">preferred_role</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The role that a segment was originally assigned at initialization time. Values are p (primary) or m (mirror).</p></td></tr><tr><td class="confluenceTd">mode</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The synchronization status of a segment with its mirror copy. Values are s (synchronized), c (change logging), or r (resyncing).</p></td></tr><tr><td class="confluenceTd">status</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The fault status of a segment. Values are u (up) or d (down).</p></td></tr><tr><td class="confluenceTd">port</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The TCP port the database server listener process is using. </p></td></tr><tr><td class="confluenceTd">hostname</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The hostname of a segment host.</p></td></tr><tr><td class="confluenceTd">address</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The hostname used to access a particular segment on a segment host. This value may be the same as hostname in systems upgraded from 3.x or on systems that do not have per-interface hostnames configured.</p></td></tr><tr><td class="confluenceTd">replications_port</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The TCP port the file block replication process is using to keep primary and mirror segments synchronized. </p></td></tr><tr><td class="confluenceTd">san_mounts</td><td class="confluenceTd">int2vector</td><td class="confluenceTd"><p align="LEFT">gp_san_configuration.oid</p></td><td class="confluenceTd"><p align="LEFT">An array of references to the gp_san_configuration table. Only used on systems that were initialized using sharred storage. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_transaction_log">gp_transaction_log</h2><p>The <em>gp_transaction_log </em><span style="font-size: medium;"> </span>view contains status information about transactions local to a particular segment. This view allows you to see the status of local transactions.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">segment_id</td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">gp_segment_configuration.content</p></td><td class="confluenceTd"><p align="LEFT">The content id if the segment. The master is always -1 (no content). </p></td></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">gp_segment_configuration.dbid </p></td><td class="confluenceTd"><p align="LEFT">The unique id of the segment instance. </p></td></tr><tr><td class="confluenceTd">transaction</td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd">The local transaction ID.</td></tr><tr><td class="confluenceTd">status</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The status of the local transaction (Committed or Aborted). </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-gp_version_at_initdb">gp_version_at_initdb</h2><p>The <em>gp_version_at_initdb </em><span style="font-size: medium;"> </span>table is populated on the master and each segment in the HAWQ system. It identifies the version of HAWQ used when the system was first initialized. This table is defined in the <em>pg_global </em><span style="font-size: medium;"> </span>tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">schemaversion</td><td class="confluenceTd">integer</td><td class="confluenceTd">Schema version number.</td></tr><tr><td class="confluenceTd">productversion</td><td class="confluenceTd">text</td><td class="confluenceTd">Product version number.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_aggregate">pg_aggregate</h2><p>The <em>pg_aggregate </em><span style="font-size: medium;"> </span>table stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one column from each row that matches a query condition) and returns a single value computed from all these values. Typical aggregate functions are sum, count, and max. Each entry in <em>pg_aggregate </em><span style="font-size: medium;"> </span>is an extension of an entry in <em>pg_proc</em><span style="font-size: medium;"> </span>. The <em>pg_proc </em><span style="font-size: medium;"> </span>entry carries the aggregate’s name, input and output data types, and other information that is similar to ordinary functions.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">aggfnoid</td><td class="confluenceTd">reproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">Aggregate function OID.</td></tr><tr><td class="confluenceTd">aggtransfn</td><td class="confluenceTd">regproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">Transition function OID.</td></tr><tr><td class="confluenceTd">aggprelimfn</td><td class="confluenceTd">regproc</td><td class="confluenceTd"> </td><td class="confluenceTd">Preliminary function OID (zero if none).</td></tr><tr><td class="confluenceTd">aggfinalfn</td><td class="confluenceTd">regproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">Final function OID (zero if none).</td></tr><tr><td class="confluenceTd">agginitval</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The initial value of the transition state. This is a text field containing the initial value in its external string representation. If this field is NULL, the transition state value starts out NULL.</p></td></tr><tr><td class="confluenceTd">agginvtransfn</td><td class="confluenceTd">regproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">The OID in pg_procof the inverse function of aggtransfn.</td></tr><tr><td class="confluenceTd">agginvprelimfn</td><td class="confluenceTd">regproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">The OID in pg_procof the inverse function of aggtransfn.</td></tr><tr><td class="confluenceTd">aggordered</td><td class="confluenceTd">Boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">If true, the aggregate is defined as ORDERED.</td></tr><tr><td class="confluenceTd">aggsortop</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_operator.oid</td><td class="confluenceTd"><p align="LEFT">Associated sort operator OID (zero if none)</p></td></tr><tr><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_am">pg_am</h2><p>The <em>pg_am </em><span style="font-size: medium;"> </span>table stores information about index access methods. There is one row for each index access method supported by the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">amname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Name of the access method.</td></tr><tr><td class="confluenceTd"><p>amstrategies</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Number of operator strategies for this access method</p></td></tr><tr><td class="confluenceTd"><p>amsupport</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Number of support routines for this access method</p></td></tr><tr><td class="confluenceTd"><p>amorderstrategy</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Zero if the index offers no sort order, otherwise the strategy number of the strategy operator that describes the sort order</p></td></tr><tr><td class="confluenceTd"><p>amcanunique</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Does the access method support unique indexes? </p></td></tr><tr><td class="confluenceTd"><p>amcanmulticol</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Does the access method support multicolumn indexes?</p></td></tr><tr><td class="confluenceTd">amoptionalkey</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Does the access method support a scan without any constraint for the first index column?</p></td></tr><tr><td class="confluenceTd"><p>amindexnulls</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Does the access method support null index entries? </p></td></tr><tr><td class="confluenceTd"><p>amstorage</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Can index storage data type differ from column data type? </p></td></tr><tr><td class="confluenceTd">amclusterable</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Can an index of this type be clustered on?</p></td></tr><tr><td class="confluenceTd" colspan="1">amcanshrink</td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd"><p>aminsert</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Insert this tuple" function </p></td></tr><tr><td class="confluenceTd"><p>ambeginscan</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Start new scan" function. </p></td></tr><tr><td class="confluenceTd"><p>amgettuple</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Next valid tuple" function</p></td></tr><tr><td class="confluenceTd"><p>amgetmulti</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Fetch multiple tuples" function</p></td></tr><tr><td class="confluenceTd"><p>amrescan</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Restart this scan" function</p></td></tr><tr><td class="confluenceTd"><p>amendscan </p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"End this scan" function</p></td></tr><tr><td class="confluenceTd">ammarkpos</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Mark current scan position" function. </p></td></tr><tr><td class="confluenceTd">amrestrpos</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Restore marked scan position" function</p></td></tr><tr><td class="confluenceTd">ambuild</td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">"Build new index" function</p></td></tr><tr><td class="confluenceTd" colspan="1">ambulkdelete</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Bulk-delete function </p></td></tr><tr><td class="confluenceTd" colspan="1">amvacuumcleanup</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Post-VACUUM cleanup function</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>amcostestimate</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Function to estimate cost of an index scan</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>amoptions</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Function to parse and validate reloptions for an index</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_amop">pg_amop</h2><p>The <em>pg_amop </em><span style="font-size: medium;"> </span>table stores information about operators associated with index access method operator classes. There is one row for each operator that is a member of an operator class.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">amopclaid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_opclass.oid</td><td class="confluenceTd"><p align="LEFT">The index operator class this entry is for.</p></td></tr><tr><td class="confluenceTd"><p>amopsubtype</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd"><p align="LEFT">Subtype to distinguish multiple entries for one strategy; zero for default. </p></td></tr><tr><td class="confluenceTd"><p>amopstrategy</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Operator strategy number. </p></td></tr><tr><td class="confluenceTd"><p>amopreqcheck</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Index hit must be rechecked.</p></td></tr><tr><td class="confluenceTd"><p>amopopr</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_operator.oid</p></td><td class="confluenceTd"><p align="LEFT">OID of the operator. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_amproc">pg_amproc</h2><p>The <em>pg_amproc </em><span style="font-size: medium;"> </span>table stores information about support procedures associated with index access method operator classes. There is one row for each support procedure belonging the class.i operator.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>amopclaid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_opclass.oid</p></td><td class="confluenceTd"><p align="LEFT">The index operator class this entry is for. </p></td></tr><tr><td class="confluenceTd">amprocsubtype</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd"><p align="LEFT">Subtype, if cross-type routine, else zero.</p></td></tr><tr><td class="confluenceTd"><p>amprocnum</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Support procedure number</p></td></tr><tr><td class="confluenceTd"><p>amproc</p></td><td class="confluenceTd">regproc</td><td class="confluenceTd"><p align="LEFT">pg_proc.oid </p></td><td class="confluenceTd"><p align="LEFT">OID of the procedure</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_appendonly">pg_appendonly</h2><p>The <em>pg_appendonly </em><span style="font-size: medium;"> </span>table contains information about the storage options and other characteristics of append-only tables. This table is populated only on the master.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">relid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">The table object identifier (OID) of the compressed table.</p></td></tr><tr><td class="confluenceTd"><p>blocksize</p></td><td class="confluenceTd">integer</td><td class="confluenceTd"><p align="LEFT">Block size used for compression of append-only tables. Valid values are 8K - 2M. Default is32K.</p></td></tr><tr><td class="confluenceTd"><p>safefswritesize</p></td><td class="confluenceTd">integer</td><td class="confluenceTd"><p align="LEFT">Minimum size for safe write operations to append-only tables in a non-mature file system.</p><p align="LEFT">Commonly set to a multiple of the extent size of the file system; for example, Linux ext3 is 4096 bytes, so a value of 32768 is commonly used.</p></td></tr><tr><td class="confluenceTd"><p>majorversion</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">The major version number of the <em>pg_appendonly </em><span style="font-size: xx-small;"> </span>table.</p></td></tr><tr><td class="confluenceTd"><p>minorversion</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">The minor version number of the <em>pg_appendonly </em><span style="font-size: xx-small;"> </span>table.</p></td></tr><tr><td class="confluenceTd"><p>checksum</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"><p align="LEFT">A checksum value that is stored to compare the state of a block of data at compression time and at scan time to ensure data integrity. This data is stored only if gp_appendonly_verify_block_checksums is enabled (this parameter is disabled by default to optimize performance).</p></td></tr><tr><td class="confluenceTd"><p>compresstype</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">Type of compression used to compress append-only tables. Valid values are zlib (gzip compression) and quicklz.</p></td></tr><tr><td class="confluenceTd"><p>compresslevel</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">The compression level, with compression ratio increasing from 1 to 9. When quicklz is specified for compresstype, valid values are 1 or 3. With zlib specified, valid values are 1-9.</p></td></tr><tr><td class="confluenceTd"><p>columnstore</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"><p align="LEFT">1 for column-oriented storage, 0 for row-oriented storage.</p></td></tr><tr><td class="confluenceTd"><p>segrelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">Table on-disk segment file id. </p></td></tr><tr><td class="confluenceTd"><p>segidxid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">Index on-disk segment file id. </p></td></tr><tr><td class="confluenceTd"><p>blkdirrelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">Block used for on-disk column-oriented table file. </p></td></tr><tr><td class="confluenceTd"><p>blkdiridxid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">Block used for on-disk column-oriented index file. </p></td></tr><tr><td class="confluenceTd" colspan="1">version</td><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">pagesize </td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_attrdef">pg_attrdef</h2><p>The <em>pg_attrdef </em><span style="font-size: medium;"> </span>table stores column default values. The main information about columns is stored in <em>pg_attribute</em><span style="font-size: medium;"> </span>. Only columns that explicitly specify a default value (when the table is created or the column is added) will have an entry here.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">adrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The table this column belongs to. </p></td></tr><tr><td class="confluenceTd"><p>adnum</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"><p align="LEFT">pg_attribute.attnum </p></td><td class="confluenceTd"><p align="LEFT">The number of the column</p></td></tr><tr><td class="confluenceTd"><p>adbin</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The internal representation of the column default value </p></td></tr><tr><td class="confluenceTd"><p>adsrc</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">A human-readable representation of the default value. This field is historical, and is best not used. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_attribute">pg_attribute</h2><p>The <em>pg_attribute </em><span style="font-size: medium;"> </span>table stores information about table columns. There will be exactly one <em>pg_attribute </em><span style="font-size: medium;"> </span>row for every column in every table in the database. (There will also be attribute entries for indexes, and all objects that have <em>pg_class </em><span style="font-size: medium;"> </span>entries.) The term attribute is equivalent to column.<span><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></span></span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">attrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">The table this column belongs to.</td></tr><tr><td class="confluenceTd"><p>attname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The column name. </p></td></tr><tr><td class="confluenceTd"><p>atttypid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd"><p align="LEFT">The data type of this column.</p></td></tr><tr><td class="confluenceTd"><p>attstattarget</p></td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Controls the level of detail of statistics accumulated for this column by ANALYZE. A zero value indicates that no statistics should be collected. A negative value says to use the system default statistics target. The exact meaning of positive values is data type-dependent. For scalar data types, it is both the target number of "most common values" to collect, and the target number of histogram bins to create.</p></td></tr><tr><td class="confluenceTd"><p>attlen</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">A copy of <em>pg_type.typlen </em><span style="font-size: xx-small;"> </span>of this column’s type.</p></td></tr><tr><td class="confluenceTd"><p>attnum</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The number of the column. Ordinary columns are numbered from 1 up. System columns, such as oid, have (arbitrary) negative numbers. </p></td></tr><tr><td class="confluenceTd"><p>attndims</p></td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Number of dimensions, if the column is an array type; otherwise 0. (Presently, the number of dimensions of an array is not enforced, so any nonzero value effectively means it is an array).</p></td></tr><tr><td class="confluenceTd"><p>attcacheoff</p></td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Always -1 in storage, but when loaded into a row descriptor in memory this may be updated to cache the offset of the attribute within the row.</p></td></tr><tr><td class="confluenceTd"> </td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd">Records type-specific data supplied at table creation time (for example, the maximum length of a carchar column). It is passed to type-specific input functions and length coercion functions. The value will generally be -1 for types that do not need it.</td></tr><tr><td class="confluenceTd">attbyval</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">A copy of pg_type.typbyval of this column's type.</td></tr><tr><td class="confluenceTd">attstorage</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd">Normally a copy of pg_type.typstorage of this column's type. For TOAST - able data types, this can be altered after column creation to control storage policy.</td></tr><tr><td class="confluenceTd">attalign</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd">A copy of pg_type.typealign of this column's type.</td></tr><tr><td class="confluenceTd">attnotnull</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">This represents a not-null constraint. It is possible to change this column to enable or disable the constraint.</td></tr><tr><td class="confluenceTd">atthasdef</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">This column has a default value, in which case there will be a corresponding entry in the pg_attrdef catalog that actually defines the value.</td></tr><tr><td class="confluenceTd">attisdropped</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">This column has been dropped and no longer valid. A dropped column is still physically present in the table, but is ignored by the parser. It cannot be accessed via SQL.</td></tr><tr><td class="confluenceTd">attislocal</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">This column is defined locally in the relation. Note that a column may be locally defined and inherited simultaneously.</td></tr><tr><td class="confluenceTd">aatinhcount</td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd">The number of direct ancestors this column has. A column with a nonzero number of ancestors cannot be dropped not renamed.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_attribute_encoding">pg_attribute_encoding</h2><p>The <em>pg_attribute_encoding </em><span style="font-size: medium;"> </span>system catalog table contains column storage information.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Modifiers</th><th class="confluenceTh">Storage</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">attrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Foreign key to pg_attribute attrelid</td></tr><tr><td class="confluenceTd">attnum</td><td class="confluenceTd">smallint</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Foreign key to pg_attribute attnum.</td></tr><tr><td class="confluenceTd">attoptions</td><td class="confluenceTd">text[]</td><td class="confluenceTd"> </td><td class="confluenceTd">extended</td><td class="confluenceTd">The options.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_auth_members">pg_auth_members</h2><p>The <em>pg_auth_members </em><span style="font-size: medium;"> </span>system catalog table shows the membership relations between roles. Any non-circular set of relationships is allowed. Because roles are system-wide, <em>pg_auth_members </em><span style="font-size: medium;"> </span>is shared across all databases of a HAWQ Database system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">roleid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd"><p align="LEFT">ID of the parent-level (group) role.</p></td></tr><tr><td class="confluenceTd"><p>member</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid</p></td><td class="confluenceTd"><p align="LEFT">ID of a member role.</p></td></tr><tr><td class="confluenceTd"><p>grantor</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid</p></td><td class="confluenceTd"><p align="LEFT">ID of the role that granted this membership.</p></td></tr><tr><td class="confluenceTd"><p>admin_option</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">True if role member may grant membership to others.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_authid">pg_authid</h2><p>The <em>pg_authid </em><span style="font-size: medium;"> </span>table contains information about database authorization identifiers (roles). A role subsumes the concepts of users and groups. A user is a role with the <em>rolcanlogin </em><span style="font-size: medium;"> </span>flag set. Any role (with or without <em>rolcanlogin</em><span style="font-size: medium;"> </span>) may have other roles as members. See <em>pg_auth_members</em><span style="font-size: medium;"> </span>.</p><p>Since this catalog contains passwords, it must not be publicly readable. <em>pg_roles </em><span style="font-size: medium;"> </span>is a publicly readable view on <em>pg_authid </em><span style="font-size: medium;"> </span>that blanks out the password field.</p><p>Because user identities are system-wide, <em>pg_authid </em><span style="font-size: medium;"> </span>is shared across all databases in a HAWQ Database system: there is only one copy of <em>pg_authid </em><span style="font-size: medium;"> </span>per system, not one per database.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">rolname</td><td class="confluenceTd">name</td><td class="confluenceTd">Role name</td></tr><tr><td class="confluenceTd">rolsuper</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role has superuser privileges.</td></tr><tr><td class="confluenceTd">rolinherit</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role automatically inherits privileges of roles it is a member of.</td></tr><tr><td class="confluenceTd">rolcreatearole</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role may create more roles.</td></tr><tr><td class="confluenceTd">rolecreatedb</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role may create databases.</td></tr><tr><td class="confluenceTd">rolcatupdate</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role may update system catalogs directly. (Even a superuser may not do this unless this column is true).</td></tr><tr><td class="confluenceTd">rolcanlogin</td><td class="confluenceTd">boolean</td><td class="confluenceTd">Role may log in. That is, this role can be given as the initial session authorization identifier.</td></tr><tr><td class="confluenceTd">rolconnlimit</td><td class="confluenceTd">int4</td><td class="confluenceTd">For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means n limit.</td></tr><tr><td class="confluenceTd">rolpassword</td><td class="confluenceTd">text</td><td class="confluenceTd">Password (possible encrypted). NULL if none.</td></tr><tr><td class="confluenceTd">rolvaliduntil</td><td class="confluenceTd">timestampz</td><td class="confluenceTd">Password expiry time (only used for password authentication); NULL if no expiration.</td></tr><tr><td class="confluenceTd" colspan="1">rolconfig </td><td class="confluenceTd" colspan="1">text[] </td><td class="confluenceTd" colspan="1">Session defaults for server configuration parameters. </td></tr><tr><td class="confluenceTd" colspan="1">rolresqueue </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreaterextgpfd </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreaterexthttp </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreatewextgpfd </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreaterexthdfs </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreatewexthdfs </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_cast">pg_cast</h2><p>The catalog <em>pg_cast </em><span style="font-size: medium;"> </span>stores data type conversion paths, both built-in paths and those defined with CREATE CAST. The cast functions listed in <em>pg_cast </em><span style="font-size: medium;"> </span>must always take the cast source type as their first argument type, and return the cast destination type as their result type. A cast function can have up to three arguments. The second argument, if present, must be type integer; it receives the type modifier associated with the destination type, or -1 if there is none. The third argument, if present, must be type boolean; it receives true if the cast is an explicit cast, false otherwise.</p><p>It is legitimate to create a <em>pg_cast </em><span style="font-size: medium;"> </span>entry in which the source and target types are the same, if the associated function takes more than one argument. Such entries represent ‘length coercion functions’ that coerce values of the type to be legal for a particular type modifier value. Note however that at present there is no support for associating non-default type modifiers with user-created data types, and so this facility is only of use for the small number of built-in types that have type modifier syntax built into the grammar.</p><p>When a <em>pg_cast </em><span style="font-size: medium;"> </span>entry has different source and target types and a function that takes more than one argument, it represents converting from one type to another and applying a length coercion in a single step. When no such entry is available, coercion to a type that uses a type modifier involves two steps, one to convert between data types and a second to apply the modifier.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>castsource</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd"><p align="LEFT">OID of the source data type.</p></td></tr><tr><td class="confluenceTd"><p>casttarget</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd"><p align="LEFT">OID of the target data type.</p></td></tr><tr><td class="confluenceTd"><p>castfunc</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_proc.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID of the function to use to perform this cast. Zero is stored if the data types are binary compatible (that is, no run-time operation is needed to perform the cast).</p></td></tr><tr><td class="confluenceTd"><p>castcontext</p></td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Indicates what contexts the cast may be invoked in. e means only as an explicit cast (using CAST or :: syntax). a means implicitly in assignment to a target column, as well as explicitly. i means implicitly in expressions, as well as the other cases<em>. </em><span style="font-size: xx-small;"> </span></p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_class">pg_class</h2><p>The system catalog table <em>pg_class </em><span style="font-size: medium;"> </span>catalogs tables and most everything else that has columns or is otherwise similar to a table (also known as <em>relations</em><span style="font-size: medium;"> </span>). This includes indexes (see also <em>pg_index</em><span style="font-size: medium;"> </span>), sequences, views, composite types, and TOAST tables. Not all columns are meaningful for all relation types.<span><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span> </span> </span> </span></span> </span></span> </span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">relname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Name of the table, index,view, etc.</td></tr><tr><td class="confluenceTd">relnamespace </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_namespace.oid </td><td class="confluenceTd"><p align="LEFT">The OID of the namespace (schema) that contains this relation</p></td></tr><tr><td class="confluenceTd">reltype </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_type.oid </td><td class="confluenceTd"><p align="LEFT">The OID of the data type that corresponds to this table’s row type, if any (zero for indexes, which have no<em>pg_type </em><span style="font-size: xx-small;"> </span>entry)</p></td></tr><tr><td class="confluenceTd">relowner </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_authod.oid</td><td class="confluenceTd"><p align="LEFT">Owner of the relation</p></td></tr><tr><td class="confluenceTd">relam </td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_am.oid </td><td class="confluenceTd"><p align="LEFT">If this is an index, the access method used (B-tree, Bitmap, hash, etc.)</p></td></tr><tr><td class="confluenceTd">relfilenode </td><td class="confluenceTd">oid </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Name of the on-disk file of this relation;0 if none.</p></td></tr><tr><td class="confluenceTd">reltablespace </td><td class="confluenceTd">oid </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The tablespace in which this relation is stored. If zero, the database’s default tablespace is implied. (Not meaningful if the relation has no on-disk file.) </p></td></tr><tr><td class="confluenceTd">relpages </td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Size of the on-disk representation of this table in pages (of 32K each). This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands.</p></td></tr><tr><td class="confluenceTd">reltuples</td><td class="confluenceTd">float4 </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Number of rows in the table. This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands.</p></td></tr><tr><td class="confluenceTd">reltoastrelid</td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_class.oid </td><td class="confluenceTd"><p align="LEFT">OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes "out of line" in a secondary table.</p></td></tr><tr><td class="confluenceTd"> reltoastidxid</td><td class="confluenceTd"> oid </td><td class="confluenceTd">pg_class.oid </td><td class="confluenceTd"><p align="LEFT">For a TOAST table, the OID of its index. 0 if not a TOAST table.</p></td></tr><tr><td class="confluenceTd">relhasindex</td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">True if this is a table and it has (or recently had) any indexes. This is set by CREATE INDEX, but not cleared immediately by DROP INDEX. VACUUM will clear if it finds the table has no indexes.</p></td></tr><tr><td class="confluenceTd" colspan="1">relisshared</td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if this table is shared across all databases in the system. Only certain system catalog tables are shared. </p></td></tr><tr><td class="confluenceTd" colspan="1">relkind </td><td class="confluenceTd" colspan="1">char </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of object</p><p align="LEFT">r = heap or append-only table, i = index, S = sequence, v = view, c = composite type, t = TOAST value, o = internal append-only segment files and EOFs, c = composite type, u = uncataloged temporary heap table</p></td></tr><tr><td class="confluenceTd" colspan="1">relstorage </td><td class="confluenceTd" colspan="1">char </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The storage mode of a table</p><p align="LEFT">a = append-only, h = heap, v = virtual, x= external table.</p></td></tr><tr><td class="confluenceTd" colspan="1">relnatts</td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Number of user columns in the relation (system columns not counted). There must be this many corresponding entries in <em>pg_attribute</em><span style="font-size: xx-small;"> </span>.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>relchecks</p></td><td class="confluenceTd" colspan="1"> int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Number of check constraints on the table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>reltriggers</p></td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Number of triggers on the table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>relukeys</p></td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Unused</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>relfkeys</p></td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Unused</p></td></tr><tr><td class="confluenceTd" colspan="1">relrefs</td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Unused</p></td></tr><tr><td class="confluenceTd" colspan="1">relhasoids</td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if an OID is generated for each row of the relation.</p></td></tr><tr><td class="confluenceTd" colspan="1">relhaspkey</td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if the table has (or once had) a primary key.</p></td></tr><tr><td class="confluenceTd" colspan="1">relhasrules</td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if table has rules.</p></td></tr><tr><td class="confluenceTd" colspan="1">relhassubclass</td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if table has (or once had) any inheritance children.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_compression">pg_compression</h2><p>The <em>pg_compression </em><span style="font-size: medium;"> </span>system catalog table describes the compression methods available.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Modifiers</th><th class="confluenceTh">Storage</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">compname</td><td class="confluenceTd">name</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Name of the compression.</td></tr><tr><td class="confluenceTd">compconstructor</td><td class="confluenceTd">regproc</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Name of compression constructor.</td></tr><tr><td class="confluenceTd">compdestructor</td><td class="confluenceTd">regproc</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Name of compression destructor.</td></tr><tr><td class="confluenceTd" colspan="1">compcompressor </td><td class="confluenceTd" colspan="1">regproc </td><td class="confluenceTd" colspan="1">not null </td><td class="confluenceTd" colspan="1">plain </td><td class="confluenceTd" colspan="1">Name of compressor. </td></tr><tr><td class="confluenceTd">compdecompressor</td><td class="confluenceTd">regproc</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Name of decompressor.</td></tr><tr><td class="confluenceTd">compvalidator</td><td class="confluenceTd">regproc</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">Name of compression validator.</td></tr><tr><td class="confluenceTd">compowner</td><td class="confluenceTd">oid</td><td class="confluenceTd">not null</td><td class="confluenceTd">plain</td><td class="confluenceTd">oid from pg_authid</td></tr><tr><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_class.1">pg_class</h2><p>The system catalog table <em>pg_class </em><span> </span>catalogs tables and most everything else that has columns or is otherwise similar to a table (also known as <em>relations</em><span> </span>). This includes indexes (see also <em>pg_index</em><span> </span>), sequences, views, composite types, and TOAST tables. Not all columns are meaningful for all relation types.<span><span><span><span><span><span><span><span><span><span><span><span><span> </span> </span> </span> </span></span> </span></span> </span></span></span></span></span></span></p><p><span style="font-size: medium;"> </span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">conname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Constraint name (not necessarily unique!)</p></td></tr><tr><td class="confluenceTd">connamespace </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_namespace.oid </td><td class="confluenceTd"><p align="LEFT">The OID of the namespace (schema) that contains this relation</p></td></tr><tr><td class="confluenceTd">contype </td><td class="confluenceTd">oid </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">c= check constraint, f = foreign key constraint, p = primary key constraint, u = unique constraint.</p></td></tr><tr><td class="confluenceTd">condeferrable</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Is the constraint deferrable? </p></td></tr><tr><td class="confluenceTd">conrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd"><p align="LEFT">The table this constraint is on; 0 if not a table constraint. </p></td></tr><tr><td class="confluenceTd">contypeid</td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_type.oid </td><td class="confluenceTd"><p align="LEFT">The domain this constraint is on; 0 if not a domain constraint. </p></td></tr><tr><td class="confluenceTd">confrelid</td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_class.oid </td><td class="confluenceTd"><p align="LEFT">If a foreign key, the referenced table; else 0. </p></td></tr><tr><td class="confluenceTd">confupdtype</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Foreign key update action code. </p></td></tr><tr><td class="confluenceTd">confdeltype</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Foreign key update action code. </p></td></tr><tr><td class="confluenceTd">confmatchtype</td><td class="confluenceTd">char </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Foreign key match type. </p></td></tr><tr><td class="confluenceTd">conkey</td><td class="confluenceTd">int2[]</td><td class="confluenceTd"><p align="LEFT">pg_attribute.attnum</p></td><td class="confluenceTd"><p align="LEFT">If a table constraint, list of columns which the constraint constrains. </p></td></tr><tr><td class="confluenceTd">confkey</td><td class="confluenceTd">int2[] </td><td class="confluenceTd"><p align="LEFT">pg_attribute.attnum</p></td><td class="confluenceTd"><p align="LEFT">If a foreign key, list of the referenced columns. </p></td></tr><tr><td class="confluenceTd" colspan="1">conbin</td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">If a check constraint, an internal representation of the expression. </p></td></tr><tr><td class="confluenceTd" colspan="1">consrc</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">If a check constraint, a human-readable representation of the expression. This is not updated when referenced objects change; for example, it won’t track renaming of columns. Rather than relying on this field, it is best to use</p><p align="LEFT">pg_get_constraintdef() to extract the definition of a check constraint.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_conversion">pg_conversion</h2><p>The <em>pg_conversion </em><span style="font-size: medium;"> </span>system catalog table describes the available encoding conversion procedures as defined by CREATE CONVERSION.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Reference</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">conname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Conversion name (unique within a namespace).</td></tr><tr><td class="confluenceTd">connamespace</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_namespace.oid</td><td class="confluenceTd">The OID of the namespace (schema) that contains this conversion.</td></tr><tr><td class="confluenceTd">conowner</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_authid.oid</td><td class="confluenceTd">Owner of the conversion.</td></tr><tr><td class="confluenceTd">conforencoding</td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd">Source encoding ID.</td></tr><tr><td class="confluenceTd">contoencoding</td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd">Destination encoding ID</td></tr><tr><td class="confluenceTd">conproc</td><td class="confluenceTd">regproc</td><td class="confluenceTd">pg_proc.oid</td><td class="confluenceTd">Conversion procedure.</td></tr><tr><td class="confluenceTd">condefault</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd">True if this is the default conversion.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_database">pg_database</h2><p>The <em>pg_database </em><span style="font-size: medium;"> </span>system catalog table stores information about the available databases. Databases are created with the CREATE DATABASE SQL command. Unlike most system catalogs, <em>pg_database </em><span style="font-size: medium;"> </span>is shared across all databases in the system. There is only one copy of <em>pg_database </em><span style="font-size: medium;"> </span>per system, not one per database.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">datname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Database name.</td></tr><tr><td class="confluenceTd">datdba</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_authid.oid</td><td class="confluenceTd">Owner of the database, usually the user who created it.</td></tr><tr><td class="confluenceTd">encoding</td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd">Character encoding for this database. pg_encoding_to_char() can translate this number to the encoding name.</td></tr><tr><td class="confluenceTd">datistemplate</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If true then this database can be used in the TEMPLATE clause of CREATE DATABASE to create a new database as a clone of this one.</p></td></tr><tr><td class="confluenceTd">datallowconn</td><td class="confluenceTd">Boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If false then no one can connect to this database. This is used to protect the template0 database from being altered.</p></td></tr><tr><td class="confluenceTd"><p>datconnlimit</p></td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Sets the maximum number of concurrent connections that can be made to this database. -1 means no limit.</p></td></tr><tr><td class="confluenceTd"><p>datlastsysoid</p></td><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Last system OID in the database; useful particularly to pg_dump/gp_dump.</p></td></tr><tr><td class="confluenceTd"><p>datfrozenxid</p></td><td class="confluenceTd"><p>xid</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">All transaction IDs before this one have been replaced with a permanent (frozen) transaction ID in this database. This is used to track whether the database needs to be vacuumed in order to prevent transaction ID wraparound or to allow <em>pg_clog </em><span style="font-size: xx-small;"> </span>to be shrunk. It is the minimum of the per-table <em>pg_class.relfrozenxid </em><span style="font-size: xx-small;"> </span>values.</p></td></tr><tr><td class="confluenceTd"><p>dattablespace</p></td><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd">pg_tablesapce.oid </td><td class="confluenceTd"><p align="LEFT">The default tablespace for the database. Within this database, all tables for which <em>pg_class.reltablespace </em><span style="font-size: xx-small;"> </span>is zero will be stored in this tablespace. All non-shared system catalogs will also be there.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>dat2tablespace</p> </td><td class="confluenceTd" colspan="1">oid </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd"><p>datconfig</p></td><td class="confluenceTd"><p>text[]</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Session defaults for user-settable server configuration parameters.</p></td></tr><tr><td class="confluenceTd">datacl</td><td class="confluenceTd"><p>aclite[]</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Database access privileges as given by GRANT and REVOKE.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_depend">pg_depend</h2><p>The <em>pg_depend </em><span style="font-size: medium;"> </span>system catalog table records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case. See also <em>pg_shdepend</em><span style="font-size: medium;"> </span>, which performs a similar function for dependencies involving objects that are shared across HAWQ.</p><p>In all cases, a <em>pg_depend </em><span style="font-size: medium;"> </span>entry indicates that the referenced object may not be dropped without also dropping the dependent object. However, there are several subflavors identified by <em>deptype</em><span style="font-size: medium;"> </span>:</p><ul><li>DEPENDENCY_NORMAL (n) <span style="font-size: medium;"> </span>— A normal relationship between separately-created objects. The dependent object may be dropped without affecting the referenced object. The referenced object may only be dropped by specifying CASCADE, in which case the dependent object is dropped, too. Example: a table column has a normal dependency on its data type.</li><li>DEPENDENCY_AUTO (a) <span style="font-size: medium;"> </span>— The dependent object can be dropped separately from the referenced object, and should be automatically dropped (regardless of RESTRICT or CASCADE mode) if the referenced object is dropped. Example: a named constraint on a table is made autodependent on the table, so that it will go away if the table is dropped.</li><li>DEPENDENCY_INTERNAL (i) — The dependent object was created as part of creation of the referenced object, and is really just a part of its internal implementation. A DROP of the dependent object will be disallowed outright (we’ll tell the user to issue a DROP against the referenced object, instead). A DROP of the referenced object will be propagated through to drop the dependent object whether CASCADE is specified or not. Example: a trigger that’s created to enforce a foreign-key constraint is made internally dependent on the constraint’s <em>pg_constraint </em><span style="font-size: medium;"> </span>entry.</li><li><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span>DEPENDENCY_PIN (p) — There is no dependent object; this type of entry is a signal that the system itself depends on the referenced object, and so that object must never be deleted. Entries of this type are created only by system initialization. The columns for the dependent object contain zeroes.</li></ul><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Reference</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">classid </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">The OID of the system catalog the dependent object is in. </td></tr><tr><td class="confluenceTd">objid </td><td class="confluenceTd">oid </td><td class="confluenceTd">any OID column </td><td class="confluenceTd">The OID of the specific dependent object. </td></tr><tr><td class="confluenceTd">objsubid </td><td class="confluenceTd">int4 </td><td class="confluenceTd"> </td><td class="confluenceTd">For a table column, this is the column number. For all the other object types, this column is zero. </td></tr><tr><td class="confluenceTd">refclassid </td><td class="confluenceTd">oid </td><td class="confluenceTd">pg_class.oid </td><td class="confluenceTd">The OID of the system catalog the referenced object is in. </td></tr><tr><td class="confluenceTd">refobjid </td><td class="confluenceTd">oid </td><td class="confluenceTd">any OID column </td><td class="confluenceTd">The OID of the specific referenced object. </td></tr><tr><td class="confluenceTd">refobjsubid </td><td class="confluenceTd">int4 </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For a table column, this is the referenced column number. For all other object types, this column is zero.</p></td></tr><tr><td class="confluenceTd">deptype </td><td class="confluenceTd">char </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">A code defining the specific semantics of this dependency relationship. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_description">pg_description</h2><p>The <em>pg_description </em><span style="font-size: medium;"> </span>system catalog table stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql’s \d meta-commands. Descriptions of many built-in system objects are provided in the initial contents of <em>pg_description</em><span style="font-size: medium;"> </span>. See also <em>pg_shdescription</em><span style="font-size: medium;"> </span>, which performs a similar function for descriptions involving objects that are shared across HAWQ.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">objoid</td><td class="confluenceTd">oid</td><td class="confluenceTd">any OID column</td><td class="confluenceTd">The OID of the object this description pertains to.</td></tr><tr><td class="confluenceTd">clasoid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">The OID of the system catalog this object appears in.</td></tr><tr><td class="confluenceTd">objsubid</td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For a comment on a table column, this is the column number. For all other object types, this column is zero.</p></td></tr><tr><td class="confluenceTd">description </td><td class="confluenceTd">text </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Arbitrary text that serves as the description of this object. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_exttable">pg_exttable</h2><p>The <em>pg_exttable </em><span style="font-size: medium;"> </span>system catalog table is used to track external tables and web tables created by the CREATE EXTERNAL TABLE command.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">reloid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">The OID of this external table.</td></tr><tr><td class="confluenceTd">location</td><td class="confluenceTd">text[]</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The URI location(s) of the external table files. </p></td></tr><tr><td class="confluenceTd">fmttype</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Format of the external table files:t for text, or c for csv.</p></td></tr><tr><td class="confluenceTd">fmtopts</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Formatting options of the external table files, such as the field delimiter, null string, escape character, etc. </p></td></tr><tr><td class="confluenceTd">command</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The OS command to execute when the external table is accessed. </p></td></tr><tr><td class="confluenceTd">rejectlimit</td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The per segment reject limit for rows with errors, after which the load will fail. </p></td></tr><tr><td class="confluenceTd">rejectlimittype</td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Type of reject limit threshold: r for number of rows.</p></td></tr><tr><td class="confluenceTd">fmterrtbl</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd"><p align="LEFT">The object id of the error table where format errors will be logged. </p></td></tr><tr><td class="confluenceTd">encoding</td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The client encoding. </p></td></tr><tr><td class="confluenceTd">writable</td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">0 for readable external tables, 1 for writable external tables.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_filespace">pg_filespace</h2><p>The <em>pg_filespace </em><span style="font-size: medium;"> </span>table contains information about the filespaces created in a HAWQ Database system. Every system contains a default filespace, <em>pg_system</em><span style="font-size: medium;"> </span>, which is a collection of all the data directory locations created at system initialization time.</p><p>A tablespace requires a file system location to store its database files. In HAWQ, the master and each segment (primary and mirror) needs its own distinct storage location. This collection of file system locations for all components in a HAWQ system is referred to as a filespace.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">fsname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">The name of the filespace</td></tr><tr><td class="confluenceTd">fsowner</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_roles.oid</td><td class="confluenceTd"><p align="LEFT">The object id of the role that created the filespace.</p></td></tr><tr><td class="confluenceTd" colspan="1">fsfsys </td><td class="confluenceTd" colspan="1"> oid</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">The filesystem ID.</td></tr><tr><td class="confluenceTd" colspan="1">fsrep </td><td class="confluenceTd" colspan="1">smallint </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">fs replica number. </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_filespace_entry">pg_filespace_entry</h2><p>A tablespace requires a file system location to store its database files. In HAWQ, the master and each segment (primary and mirror) needs its own distinct storage location. This collection of file system locations for all components in a HAWQ system is referred to as a <em>filespace</em><span style="font-size: medium;"> </span>. The <em>pg_filespace_entry </em><span style="font-size: medium;"> </span>table contains information about the collection of file system locations across a HAWQ Database system that comprise a HAWQ Database filespace.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">fsefoid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_filespace.oid</p></td><td class="confluenceTd">The object ID of the filespace</td></tr><tr><td class="confluenceTd">fsedbid</td><td class="confluenceTd">integer</td><td class="confluenceTd"><p align="LEFT">gp_segment_configuration.dbid </p></td><td class="confluenceTd"><p align="LEFT">Segment ID.</p></td></tr><tr><td class="confluenceTd" colspan="1">fselocation</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">File system location for this segment id. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_index">pg_index</h2><p>The <em>pg_index </em><span style="font-size: medium;"> </span>system catalog table contains part of the information about indexes. The rest is mostly in <em>pg_class</em><span style="font-size: medium;"> </span>.<span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">indexrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid</td><td class="confluenceTd">The OID of the pg_class entry for this index.</td></tr><tr><td class="confluenceTd"><p>indrelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_class.oid </td><td class="confluenceTd"><p align="LEFT">The OID of the <em>pg_class </em><span style="font-size: xx-small;"> </span>entry for the table this index is for.</p></td></tr><tr><td class="confluenceTd"><p>indnatts</p></td><td class="confluenceTd">int2</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The number of columns in the index (duplicates <em>pg_class.relnatts</em><span style="font-size: xx-small;"> </span>).</p></td></tr><tr><td class="confluenceTd"><p>indisunique</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If true, this is a unique index. </p></td></tr><tr><td class="confluenceTd"><p>indisprimary</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If true, this index represents the primary key of the table. ( <em>indisunique </em><span style="font-size: xx-small;"> </span>should always be true when this is true.)</p></td></tr><tr><td class="confluenceTd"><p>indisclustered</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If true, the table was last clustered on this index via the CLUSTER command.</p></td></tr><tr><td class="confluenceTd"><p>indisvalid</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">If true, the index is currently valid for queries. False means the index is possibly incomplete: it must still be modified by INSERT/UPDATE operations, but it cannot safely be used for queries.</p></td></tr><tr><td class="confluenceTd"><p>indkey</p></td><td class="confluenceTd">int2vector</td><td class="confluenceTd"><p align="LEFT">pg_attribute.attnum</p><p align="LEFT"> </p><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">This is an array of <em>indnatts </em><span style="font-size: xx-small;"> </span>values that indicate which table columns this index indexes. For example a value of 1 3 would mean that the first and the third table columns make up the index key. A zero in this array indicates that the corresponding index attribute is an expression over the table columns, rather than a simple column reference.</p></td></tr><tr><td class="confluenceTd"><p>indclass</p></td><td class="confluenceTd">oidvector</td><td class="confluenceTd"><p align="LEFT">pg_opclass.oid</p></td><td class="confluenceTd"><p align="LEFT">For each column in the index key this contains the OID</p></td></tr><tr><td class="confluenceTd"><p>indexprs</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Expression trees (in nodeToString() representation) for index attributes that are not simple column references. This is a list with one element for each zero entry in <em>indkey</em><span style="font-size: xx-small;"> </span>. NULL if all index attributes are simple references.</p></td></tr><tr><td class="confluenceTd" colspan="1"> indpred</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Expression tree (in nodeToString() representation) for partial index predicate. NULL if not a partial index.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_inherits">pg_inherits</h2><p>The <em>pg_inherits </em><span style="font-size: medium;"> </span>system catalog table records information about table inheritance hierarchies. There is one entry for each direct child table in the database. (Indirect inheritance can be determined by following chains of entries.) In HAWQ, inheritance relationships are created by both the INHERITS clause (standalone inheritance) and the PARTITION BY clause (partitioned child table inheritance) of CREATE TABLE.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">inhrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid</p></td><td class="confluenceTd">The OID of the child table.</td></tr><tr><td class="confluenceTd">inhparent</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid</p></td><td class="confluenceTd"><p align="LEFT">The OID of the parent table.</p></td></tr><tr><td class="confluenceTd" colspan="1">inhseqno</td><td class="confluenceTd" colspan="1">int4</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_language">pg_language</h2><p>The <em>pg_language </em><span style="font-size: medium;"> </span>system catalog table registers languages in which you can write functions or stored procedures. It is populated by CREATE LANGUAGE.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">lanname</td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Name of the language.</p></td></tr><tr><td class="confluenceTd"><p>lanispl</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">This is false for internal languages (such as SQL) and true for user-defined languages. Currently, pg_dump still uses this to determine which languages need to be dumped, but this may be replaced by a different mechanism in the future.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>lanpltrusted</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if this is a trusted language, which means that it is believed not to grant access to anything outside the normal SQL execution environment. Only superusers may create functions in untrusted languages.</p></td></tr><tr><td class="confluenceTd" colspan="1">lanplcallfoid</td><td class="confluenceTd" colspan="1"><p>oid</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_proc.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">For noninternal languages this references the language handler, which is a special function that is responsible for executing all functions that are written in the particular language.</p></td></tr><tr><td class="confluenceTd" colspan="1">lanvalidator</td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_proc.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">This references a language validator function that is responsible for checking the syntax and validity of new functions when they are created. Zero if no validator is provided. </p></td></tr><tr><td class="confluenceTd" colspan="1">lanacl</td><td class="confluenceTd" colspan="1">aclitem[]</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Access privileges for the language. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_largeobject">pg_largeobject</h2><p>The <em>pg_largeobject </em><span style="font-size: medium;"> </span>system catalog table holds the data making up ‘large objects’. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or ‘pages’ small enough to be conveniently stored as rows in <em>pg_largeobject</em><span style="font-size: medium;"> </span>. The amount of data per page is defined to be LOBLKSIZE (which is currently BLCKSZ/4, or typically 8K).</p><p>Each row of <em>pg_largeobject </em><span style="font-size: medium;"> </span>holds data for one page of a large object, beginning at byte offset (<em>pageno </em><span style="font-size: small;"> </span>* LOBLKSIZE) within the object. The implementation allows sparse storage: pages may be missing, and may be shorter than LOBLKSIZE bytes even if they are not the last page of the object. Missing regions within a large object read as zeroes.<span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">loid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">Identifier of the large object that includes this page. </p></td></tr><tr><td class="confluenceTd"><p>pageno</p></td><td class="confluenceTd"><p>int4</p></td><td class="confluenceTd"><p align="LEFT">Page number of this page within its large object (counting from zero). </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>data</p></td><td class="confluenceTd" colspan="1"><p>bytea</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and may be less.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_locks">pg_locks</h2><p align="LEFT">The view <em>pg_locks </em><span style="font-size: medium;"> </span>provides access to information about the locks held by open transactions within HAWQ Database.</p><p align="LEFT">pg_locks contains one row per active lockable object, requested lock mode, and relevant transaction. Thus, the same lockable object may appear many times, if multiple transactions are holding or waiting for locks on it. However, an object that currently has no locks on it will not appear at all.</p><p>There are several distinct types of lockable objects: whole relations (such as tables), individual pages of relations, individual tuples of relations, transaction IDs, and general database objects. Also, the right to extend a relation is represented as a separate lockable object.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">locktype</td><td class="confluenceTd"><p>text</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Type of the lockable object: relation, extend, page, tuple, transactionid, object, userlock, resource queue, or advisory</p></td></tr><tr><td class="confluenceTd"><p>database</p></td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_database.oid </td><td class="confluenceTd"><p align="LEFT">OID of the database in which the object exists, zero if the object is a shared object, or NULL if the object is a transaction ID</p></td></tr><tr><td class="confluenceTd"><p>relation</p></td><td class="confluenceTd">oid</td><td class="confluenceTd">pg_opclass.oid</td><td class="confluenceTd"><p align="LEFT">OID of the relation, or NULL if the object is not a relation or part of a relation</p></td></tr><tr><td class="confluenceTd"><p>page</p></td><td class="confluenceTd">integer</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Page number within the relation, or NULL if the object is not a tuple or relation page</p></td></tr><tr><td class="confluenceTd"><p>tuple</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Tuple number within the page, or NULL if the object is not a tuple.</p></td></tr><tr><td class="confluenceTd"><p>transactionid</p></td><td class="confluenceTd"><p>xid</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">ID of a transaction, or NULL if the object is not a transaction ID </p></td></tr><tr><td class="confluenceTd"><p>classid</p></td><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd"><p align="LEFT">pg_opclass.oid</p> </td><td class="confluenceTd"><p align="LEFT">OID of the system catalog containing the object, or NULL if the object is not a general database object</p></td></tr><tr><td class="confluenceTd"><p>objid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">any OID column </p></td><td class="confluenceTd"><p align="LEFT">OID of the object within its system catalog, or NULL if the object is not a general database object</p></td></tr><tr><td class="confluenceTd"><p>objsubid</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">For a table column, this is the column number (them <em>classid </em><span> </span>and <em>objid </em><span> </span>refer to the table itself). For all other object types, this column is zero. NULL if the object is not a general database object</p></td></tr><tr><td class="confluenceTd"><p>transaction</p></td><td class="confluenceTd">xid</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">ID of the transaction that is holding or awaiting this lock </p></td></tr><tr><td class="confluenceTd" colspan="1">pid</td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Process ID of the server process holding or awaiting this lock. NULL if the lock is held by a prepared transaction </p></td></tr><tr><td class="confluenceTd" colspan="1"> mode</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Name of the lock mode held or desired by this process</p></td></tr><tr><td class="confluenceTd" colspan="1">granted</td><td class="confluenceTd" colspan="1"><p>boolean</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if lock is held, false if lock is awaited</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>mppsessionid</p></td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The id of the client session associated with this lock.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>mppiswriter </p></td><td class="confluenceTd" colspan="1"><p>boolean </p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Is the lock held by a writer process?</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>gp_segment_id</p></td><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The HAWQ segment id (dbid) where the lock is held.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_opclass">pg_opclass</h2><p>The <em>pg_opclass </em><span style="font-size: medium;"> </span>system catalog table defines index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a particular index access method. Note that there can be multiple operator classes for a given data type/access method combination, thus supporting multiple behaviors. The majority of the information defining an operator class is actually not in its <em>pg_opclass </em><span style="font-size: medium;"> </span>row, but in the associated rows in <em>pg_amop </em><span style="font-size: medium;"> </span>and <em>pg_amproc</em><span style="font-size: medium;"> </span>. Those rows are considered to be part of the operator class definition — this is not unlike the way that a relation is defined by a single <em>pg_class </em><span style="font-size: medium;"> </span>row plus associated rows in <em>pg_attribute </em><span style="font-size: medium;"> </span>and other tables.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">opcamid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_am.oid</p></td><td class="confluenceTd"><p align="LEFT">Index access method operator class is for.</p></td></tr><tr><td class="confluenceTd"><p>opcname</p></td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Name of this operator class. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>opcnamespace</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_namespace.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Namespace of this operator class</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>opcowner</p></td><td class="confluenceTd" colspan="1"><p>oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Owner of the operator class.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>opcintype</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Data type that the operator class indexes. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>opcdefault</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if this operator class is the default for the data type <em>opcintype</em><span style="font-size: xx-small;"> </span>.</p></td></tr><tr><td class="confluenceTd" colspan="1">opckeytype</td><td class="confluenceTd" colspan="1"> oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Type of data stored in index, or zero if same as <em>opcintype</em><span style="font-size: xx-small;"> </span>.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_namespace">pg_namespace</h2><p>The p<em>g_namespace </em><span style="font-size: medium;"> </span>system catalog table stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1"> References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">nspname</td><td class="confluenceTd">name</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd"><p align="LEFT">Namespace name.</p></td></tr><tr><td class="confluenceTd"><p>nspowner</p></td><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd" colspan="1">pg_authis.oid </td><td class="confluenceTd"><p align="LEFT">Owner of the namespace.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>nspacl</p></td><td class="confluenceTd" colspan="1"><p>aclitem[]</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Access privileges as given by GRANT and REVOKE</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_operator">pg_operator</h2><p align="LEFT">The <em>pg_operator </em><span style="font-size: medium;"> </span>system catalog table stores information about operators, both built-in and those defined by CREATE OPERATOR. Unused column contain zeroes. For example, <em>oprleft </em><span style="font-size: medium;"> </span>is zero for a prefix operator.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">opname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Operator name.</td></tr><tr><td class="confluenceTd">opnamesapce</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_namespace.oid</p></td><td class="confluenceTd"><p align="LEFT">The OID of the namespace that contains this operator.</p></td></tr><tr><td class="confluenceTd"><p>oprowner</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd"><p align="LEFT">Owner of the operator.</p></td></tr><tr><td class="confluenceTd"><p>oprkind</p></td><td class="confluenceTd">char</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">b = infix (both), l = prefix (left), r = postfix (right)</p></td></tr><tr><td class="confluenceTd" colspan="1">oprcanhash </td><td class="confluenceTd" colspan="1"> bool</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">This operator supports hash joins.</p></td></tr><tr><td class="confluenceTd"><p>oprleft</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd"><p align="LEFT">Type of the left operand.</p></td></tr><tr><td class="confluenceTd"><p>oprright</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd"><p align="LEFT">Type of the left operand. </p></td></tr><tr><td class="confluenceTd"><p>oprresult</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd"><p align="LEFT">Type of the result. </p></td></tr><tr><td class="confluenceTd"><p>oprcom</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_operator.oid</p></td><td class="confluenceTd"><p align="LEFT">Commutator of this operator, if any. </p></td></tr><tr><td class="confluenceTd"><p>opnegate</p></td><td class="confluenceTd"> </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Negator of this operator, if any. </p></td></tr><tr><td class="confluenceTd"><p>oprlsortop</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_operator.oid</p></td><td class="confluenceTd"><p align="LEFT">If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L).</p></td></tr><tr><td class="confluenceTd"><p>oprrsortop I</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_operator.oid</p></td><td class="confluenceTd"><p align="LEFT">If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R).</p></td></tr><tr><td class="confluenceTd"><p>oprltcmpop</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_resqueue.oid</p></td><td class="confluenceTd"><p align="LEFT">If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R).</p></td></tr><tr><td class="confluenceTd"><p>oprgtcmpop</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd"><p align="LEFT">If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R).</p></td></tr><tr><td class="confluenceTd"><p>oprcode</p></td><td class="confluenceTd"><p>regproc </p></td><td class="confluenceTd"><p align="LEFT">pg_proc.oid</p></td><td class="confluenceTd"><p align="LEFT">Function that implements this operator.</p></td></tr><tr><td class="confluenceTd"><p>oprrest</p></td><td class="confluenceTd"><p>regproc </p></td><td class="confluenceTd"><p align="LEFT">pg_proc.oid</p></td><td class="confluenceTd"><p align="LEFT">Restriction selectivity estimation function for this operator.</p></td></tr><tr><td class="confluenceTd"><p>oprjoin</p></td><td class="confluenceTd"><p>regproc </p></td><td class="confluenceTd"><p align="LEFT">pg_proc.oid</p></td><td class="confluenceTd"><p align="LEFT">Join selectivity estimation function for this operator. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partition">pg_partition</h2><p align="LEFT">The <em>pg_partition </em><span style="font-size: medium;"> </span>system catalog table is used to track partitioned tables and their inheritance level relationships. Each row of <em>pg_partition </em><span style="font-size: medium;"> </span>represents either the level of a partitioned table in the partition hierarchy, or a subpartition template description. The value of the attribute <em>paristemplate </em><span style="font-size: medium;"> </span>determines what a particular row represents.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">parrelid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid</p></td><td class="confluenceTd"><p align="LEFT">The object identifier of the table.</p></td></tr><tr><td class="confluenceTd"><p>pakind</p></td><td class="confluenceTd">char</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">The partition type - R for range or L for list. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parlevel</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The partition level of this row: 0 for the top-level parent table, 1 for the first level under the parent table, 2 for the second level, and so on. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>paristemplate</p></td><td class="confluenceTd" colspan="1"><p>boolean</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Whether or not this row represents a subpartition template definition (true) or an actual partitioning level (false).</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parnatts</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_attribute.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The number of attributes that define this level.</p></td></tr><tr><td class="confluenceTd" colspan="1">paratts</td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">An array of the attribute numbers (as in pg_attribute.attnum) of the attributes that participate in defining this level.</p></td></tr><tr><td class="confluenceTd" colspan="1"> parclass</td><td class="confluenceTd" colspan="1">oidvector </td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_opclass.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The operator class identifier(s) of the partition columns.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partition_columns">pg_partition_columns</h2><p align="LEFT">The <em>pg_partition_columns </em><span style="font-size: medium;"> </span>system view is used to show the partition key columns of a partitioned table.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>schemaname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the schema where the partitioned table is located.</p></td></tr><tr><td class="confluenceTd"><p>tablename</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the top-level parent table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>columnname</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the partition key column </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionlevel</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"><p align="LEFT">The level of this subpartition in the hierarchy.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>position_in_partition_key</p></td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"><p align="LEFT">For list partitions you can have a composite (multi-column) partition key. This shows the position of the column in a composite key.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partition_encoding">pg_partition_encoding</h2><p><span style="font-family: Times New Roman , Times New Roman;font-size: medium;"><span style="font-family: Times New Roman , Times New Roman;font-size: medium;">The </span></span><em><span style="font-family: Times New Roman , Times New Roman;font-size: medium;"><span style="font-family: Times New Roman , Times New Roman;font-size: medium;">pg_partition_encoding </span></span></em><span style="font-family: Times New Roman , Times New Roman;font-size: medium;"><span style="font-family: Times New Roman , Times New Roman;font-size: medium;">system catalog table describes the available column compression options for a partition template.</span></span> </p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">Modifiers </th><th class="confluenceTh" colspan="1">Storage</th></tr><tr><td class="confluenceTd"><p>parecoid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd" colspan="1">not null</td><td class="confluenceTd" colspan="1">plain </td></tr><tr><td class="confluenceTd"><p>parecattnum</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd" colspan="1">not null </td><td class="confluenceTd" colspan="1">plain </td></tr><tr><td class="confluenceTd" colspan="1"><p>parecattoptions</p></td><td class="confluenceTd" colspan="1">text[]</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">extended </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partition_rule">pg_partition_rule</h2><p align="LEFT">The p<em>g_partition_rule </em><span style="font-size: medium;"> </span>system catalog table is used to track partitioned tables, their check constraints, and data containment rules. Each row of <em>pg_partition_rule </em><span style="font-size: medium;"> </span>represents either a leaf partition (the bottom level partitions that contain data), or a branch partition (a top or mid-level partition that is used to define the partition hierarchy, but does not contain any data).</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>paroid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_partition.oid</p><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Row identifier of the partitioning level (from pg_partition) to which this partition belongs. In the case of a branch partition, the corresponding table (identified by parchildrelid) is an empty container table. In case of a leaf partition, the table contains the rows for that partition containment rule.</p></td></tr><tr><td class="confluenceTd"><p>parchildrelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The table identifier of the partition (child table). </p></td></tr><tr><td class="confluenceTd"><p>parparentrule</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_partition_rule.paroid </p></td><td class="confluenceTd"><p align="LEFT">The row identifier of the rule associated with the parent table of this partition. </p></td></tr><tr><td class="confluenceTd"><p>parname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">The given name of this partition. </p></td></tr><tr><td class="confluenceTd"><p>parisdefault</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Whether or not this partition is a default partition.</p></td></tr><tr><td class="confluenceTd"><p>parruleord</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, the rank of this partition on this level of the partition hierarchy. </p></td></tr><tr><td class="confluenceTd"><p>parrangestartincl</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, whether or not the starting value is inclusive. </p></td></tr><tr><td class="confluenceTd"><p>parrangeendincl</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, whether or not the ending value is inclusive</p></td></tr><tr><td class="confluenceTd"><p>parrangestart</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, the starting value of the range. </p></td></tr><tr><td class="confluenceTd"><p>parrangeend</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, the ending value of the range. </p></td></tr><tr><td class="confluenceTd"><p>parrangeevery</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For range partitioned tables, the interval value of the EVERY clause. </p></td></tr><tr><td class="confluenceTd"><p>parlistvalues</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">For list partitioned tables, the list of values assigned to this partition. </p></td></tr><tr><td class="confluenceTd"><p>parreloptions</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">An array describing the storage characteristics of the particular partition. </p></td></tr><tr><td class="confluenceTd" colspan="1">partemplatespace </td><td class="confluenceTd" colspan="1">oid </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partition_templates">pg_partition_templates</h2><p align="LEFT">The <em>pg_partition_templates </em><span style="font-size: medium;"> </span>system view is used to show the subpartitions that were created using a subpartition template.</p><p align="LEFT"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>schemaname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the schema where the partitioned table is located.</p></td></tr><tr><td class="confluenceTd"><p>tablename</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the top-level parent table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionname</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the subpartition (this is the name to use if referring to the partition in an ALTER TABLE command). NULL if the partition was not given a name at create time or generated by an EVERY clause.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitiontype </td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of subpartition (range or list).</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionlevel</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"><p align="LEFT">The level of this subpartition in the hierarchy.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionrank </td><td class="confluenceTd" colspan="1">bigint </td><td class="confluenceTd" colspan="1"><p align="LEFT">For range partitions, the rank of the partition compared to other partitions of the same level. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionposition </td><td class="confluenceTd" colspan="1">smallint </td><td class="confluenceTd" colspan="1"><p align="LEFT">The rule order position of this subpartition. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionlistvalues </td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">For list partitions, the list value(s) associated with this subpartition. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionrangestart</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">For range partitions, the start value of this subpartition. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionstartinclusive</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">T if the start value is included in this subpartition. F if it is excluded.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionendinclusive </p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">T if the end value is included in this subpartition. F if it is excluded.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitioneveryclause</p></td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The EVERY clause (interval) of this subpartition.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionisdefault </td><td class="confluenceTd" colspan="1"> Boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">T if this is a default subpartition, otherwise F.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionboundary</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The entire partition specification for this subpartition.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_partitions">pg_partitions</h2><p align="LEFT">The <em>pg_partitions </em><span style="font-size: medium;"> </span>system view is used to show the structure of a partitioned table.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>schemaname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the schema where the partitioned table is located.</p></td></tr><tr><td class="confluenceTd"><p>tablename</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the top-level parent table.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionschemaname </td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1"><p>partitiontablename</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The relation name of the partitioned table (this is the table name to use if accessing the partition directly). </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionname </td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the partition (this is the name to use if referring to the partition in an ALTER TABLE command). NULL if the partition was not given a name at create time or generated by an EVERY clause.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parentpartitiontablename </p></td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"><p align="LEFT">The relation name of the parent table one level up from this partition.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parentpartitionname</p></td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"><p align="LEFT">The given name of the parent table one level up from this partition. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitiontype</p></td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of partition (range or list). </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionlevel</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"><p align="LEFT">The level of this partition in the hierarchy.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionrank </td><td class="confluenceTd" colspan="1">bigint </td><td class="confluenceTd" colspan="1"><p align="LEFT">For range partitions, the rank of the partition compared to other partitions of the same level. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionposition </td><td class="confluenceTd" colspan="1">smallint </td><td class="confluenceTd" colspan="1"><p align="LEFT">The rule order position of this partition. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionlistvalues </td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">For list partitions, the list value(s) associated with this partition. </p></td></tr><tr><td class="confluenceTd" colspan="1">partitionrangestart</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">For range partitions, the start value of this partition. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionstartinclusive</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">T if the start value is included in this partition. F if it is excluded.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionrangeend </p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">For range partitions, the end value of this partition.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionendinclusive</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">T if the end value is included in this partition. F if it is excluded</p></td></tr><tr><td class="confluenceTd" colspan="1">partitioneveryclause</td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The EVERY clause (interval) of this partition.</p></td></tr><tr><td class="confluenceTd" colspan="1">partitionisdefault </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">partitionboundary </td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1"> parenttablespace</td><td class="confluenceTd" colspan="1"> name</td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1"> partitiontablespace</td><td class="confluenceTd" colspan="1"> name</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_pltemplate">pg_pltemplate</h2><p align="LEFT">The <em>pg_pltemplate </em><span style="font-size: medium;"> </span>system catalog table stores template information for procedural languages. A template for a language allows the language to be created in a particular database by a simple CREATE LANGUAGE command, with no need to specify implementation details. Unlike most system catalogs, <em>pg_pltemplate </em><span style="font-size: medium;"> </span>is shared across all databases of a HAWQ system: there is only one copy of <em>pg_pltemplate </em><span style="font-size: medium;"> </span>per system, not one per database. This allows the information to be accessible in each database as it is needed.</p><p align="LEFT">There are not currently any commands that manipulate procedural language templates; to change the built-in information, a superuser must modify the table using ordinary INSERT, DELETE, or UPDATE commands.<span style="font-size: medium;"><span style="font-size: medium;"> </span></span></p><p align="LEFT"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>tmplname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">Name of the language for this template.</p></td></tr><tr><td class="confluenceTd"><p>tmpltrusted</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"><p align="LEFT">True if language is considered trusted. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tmplhandler</p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">Name of call handler function. </p></td></tr><tr><td class="confluenceTd" colspan="1">tmplvalidator</td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">Name of validator function, or NULL if none.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tmpllibrary </p></td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">Path of shared library that implements language. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tmplacl</p></td><td class="confluenceTd" colspan="1">aclitem[] </td><td class="confluenceTd" colspan="1"><p align="LEFT">Access privileges for template (not yet implemented). </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_proc">pg_proc</h2><p align="LEFT">The <em>pg_proc </em><span style="font-size: medium;"> </span>system catalog table stores information about functions (or procedures), both built-in functions and those defined by CREATE FUNCTION. The table contains data for aggregate and window functions as well as plain functions. If <em>proisagg </em><span style="font-size: medium;"> </span>is true, there should be a matching row in <em>pg_aggregate</em><span style="font-size: medium;"> </span>. If <em>proiswin </em><span style="font-size: medium;"> </span>is true, there should be a matching row in <em>pg_window</em><span style="font-size: medium;"> </span>.</p><p align="LEFT">For compiled functions, both built-in and dynamically loaded, <em>prosrc </em><span style="font-size: medium;"> </span>contains the function’s C-language name (link symbol). For all other currently-known language types, <em>prosrc </em><span style="font-size: medium;"> </span>contains the function’s source text. <em>probin </em><span style="font-size: medium;"> </span>is unused except for dynamically-loaded C functions, for which it gives the name of the shared library file containing the function.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">proname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Name of the function.</td></tr><tr><td class="confluenceTd">pronamesapce</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_namespace.oid</p></td><td class="confluenceTd"><p align="LEFT">The OID of the namespace that contains this function.</p></td></tr><tr><td class="confluenceTd"><p>proowner</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd"><p align="LEFT">Owner of the function.</p></td></tr><tr><td class="confluenceTd"><p>prolong</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_language.oid </p></td><td class="confluenceTd"><p align="LEFT">Implementation language or call interface of this function.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>proisagg</p></td><td class="confluenceTd" colspan="1"> boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Function is an aggregate function. </p></td></tr><tr><td class="confluenceTd"><p>prosecdef</p></td><td class="confluenceTd"> boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Function is a security definer (for example, a ‘setuid’ function).</p></td></tr><tr><td class="confluenceTd"><p>proisstrict</p></td><td class="confluenceTd"> boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Function returns NULL if any call argument is NULL. In that case the function will not actually be called at all. Functions that are not strict must be prepared to handle NULL inputs.</p></td></tr><tr><td class="confluenceTd"><p>proretset</p></td><td class="confluenceTd"> boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Function returns a set (multiple values of the specified data type).</p></td></tr><tr><td class="confluenceTd"><p>provolatile</p></td><td class="confluenceTd">char</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Tells whether the function’s result depends only on its input arguments, or is affected by outside factors. i = <em>immutable </em><span style="font-size: xx-small;"> </span>(always delivers the same result for the same inputs), s = <em>stable </em><span style="font-size: xx-small;"> </span>(results (for fixed inputs) do not change within a scan), or v = <em>volatile </em><span style="font-size: xx-small;"> </span>(results may change at any time or functions with side-effects).</p></td></tr><tr><td class="confluenceTd"><p>pronargs</p></td><td class="confluenceTd">int2 </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Number of arguments.</p></td></tr><tr><td class="confluenceTd"><p>prorettype</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd"><p align="LEFT">Data type of the return value. </p></td></tr><tr><td class="confluenceTd"><p>proiswin</p></td><td class="confluenceTd"> boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Function is neither an aggregate nor a scalar function, but a pure window function. </p></td></tr><tr><td class="confluenceTd" colspan="1">prodataaccess </td><td class="confluenceTd" colspan="1">char </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_resourcetype">pg_resourcetype</h2><p align="LEFT"><span style="font-size: medium;"><span style="font-size: large;">T</span></span>he <em>pg_resourcetype </em><span style="font-size: medium;"> </span>system catalog table contains information about the extended attributes that can be assigned to HAWQ resource queues. Each row details an attribute and inherent qualities such as its default setting, whether it is required, and the value to disable it (when allowed).</p><p align="LEFT">This table is populated only on the master. This table is defined in the <em>pg_global </em><span style="font-size: medium;"> </span>tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>restypid</p></td><td class="confluenceTd">smallint</td><td class="confluenceTd"><p align="LEFT">The resource type ID.</p></td></tr><tr><td class="confluenceTd"><p>resname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of theresource type.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>resrequired</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">Whether the resource type is required for a valid resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>reshasdefault</p> </td><td class="confluenceTd" colspan="1"> boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">Whether the resource type has a default value. When true, the default value is specified in <em>reshasdefaultsetting</em><span style="font-size: xx-small;"> </span>.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>rescandisable</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">Whether the type can be removed or disabled. When true, the default value is specified in <em>resdisabledsetting </em><span style="font-size: xx-small;"> </span></p></td></tr><tr><td class="confluenceTd" colspan="1"><p>resdefaultsetting</p></td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"><p align="LEFT">Default setting for the resource type, when applicable. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>resdisabledsetting</p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The value that disables this resource type (when allowed). </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_resqueue">pg_resqueue</h2><p align="LEFT">The <em>pg_resqueue </em><span style="font-size: medium;"> </span>system catalog table contains information about HAWQ resource queues, which are used for the workload management feature. This table is populated only on the master. This table is defined in the <em>pg_global </em><span style="font-size: medium;"> </span>tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>rsqname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT">The name of the resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>rsqcountlimit</p></td><td class="confluenceTd" colspan="1">real</td><td class="confluenceTd" colspan="1"><p align="LEFT">The active query threshold of the resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>rsqcostlimit</p></td><td class="confluenceTd" colspan="1">real</td><td class="confluenceTd" colspan="1"><p align="LEFT">The query cost threshold of the resource queue. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>rsqovercommit</p></td><td class="confluenceTd" colspan="1">Boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT">Allows queries that exceed the cost threshold to run when the system is idle. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>rsqignorecostlimit</p></td><td class="confluenceTd" colspan="1">real</td><td class="confluenceTd" colspan="1"><p align="LEFT">The query cost limit of what is considered a ‘small query’. Queries with a cost under this limit will not be queued and run immediately. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_resqueue_attributes">pg_resqueue_attributes</h2><p>The <em>pg_resqueue_attributes </em><span style="font-size: medium;"> </span>view allows administrators to see the attributes set for a resource queue, such as its active statement limit, query cost limits, and priority.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">References </th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>rsqname</p></td><td class="confluenceTd">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_resqueue.rsqname</p></td><td class="confluenceTd"><p align="LEFT">The name of the resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>resname</p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the resource queue attribute. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ressetting</p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The current value of a resource queue attribute. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>restypid</p></td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">System assigned resource type id. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_resqueuecapability">pg_resqueuecapability</h2><p>The p<em>g_resqueuecapability </em><span style="font-size: medium;"> </span>system catalog table contains information about the extended attributes, or capabilities, of existing HAWQ resource queues. Only resource queues that have been assigned an extended capability, such as a priority setting, are recorded in this table. This table is joined to the <em>pg_resqueue </em><span style="font-size: medium;"> </span>table by resource queue object ID, and to the <em>pg_resourcetype </em><span style="font-size: medium;"> </span>table by resource type ID (<em>restypid</em><span style="font-size: medium;"> </span>).</p><p>This table is populated only on the master. This table is defined in the <em>pg_global </em><span style="font-size: medium;"> </span>tablespace, meaning it is globally shared across all databases in the system.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">References </th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>rsqname</p></td><td class="confluenceTd">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_resqueue.oid</p></td><td class="confluenceTd"><p align="LEFT">The object ID of the associated resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>restypid</p></td><td class="confluenceTd" colspan="1">smallint</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The resource type, derived from the pg_resourcetype system table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ressetting</p></td><td class="confluenceTd" colspan="1">opague type</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The specific value set for the capability referenced in this record. Depending on the actual resource type, this value may have different data types.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_rewrite">pg_rewrite</h2><p>The <em>pg_rewrite </em><span style="font-size: medium;"> </span>system catalog table stores rewrite rules for tables and views. <em>pg_class.relhasrules </em><span style="font-size: medium;"> </span>must be true if a table has any rules in this catalog.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">References </th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>rulename</p></td><td class="confluenceTd">name</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Rule name.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ev_class</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1">pg_class.oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">Rule specific to table.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ev_attr</p></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The column this rule is for (currently, always zero to indicate the whole table).</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ev_type</p></td><td class="confluenceTd" colspan="1">char</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE. </p></td></tr><tr><td class="confluenceTd" colspan="1">is_instead </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if the rule is an INSTEAD rule. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>ev_qual</p></td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Expression tree (in the form of a nodeToString() representation) for the rule’s qualifying condition.</p></td></tr><tr><td class="confluenceTd" colspan="1"> ev_action</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Query tree (in the form of a nodeToString() representation) for the rule’s action.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_roles">pg_roles</h2><p>The view <em>pg_roles </em><span style="font-size: medium;"> </span>provides access to information about database roles. This is simply a publicly readable view of <em>pg_authid </em><span style="font-size: medium;"> </span>that blanks out the password field. This view explicitly exposes the OID column of the underlying table, since that is needed to do joins to other catalogs.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">rolname</td><td class="confluenceTd">name</td><td class="confluenceTd"> </td><td class="confluenceTd">Role name.</td></tr><tr><td class="confluenceTd">rolsuper</td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd">Role has superuser privileges.</td></tr><tr><td class="confluenceTd">rolinherit</td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd">Role automatically inherits privileges of roles it is a member of.</td></tr><tr><td class="confluenceTd"><p>rolcreaterole</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may create more roles.</p></td></tr><tr><td class="confluenceTd"><p>rolcreatedb</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may create databases.</p></td></tr><tr><td class="confluenceTd"><p>rolcatupdate</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may update system catalogs directly. (Even a superuser may not do this unless this column is true.) </p></td></tr><tr><td class="confluenceTd"><p>rolcanlogin</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may log in. That is, this role can be given as the initial session authorization identifier </p></td></tr><tr><td class="confluenceTd"><p>rolconnlimit</p></td><td class="confluenceTd">int4</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit</p></td></tr><tr><td class="confluenceTd"><p>rolpassword</p></td><td class="confluenceTd">text</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Not the password (always reads as ********)</p></td></tr><tr><td class="confluenceTd"><p>rolvaliduntil</p></td><td class="confluenceTd">timestampz</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Password expiry time (only used for password authentication); NULL if no expiration. </p></td></tr><tr><td class="confluenceTd"><p>rolconfig</p></td><td class="confluenceTd">text[]</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Session defaults for run-time configuration variables. </p></td></tr><tr><td class="confluenceTd"><p>rolresqueue</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_resqueue.oid</p></td><td class="confluenceTd"><p align="LEFT">Object ID of the resource queue this role is assigned to. </p></td></tr><tr><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd"><p align="LEFT">Object ID of role. </p></td></tr><tr><td class="confluenceTd"><p>rolcreaterextgpfd</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may create readable external tables that use the gpfdist protocol. </p></td></tr><tr><td class="confluenceTd"><p>rolcreaterexthttp</p></td><td class="confluenceTd">boolean </td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may create readable external tables that use the gpfdist protocol. </p></td></tr><tr><td class="confluenceTd"><p>rolcreatewextgpfd</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"> </td><td class="confluenceTd"><p align="LEFT">Role may create writable external tables that use the gpfdist protocol. </p></td></tr><tr><td class="confluenceTd" colspan="1">rolcreaterexhdfs </td><td class="confluenceTd" colspan="1"> boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr><tr><td class="confluenceTd" colspan="1">rolcreatewexhdfs </td><td class="confluenceTd" colspan="1"> boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_shdepend">pg_shdepend</h2><p>The <em>pg_shdepend </em><span style="font-size: medium;"> </span>system catalog table records the dependency relationships between database objects and shared objects, such as roles. This information allows the HAWQ Database to ensure that those objects are unreferenced before attempting to delete them. See also <em>pg_depend</em><span style="font-size: medium;"> </span>, which performs a similar function for dependencies involving objects within a single database. Unlike most system catalogs, <em>pg_shdepend </em><span style="font-size: medium;"> </span>is shared across all databases in a HAWQ system: there is only one copy of <em>pg_shdepend </em><span style="font-size: medium;"> </span>per system, not one per database.</p><p>In all cases, a <em>pg_shdepend </em><span style="font-size: medium;"> </span>entry indicates that the referenced object may not be dropped without also dropping the dependent object. However, there are several subflavors identified by <em>deptype</em><span style="font-size: medium;"> </span>:</p><ul><li>SHARED_DEPENDENCY_OWNER (o) <span style="font-size: medium;"> </span>— The referenced object (which must be a role) is the owner of the dependent object.</li><li>SHARED_DEPENDENCY_ACL (a) — The referenced object (which must be a role) is mentioned in the ACL (access control list) of the dependent object.</li><li>SHARED_DEPENDENCY_PIN (p) — There is no dependent object; this type of entry is a signal that the system itself depends on the referenced object, and so that object must never be deleted. Entries of this type are created only by system initialization. The columns for the dependent object contain zeroes<span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></li></ul><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">dbid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_database.oid</p></td><td class="confluenceTd"><p align="LEFT">The OID of the database the dependent object is in, or zero for a shared object.</p></td></tr><tr><td class="confluenceTd"><p>classid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID of the system catalog the dependent object is in.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>obid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">any OID column </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID of the specific dependent object.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>refclassid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">any OID column</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID of the system catalog the referenced object is in (must be a shared catalog). </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>refobjid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID of the specific referenced object. </p></td></tr><tr><td class="confluenceTd" colspan="1">deptype </td><td class="confluenceTd" colspan="1">char </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">A code defining the specific semantics of this dependency relationship.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_shdescription">pg_shdescription</h2><p>The <em>pg_shdescription </em><span style="font-size: medium;"> </span>system catalog table stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql’s \d meta-commands. See also <em>pg_description</em><span style="font-size: medium;"> </span>, which performs a similar function for descriptions involving objects within a single database. Unlike most system catalogs, <em>pg_shdescription </em><span style="font-size: medium;"> </span>is shared across all databases in a HAWQ system: there is only one copy of <em>pg_shdescription </em><span style="font-size: medium;"> </span>per system, not one per database.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">objoid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">any OID column </p></td><td class="confluenceTd"><p align="LEFT">The OID of the object this description pertains to.</p></td></tr><tr><td class="confluenceTd"><p>classoid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID of the catalog where this object appears..</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>description</p></td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Arbitrary text that serves as the description of this object. </p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_activity">pg_stat_activity</h2><p>The view <em>pg_stat_activity </em><span style="font-size: medium;"> </span>shows one row per server process and details about it associated user session and query. The columns that report data on the current query are available unless the parameter <em>stats_command_string </em><span style="font-size: medium;"> </span>has been turned off. Furthermore, these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on.</p><p>The maximum length of the query text sting stored in the column current_query can be controlled with the server configuration parameter pgstat_track_activity_query_size.</p><p><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">dataid</td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_database.oid</p></td><td class="confluenceTd"><p align="LEFT">Database OID.</p></td></tr><tr><td class="confluenceTd"><p>datname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Database name.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>procpid</p></td><td class="confluenceTd" colspan="1">integer</td><td class="confluenceTd" colspan="1"><span style="background-color: rgb(237,245,255);"> </span></td><td class="confluenceTd" colspan="1"><p align="LEFT">Process ID of the server process</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>sess_id</p></td><td class="confluenceTd" colspan="1"><p>integer</p></td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Session ID </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>usesysid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_type.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Role OID</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>usename</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Role name </p></td></tr><tr><td class="confluenceTd" colspan="1">current_query</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> Current query that process is running</td></tr><tr><td class="confluenceTd" colspan="1"><p>waiting</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">True if waiting on a lock, false if not waiting</p></td></tr><tr><td class="confluenceTd" colspan="1">query_start</td><td class="confluenceTd" colspan="1"><p>timestampz</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Time query began execution</p></td></tr><tr><td class="confluenceTd" colspan="1">backend_start</td><td class="confluenceTd" colspan="1"><p>timestampz</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Time backend process was started </p></td></tr><tr><td class="confluenceTd" colspan="1">client_addr</td><td class="confluenceTd" colspan="1">inet </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Client address </p></td></tr><tr><td class="confluenceTd" colspan="1">client_port</td><td class="confluenceTd" colspan="1"> integer</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Client port</p></td></tr><tr><td class="confluenceTd" colspan="1">application_name</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Client application name</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>xact_start</p></td><td class="confluenceTd" colspan="1">timestampz</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Transaction start time</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_last_operation">pg_stat_last_operation</h2><p>The <em>pg_stat_last_operation </em><span style="font-size: medium;"> </span>table contains metadata tracking information about database objects (tables, views, etc.).</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>classoid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID of the system catalog where this object appears. </p></td></tr><tr><td class="confluenceTd" colspan="1">objoid </td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">any OID column </p></td><td class="confluenceTd" colspan="1">OID of the object in the system catalog.</td></tr><tr><td class="confluenceTd"><p>staactionname </p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Action taken on the object. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stasysid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">A foreign key to pg_authid.oid. </p></td></tr><tr><td class="confluenceTd" colspan="1">stausename </td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the role that performed the operation on this object.</p></td></tr><tr><td class="confluenceTd" colspan="1">stasubtype</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of object operated on or the subclass of operation performed.</p></td></tr><tr><td class="confluenceTd" colspan="1">statime</td><td class="confluenceTd" colspan="1"><p>timestamp with timezone</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The timestamp of the operation. This is the same timestamp that is written to the HAWQ Database server log files in case you need to look up more detailed information about the operation in the logs.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_last_shoperation">pg_stat_last_shoperation</h2><p>The <em>pg_stat_last_shoperation </em><span style="font-size: medium;"> </span>table contains metadata tracking information about global objects (roles, tablespaces, etc.)</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>classid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID of the system catalog where this object appears. </p></td></tr><tr><td class="confluenceTd" colspan="1">objoid </td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">any OID column </p></td><td class="confluenceTd" colspan="1">OID of the object in the system catalog.</td></tr><tr><td class="confluenceTd"><p>staactionname </p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Action taken on the object. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stasysid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd" colspan="1">stausename </td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the role that performed the operation on this object.</p></td></tr><tr><td class="confluenceTd" colspan="1">stasubtype</td><td class="confluenceTd" colspan="1">text </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of object operated on or the subclass of operation performed.</p></td></tr><tr><td class="confluenceTd" colspan="1">statime</td><td class="confluenceTd" colspan="1"><p>timestamp with timezone</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The timestamp of the operation. This is the same timestamp that is written to the HAWQ Database server log files in case you need to look up more detailed information about the operation in the logs.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_operations">pg_stat_operations</h2><p>The view <em>pg_stat_operations </em><span style="font-size: medium;"> </span>shows details about the last operation performed on a database object (such as a table, index, view or database) or a global object (such as a role).<span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>classname</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The name of the system table in the <em>pg_catalog </em><span style="font-size: xx-small;"> </span>schema where the record about this object is stored (<em>pg_class</em><span style="font-size: xx-small;"> </span>=relations, <em>pg_database</em><span style="font-size: xx-small;"> </span>=databases, pg_namespace =schemas, pg_authid =roles)</p></td></tr><tr><td class="confluenceTd" colspan="1">objname</td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the object.</p></td></tr><tr><td class="confluenceTd"><p>objid </p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">The OID of the object.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>schemaname</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the schema where the object resides. </p></td></tr><tr><td class="confluenceTd" colspan="1">usestatus</td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The status of the role who performed the last operation on the object (<em>CURRENT</em><span style="font-size: xx-small;"> </span>=a currently active role in the system, <em>DROPPED</em><span style="font-size: xx-small;"> </span>=a role that no longer exists in the system, <em>CHANGED</em><span style="font-size: xx-small;"> </span>=a role name that exists in the system, but has changed since the last operation was performed).</p></td></tr><tr><td class="confluenceTd" colspan="1">usename</td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the role that performed the operation on this object. </p></td></tr><tr><td class="confluenceTd" colspan="1">actionname</td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"><p align="LEFT">The action that was taken on the object. </p></td></tr><tr><td class="confluenceTd" colspan="1">subtype</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of object operated on or the subclass of operation performed. </p></td></tr><tr><td class="confluenceTd" colspan="1">statime</td><td class="confluenceTd" colspan="1"><p>timestamp with timezone</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The timestamp of the operation. This is the same timestamp that is written to the HAWQ Database server log files in case you need to look up more detailed information about the operation in the logs.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_partition_operations">pg_stat_partition_operations</h2><p>The view <em>pg_stat_partition_operations </em><span style="font-size: medium;"> </span>shows details about the last operation performed on a partitioned table.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>classname</p></td><td class="confluenceTd">text</td><td class="confluenceTd"><p align="LEFT">The name of the system table in the <em>pg_catalog </em><span> </span>schema where the record about this object is stored (<em>pg_class</em><span> </span>=relations, <em>pg_database</em><span> </span>=databases, pg_namespace =schemas, pg_authid =roles)</p></td></tr><tr><td class="confluenceTd" colspan="1">objname</td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the object.</p></td></tr><tr><td class="confluenceTd"><p>objid </p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">The OID of the object.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>schemaname</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the schema where the object resides. </p></td></tr><tr><td class="confluenceTd" colspan="1">usestatus</td><td class="confluenceTd" colspan="1">text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The status of the role who performed the last operation on the object (<em>CURRENT</em><span> </span>=a currently active role in the system, <em>DROPPED</em><span> </span>=a role that no longer exists in the system, <em>CHANGED</em><span> </span>=a role name that exists in the system, but has changed since the last operation was performed).</p></td></tr><tr><td class="confluenceTd" colspan="1">usename</td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the role that performed the operation on this object. </p></td></tr><tr><td class="confluenceTd" colspan="1">actionname</td><td class="confluenceTd" colspan="1">name </td><td class="confluenceTd" colspan="1"><p align="LEFT">The action that was taken on the object. </p></td></tr><tr><td class="confluenceTd" colspan="1">subtype</td><td class="confluenceTd" colspan="1"> text</td><td class="confluenceTd" colspan="1"><p align="LEFT">The type of object operated on or the subclass of operation performed. </p></td></tr><tr><td class="confluenceTd" colspan="1">statime</td><td class="confluenceTd" colspan="1"><p>timestamp with timezone</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The timestamp of the operation. This is the same timestamp that is written to the HAWQ Database server log files in case you need to look up more detailed information about the operation in the logs.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>partitionlevel</p></td><td class="confluenceTd" colspan="1"><p>smallint</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The level of this partition in the hierarchy.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parenttablename </p></td><td class="confluenceTd" colspan="1"><p>name</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The relation name of the parent table one level up from this partition.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parentschemaname</p></td><td class="confluenceTd" colspan="1"><p>name</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the schema where the parent table resides.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>parent_relid</p></td><td class="confluenceTd" colspan="1"><p>oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID of the parent table one level up from this partition.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_statistic">pg_statistic</h2><p>The <em>pg_statistic </em><span style="font-size: medium;"> </span>system catalog table stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the query planner. There is one entry for each table column that has been analyzed. Note that all the statistical data is inherently approximate, even assuming that it is up-to-date.</p><p>pg_statistic also stores statistical data about the values of index expressions. These are described as if they were actual data columns; in particular, <em>starelid </em><span style="font-size: medium;"> </span>references the index. No entry is made for an ordinary non-expression index column, however, since it would be redundant with the entry for the underlying table column.</p><p>Since different kinds of statistics may be appropriate for different kinds of data, <em>pg_statistic </em><span style="font-size: medium;"> </span>is designed not to assume very much about what sort of statistics it stores. Only extremely general statistics (such as nullness) are given dedicated columns in <em>pg_statistic</em><span style="font-size: medium;"> </span>. Everything else is stored in slots, which are groups of associated columns whose content is identified by a code number in one of the slot’s columns.</p><p>pg_statistic should not be readable by the public, since even statistical information about a table’s contents may be considered sensitive (for example: minimum and maximum values of a salary column). <em>pg_stats </em><span style="font-size: medium;"> </span>is a publicly readable view on <em>pg_statistic </em><span style="font-size: medium;"> </span>that only exposes information about those tables that are readable by the current user.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>starelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid </p></td><td class="confluenceTd"><p align="LEFT">The table or index that the described column belongs to.</p></td></tr><tr><td class="confluenceTd" colspan="1">staattnum</td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_attribute.attnum</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The number of the described column </p></td></tr><tr><td class="confluenceTd"><p>stanullfrac</p></td><td class="confluenceTd">float4</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">The fraction of the column’s entries that are null. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stawidth</p></td><td class="confluenceTd" colspan="1">int4</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The average stored width, in bytes, of nonnull entries. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stadistinct</p> </td><td class="confluenceTd" colspan="1">float4 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The number of distinct nonnull data values in the column. A value greater than zero is the actual number of distinct values. A value less than zero is the negative of a fraction of the number of rows in the table (for example, a column in which values appear about twice on the average could be represented by stadistinct = -0.5). A zero value means the number of distinct values is unknown.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stakind<em>N </em></p><em><span style="font-size: xx-small;"> </span></em><span style="font-size: xx-small;"> </span></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">A code number indicating the kind of statistics stored in the <em>N</em><span style="font-size: xx-small;"> </span>th slot of the pg_statistic row.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_stat_resqueues">pg_stat_resqueues</h2><p>The <em>pg_stat_resqueues </em><span style="font-size: medium;"> </span>view allows administrators to view metrics about a resource queue’s workload over time. To allow statistics to be collected for this view, you must enable the <em>stats_queue_level </em><span style="font-size: medium;"> </span>server configuration parameter on the HAWQ Database master instance. Enabling the collection of these metrics does incur a small performance penalty, as each statement submitted through a resource queue must be logged in the system catalog tables.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>queueoid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">The OID of the resource queue. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>queuename</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT">The name of the resource queue.</p></td></tr><tr><td class="confluenceTd"><p>n_queries_exec</p></td><td class="confluenceTd">bigint</td><td class="confluenceTd"><p align="LEFT">Number of queries submitted for execution from this resource queue. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>n_queries_wait</p></td><td class="confluenceTd" colspan="1">bigint</td><td class="confluenceTd" colspan="1"><p align="LEFT">Number of queries submitted to this resource queue that had to wait before they could execute.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>elapsed_exec </p></td><td class="confluenceTd" colspan="1">bigint </td><td class="confluenceTd" colspan="1"><p align="LEFT">Total elapsed execution time for statements submitted through this resource queue.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>elapsed_wait<span> </span></p></td><td class="confluenceTd" colspan="1">bigint</td><td class="confluenceTd" colspan="1"><p align="LEFT">Total elapsed time that statements submitted through this resource queue had to wait before they were executed.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_tablespace">pg_tablespace</h2><p>The <em>pg_tablespace </em><span style="font-size: medium;"> </span>system catalog table stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout. Unlike most system catalogs, <em>pg_tablespace </em><span style="font-size: medium;"> </span>is shared across all databases of a HAWQ system: there is only one copy of <em>pg_tablespace </em><span style="font-size: medium;"> </span>per system, not one per database.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>spcname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Tablespace name.</p><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd" colspan="1">spcowner</td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_authid.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Owner of the tablespace, usually the user who created it.</p><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd"><p>spcacl</p></td><td class="confluenceTd">aclitem[]</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Tablespace access privileges.</p><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>spcfsoid</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_filespace.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The object id of the filespace used by this tablespace. A filespace defines directory locations on the primary, mirror and master segments.</p><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>stakind<em>N </em></p><em><span> </span></em><span> </span></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">A code number indicating the kind of statistics stored in the <em>N</em><span> </span>th slot of the pg_statistic row.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_trigger">pg_trigger</h2><p>The <em>pg_trigger </em><span style="font-size: medium;"> </span>system catalog table stores triggers on tables.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>tgrelid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_class.oid</p><p align="LEFT">Note that HAWQ does not enforce referential integrity.</p></td><td class="confluenceTd"><p align="LEFT">The table name where this trigger is set.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tgname</p></td><td class="confluenceTd" colspan="1">name</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Unique trigger name (trigger names must be unique for the same table).</p></td></tr><tr><td class="confluenceTd"><p>tgfoid</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_proc.oid</p><p align="LEFT">Note that HAWQ does not enforce referential integrity. </p></td><td class="confluenceTd"><p align="LEFT">The function to be called.</p><p align="LEFT"> </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tgtype</p></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_authid.oid </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Bit mask identifying trigger conditions. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tgenabled </p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if trigger is enabled.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>tgisconstraint </p></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if a trigger implements a referential integrity constraint.</p></td></tr><tr><td class="confluenceTd" colspan="1"> tgconstrname</td><td class="confluenceTd" colspan="1"> name</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">Referential integrity constraint name. </td></tr><tr><td class="confluenceTd" colspan="1"> tgconstrrelid</td><td class="confluenceTd" colspan="1">oid </td><td class="confluenceTd" colspan="1"><p>pg_class.oid</p><p>Note that HAWQ does not enforce referential integrity.</p></td><td class="confluenceTd" colspan="1">The table referenced by a referential integrity constraint. </td></tr><tr><td class="confluenceTd" colspan="1">tgdeferrable </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">True if deferrable. </td></tr><tr><td class="confluenceTd" colspan="1">tginitdeferred </td><td class="confluenceTd" colspan="1">boolean </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">True if initially deferred. </td></tr><tr><td class="confluenceTd" colspan="1">tgnargs</td><td class="confluenceTd" colspan="1">int2 </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">Number of argument strings passed to trigger function. </td></tr><tr><td class="confluenceTd" colspan="1"> tgargs </td><td class="confluenceTd" colspan="1"> bytea </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"> Argument strings to pass to trigger each NULL-terminated.</td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_type">pg_type</h2><p>The <em>pg_type </em><span style="font-size: medium;"> </span>system catalog table stores information about data types. Base types (scalar types) are created with CREATE TYPE, and domains with CREATE DOMAIN. A composite type is automatically created for each table in the database, to represent the row structure of the table. It is also possible to create composite types with CREATE TYPE AS.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>typname</p></td><td class="confluenceTd">name</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">Data type name.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typnamespace</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_namespace.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID of the namespace that contains this type.</p></td></tr><tr><td class="confluenceTd"><p>typowner</p></td><td class="confluenceTd">oid</td><td class="confluenceTd"><p align="LEFT">pg_authid.oid</p></td><td class="confluenceTd"><p align="LEFT">Owner of the type.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typlen</p></td><td class="confluenceTd" colspan="1">int2</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">For a fixed-size type, <em>typlen </em><span style="font-size: xx-small;"> </span>is the number of bytes in the internal representation of the type. But for a variable-length type, <em>typlen </em><span style="font-size: xx-small;"> </span>is negative. -1 indicates a ‘varlena’ type (one that has a length word), -2 indicates a null-terminated C string.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typbyval</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Determines whether internal routines pass a value of this type by value or by reference. <em>typbyval </em><span style="font-size: xx-small;"> </span>had better be false if <em>typlen </em><span style="font-size: xx-small;"> </span>is not 1, 2, or 4 (or 8 on machines where Datum is 8 bytes). Variable-length types are always passed by reference. Note that <em>typbyval </em><span style="font-size: xx-small;"> </span>can be false even if the length would allow pass-by-value; this is currently true for type float4, for example.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typtype</p></td><td class="confluenceTd" colspan="1">char</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">b for a base type, c for a composite type, d for a domain, or p for a pseudo-type.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typisdefined</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">True if the type is defined, false if this is a placeholder entry for a not-yet-defined type. When false, nothing except the type name, namespace, and OID can be relied on.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typdelim</p></td><td class="confluenceTd" colspan="1">char</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Character that separates two values of this type when parsing array input. Note that the delimiter is associated with the array element data type, not the array data type. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>typrelid</p> </td><td class="confluenceTd" colspan="1">oid </td><td class="confluenceTd" colspan="1"> pg_class.oid </td><td class="confluenceTd" colspan="1"><p align="LEFT">If this is a composite type, then this column points to the <em>pg_class </em><span> </span>entry that defines the corresponding table. (For a free-standing composite type, the <em>pg_class </em><span> </span>entry does not really represent a table, but it is needed anyway for the type’s <em>pg_attribute </em><span> </span>entries to link to.) Zero for non-composite types.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_type_encoding">pg_type_encoding</h2><p>The <em>pg_type_encoding </em><span style="font-size: medium;"> </span>system catalog table contains the column storage type information.</p><p><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">Modifiers </th><th class="confluenceTh" colspan="1">Storage</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">typeid</td><td class="confluenceTd">oid</td><td class="confluenceTd" colspan="1">not null </td><td class="confluenceTd" colspan="1">plain </td><td class="confluenceTd"><p align="LEFT">Foreign key to pg_attribute</p></td></tr><tr><td class="confluenceTd"><p>tyoptions</p></td><td class="confluenceTd"><p>text []</p></td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">extended</td><td class="confluenceTd"><p align="LEFT">The actual options.</p></td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_user_mapping">pg_user_mapping</h2><p>The <em>pg_user_mapping </em><span style="font-size: medium;"> </span>catalog stores the mappings from local users to remote users. You must have administrator privileges to view this catalog.</p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh" colspan="1">Modifiers </th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">umuser</td><td class="confluenceTd">oid</td><td class="confluenceTd" colspan="1">pg_authid.oid</td><td class="confluenceTd"><p>OID of the local role being mapped, 0 if the user mapping is public</p></td></tr><tr><td class="confluenceTd"><p>umserver</p></td><td class="confluenceTd"><p>oid</p></td><td class="confluenceTd" colspan="1"><p>pg_foreign_server.oid</p></td><td class="confluenceTd"><p>The OID of the foreign server that contains this mapping.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>umoptions</p> </td><td class="confluenceTd" colspan="1">text [] </td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p>User mapping specific options, as "keyword=value" strings.</p> </td></tr></tbody></table></div><h2 id="SystemCatalogReference-pg_window">pg_window</h2><p>The <em>pg_window </em><span style="font-size: medium;"> </span>table stores information about window functions. Window functions are often used to compose complex OLAP (online analytical processing) queries. Window functions are applied to partitioned result sets within the scope of a single query expression. A window partition is a subset of rows returned by a query, as defined in a special OVER() clause. Typical window functions are rank, dense_rank, and row_number. Each entry in <em>pg_window </em><span style="font-size: medium;"> </span>is an extension of an entry in <em>pg_proc</em><span style="font-size: medium;"> </span>. The <em>pg_proc </em><span style="font-size: medium;"> </span>entry carries the window function’s name, input and output data types, and other information that is similar to ordinary functions.</p><p><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Column</th><th class="confluenceTh">Type</th><th class="confluenceTh">References</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd"><p>winfnoid</p></td><td class="confluenceTd">regproc</td><td class="confluenceTd"><p align="LEFT">pg_proc.oid </p></td><td class="confluenceTd"><p align="LEFT">The OID in the <em>pg_proc </em><span style="font-size: xx-small;"> </span>of the window function.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>winrequireorder</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The window function requires its window specification to have an ORDER BY clause.</p></td></tr><tr><td class="confluenceTd"><p>winallowframe</p></td><td class="confluenceTd">boolean</td><td class="confluenceTd"><p align="LEFT"> </p></td><td class="confluenceTd"><p align="LEFT">The window function permits its window specification to have a ROWS or RANGE framing clause.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>winpeercount</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"><p align="LEFT"> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The peer group row count is required to compute this window function, so the Window node implementation must ‘look ahead’ as necessary to make this available in its internal state.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>wincount</p></td><td class="confluenceTd" colspan="1">boolean</td><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The partition row count is required to compute this window function. </p></td></tr><tr><td class="confluenceTd" colspan="1"><p>winfunc</p></td><td class="confluenceTd" colspan="1">regproc</td><td class="confluenceTd" colspan="1">pg_proc.oid </td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID in <em>pg_proc </em><span style="font-size: xx-small;"> </span>of a function to compute the value of an immediate-type window function.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>winprefunc</p></td><td class="confluenceTd" colspan="1">regproc</td><td class="confluenceTd" colspan="1">pg_proc.oid </td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID in <em>pg_proc </em><span style="font-size: xx-small;"> </span>of a preliminary window function to compute the partial value of a deferred-type window function.</p></td></tr><tr><td class="confluenceTd" colspan="1"><p>winpretype</p></td><td class="confluenceTd" colspan="1">oid</td><td class="confluenceTd" colspan="1"><p align="LEFT">pg_type.oid</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The OID in <em>pg_type </em><span style="font-size: xx-small;"> </span>of the preliminary window function’s result type.</p></td></tr></tbody></table></div><p><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"><span style="font-size: medium;"> </span> </span></span></span></span></span> </span> </span> </span></span> </span></span></span></span></span></span></span></p><p> </p><p> </p><p> </p><p> </p><p> </p>
</div></div>
</div><!-- end of content-->
</div><!-- end of container -->
</div><!--end of container-fluid-->
</div><!--end of main-wrap-->
<div class="site-footer desktop-only">
<div class="container-fluid">
<div class="site-footer-links">
<span class="version"><a href='/'>Pivotal Documentation</a></span>
<span>©
<script>
var d = new Date();
document.write(d.getFullYear());
</script>
<a href='http://gopivotal.com'>Pivotal Software</a> Inc. All Rights Reserved.
</span>
</div>
</div>
</div>
<script type="text/javascript">
(function() {
var didInit = false;
function initMunchkin() {
if(didInit === false) {
didInit = true;
Munchkin.init('625-IUJ-009');
}
}
var s = document.createElement('script');
s.type = 'text/javascript';
s.async = true;
s.src = document.location.protocol + '//munchkin.marketo.net/munchkin.js';
s.onreadystatechange = function() {
if (this.readyState == 'complete' || this.readyState == 'loaded') {
initMunchkin();
}
};
s.onload = initMunchkin;
document.getElementsByTagName('head')[0].appendChild(s);
})();
</script>
</div><!--end of viewport-->
<div id="scrim"></div>
</body>
</html>