Line data Source code
1 : /*-------------------------------------------------------------------------
2 : *
3 : * heapdesc.c
4 : * rmgr descriptor routines for access/heap/heapam.c
5 : *
6 : * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
7 : * Portions Copyright (c) 1994, Regents of the University of California
8 : *
9 : *
10 : * IDENTIFICATION
11 : * src/backend/access/rmgrdesc/heapdesc.c
12 : *
13 : *-------------------------------------------------------------------------
14 : */
15 : #include "postgres.h"
16 :
17 : #include "access/heapam_xlog.h"
18 : #include "access/rmgrdesc_utils.h"
19 : #include "access/visibilitymapdefs.h"
20 : #include "storage/standbydefs.h"
21 :
22 : /*
23 : * NOTE: "keyname" argument cannot have trailing spaces or punctuation
24 : * characters
25 : */
26 : static void
27 61931 : infobits_desc(StringInfo buf, uint8 infobits, const char *keyname)
28 : {
29 61931 : appendStringInfo(buf, "%s: [", keyname);
30 :
31 : Assert(buf->data[buf->len - 1] != ' ');
32 :
33 61931 : if (infobits & XLHL_XMAX_IS_MULTI)
34 0 : appendStringInfoString(buf, "IS_MULTI, ");
35 61931 : if (infobits & XLHL_XMAX_LOCK_ONLY)
36 30440 : appendStringInfoString(buf, "LOCK_ONLY, ");
37 61931 : if (infobits & XLHL_XMAX_EXCL_LOCK)
38 30440 : appendStringInfoString(buf, "EXCL_LOCK, ");
39 61931 : if (infobits & XLHL_XMAX_KEYSHR_LOCK)
40 0 : appendStringInfoString(buf, "KEYSHR_LOCK, ");
41 61931 : if (infobits & XLHL_KEYS_UPDATED)
42 219 : appendStringInfoString(buf, "KEYS_UPDATED, ");
43 :
44 61931 : if (buf->data[buf->len - 1] == ' ')
45 : {
46 : /* Truncate-away final unneeded ", " */
47 : Assert(buf->data[buf->len - 2] == ',');
48 30659 : buf->len -= 2;
49 30659 : buf->data[buf->len] = '\0';
50 : }
51 :
52 61931 : appendStringInfoChar(buf, ']');
53 61931 : }
54 :
55 : static void
56 6 : truncate_flags_desc(StringInfo buf, uint8 flags)
57 : {
58 6 : appendStringInfoString(buf, "flags: [");
59 :
60 6 : if (flags & XLH_TRUNCATE_CASCADE)
61 0 : appendStringInfoString(buf, "CASCADE, ");
62 6 : if (flags & XLH_TRUNCATE_RESTART_SEQS)
63 0 : appendStringInfoString(buf, "RESTART_SEQS, ");
64 :
65 6 : if (buf->data[buf->len - 1] == ' ')
66 : {
67 : /* Truncate-away final unneeded ", " */
68 : Assert(buf->data[buf->len - 2] == ',');
69 0 : buf->len -= 2;
70 0 : buf->data[buf->len] = '\0';
71 : }
72 :
73 6 : appendStringInfoChar(buf, ']');
74 6 : }
75 :
76 : static void
77 596 : plan_elem_desc(StringInfo buf, void *plan, void *data)
78 : {
79 596 : xlhp_freeze_plan *new_plan = (xlhp_freeze_plan *) plan;
80 596 : OffsetNumber **offsets = data;
81 :
82 596 : appendStringInfo(buf, "{ xmax: %u, infomask: %u, infomask2: %u, ntuples: %u",
83 : new_plan->xmax,
84 596 : new_plan->t_infomask, new_plan->t_infomask2,
85 596 : new_plan->ntuples);
86 :
87 596 : appendStringInfoString(buf, ", offsets:");
88 596 : array_desc(buf, *offsets, sizeof(OffsetNumber), new_plan->ntuples,
89 : &offset_elem_desc, NULL);
90 :
91 596 : *offsets += new_plan->ntuples;
92 :
93 596 : appendStringInfoString(buf, " }");
94 596 : }
95 :
96 :
97 : /*
98 : * Given a MAXALIGNed buffer returned by XLogRecGetBlockData() and pointed to
99 : * by cursor and any xl_heap_prune flags, deserialize the arrays of
100 : * OffsetNumbers contained in an XLOG_HEAP2_PRUNE_* record.
101 : *
102 : * This is in heapdesc.c so it can be shared between heap2_redo and heap2_desc
103 : * code, the latter of which is used in frontend (pg_waldump) code.
104 : */
105 : void
106 1424 : heap_xlog_deserialize_prune_and_freeze(char *cursor, uint16 flags,
107 : int *nplans, xlhp_freeze_plan **plans,
108 : OffsetNumber **frz_offsets,
109 : int *nredirected, OffsetNumber **redirected,
110 : int *ndead, OffsetNumber **nowdead,
111 : int *nunused, OffsetNumber **nowunused)
112 : {
113 1424 : if (flags & XLHP_HAS_FREEZE_PLANS)
114 : {
115 494 : xlhp_freeze_plans *freeze_plans = (xlhp_freeze_plans *) cursor;
116 :
117 494 : *nplans = freeze_plans->nplans;
118 : Assert(*nplans > 0);
119 494 : *plans = freeze_plans->plans;
120 :
121 494 : cursor += offsetof(xlhp_freeze_plans, plans);
122 494 : cursor += sizeof(xlhp_freeze_plan) * *nplans;
123 : }
124 : else
125 : {
126 930 : *nplans = 0;
127 930 : *plans = NULL;
128 : }
129 :
130 1424 : if (flags & XLHP_HAS_REDIRECTIONS)
131 : {
132 346 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
133 :
134 346 : *nredirected = subrecord->ntargets;
135 : Assert(*nredirected > 0);
136 346 : *redirected = &subrecord->data[0];
137 :
138 346 : cursor += offsetof(xlhp_prune_items, data);
139 346 : cursor += sizeof(OffsetNumber[2]) * *nredirected;
140 : }
141 : else
142 : {
143 1078 : *nredirected = 0;
144 1078 : *redirected = NULL;
145 : }
146 :
147 1424 : if (flags & XLHP_HAS_DEAD_ITEMS)
148 : {
149 346 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
150 :
151 346 : *ndead = subrecord->ntargets;
152 : Assert(*ndead > 0);
153 346 : *nowdead = subrecord->data;
154 :
155 346 : cursor += offsetof(xlhp_prune_items, data);
156 346 : cursor += sizeof(OffsetNumber) * *ndead;
157 : }
158 : else
159 : {
160 1078 : *ndead = 0;
161 1078 : *nowdead = NULL;
162 : }
163 :
164 1424 : if (flags & XLHP_HAS_NOW_UNUSED_ITEMS)
165 : {
166 352 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
167 :
168 352 : *nunused = subrecord->ntargets;
169 : Assert(*nunused > 0);
170 352 : *nowunused = subrecord->data;
171 :
172 352 : cursor += offsetof(xlhp_prune_items, data);
173 352 : cursor += sizeof(OffsetNumber) * *nunused;
174 : }
175 : else
176 : {
177 1072 : *nunused = 0;
178 1072 : *nowunused = NULL;
179 : }
180 :
181 1424 : *frz_offsets = (OffsetNumber *) cursor;
182 1424 : }
183 :
184 : void
185 135542 : heap_desc(StringInfo buf, XLogReaderState *record)
186 : {
187 135542 : char *rec = XLogRecGetData(record);
188 135542 : uint8 info = XLogRecGetInfo(record) & ~XLR_INFO_MASK;
189 :
190 135542 : info &= XLOG_HEAP_OPMASK;
191 135542 : if (info == XLOG_HEAP_INSERT)
192 : {
193 72303 : xl_heap_insert *xlrec = (xl_heap_insert *) rec;
194 :
195 72303 : appendStringInfo(buf, "off: %u, flags: 0x%02X",
196 72303 : xlrec->offnum,
197 72303 : xlrec->flags);
198 : }
199 63239 : else if (info == XLOG_HEAP_DELETE)
200 : {
201 219 : xl_heap_delete *xlrec = (xl_heap_delete *) rec;
202 :
203 219 : appendStringInfo(buf, "xmax: %u, off: %u, ",
204 219 : xlrec->xmax, xlrec->offnum);
205 219 : infobits_desc(buf, xlrec->infobits_set, "infobits");
206 219 : appendStringInfo(buf, ", flags: 0x%02X", xlrec->flags);
207 : }
208 63020 : else if (info == XLOG_HEAP_UPDATE)
209 : {
210 30466 : xl_heap_update *xlrec = (xl_heap_update *) rec;
211 :
212 30466 : appendStringInfo(buf, "old_xmax: %u, old_off: %u, ",
213 30466 : xlrec->old_xmax, xlrec->old_offnum);
214 30466 : infobits_desc(buf, xlrec->old_infobits_set, "old_infobits");
215 30466 : appendStringInfo(buf, ", flags: 0x%02X, new_xmax: %u, new_off: %u",
216 30466 : xlrec->flags, xlrec->new_xmax, xlrec->new_offnum);
217 : }
218 32554 : else if (info == XLOG_HEAP_HOT_UPDATE)
219 : {
220 806 : xl_heap_update *xlrec = (xl_heap_update *) rec;
221 :
222 806 : appendStringInfo(buf, "old_xmax: %u, old_off: %u, ",
223 806 : xlrec->old_xmax, xlrec->old_offnum);
224 806 : infobits_desc(buf, xlrec->old_infobits_set, "old_infobits");
225 806 : appendStringInfo(buf, ", flags: 0x%02X, new_xmax: %u, new_off: %u",
226 806 : xlrec->flags, xlrec->new_xmax, xlrec->new_offnum);
227 : }
228 31748 : else if (info == XLOG_HEAP_TRUNCATE)
229 : {
230 6 : xl_heap_truncate *xlrec = (xl_heap_truncate *) rec;
231 :
232 6 : truncate_flags_desc(buf, xlrec->flags);
233 6 : appendStringInfo(buf, ", nrelids: %u", xlrec->nrelids);
234 6 : appendStringInfoString(buf, ", relids:");
235 6 : array_desc(buf, xlrec->relids, sizeof(Oid), xlrec->nrelids,
236 : &oid_elem_desc, NULL);
237 : }
238 31742 : else if (info == XLOG_HEAP_CONFIRM)
239 : {
240 0 : xl_heap_confirm *xlrec = (xl_heap_confirm *) rec;
241 :
242 0 : appendStringInfo(buf, "off: %u", xlrec->offnum);
243 : }
244 31742 : else if (info == XLOG_HEAP_LOCK)
245 : {
246 30440 : xl_heap_lock *xlrec = (xl_heap_lock *) rec;
247 :
248 30440 : appendStringInfo(buf, "xmax: %u, off: %u, ",
249 30440 : xlrec->xmax, xlrec->offnum);
250 30440 : infobits_desc(buf, xlrec->infobits_set, "infobits");
251 30440 : appendStringInfo(buf, ", flags: 0x%02X", xlrec->flags);
252 : }
253 1302 : else if (info == XLOG_HEAP_INPLACE)
254 : {
255 1302 : xl_heap_inplace *xlrec = (xl_heap_inplace *) rec;
256 :
257 1302 : appendStringInfo(buf, "off: %u", xlrec->offnum);
258 1302 : standby_desc_invalidations(buf, xlrec->nmsgs, xlrec->msgs,
259 : xlrec->dbId, xlrec->tsId,
260 1302 : xlrec->relcacheInitFileInval);
261 : }
262 135542 : }
263 :
264 : void
265 8215 : heap2_desc(StringInfo buf, XLogReaderState *record)
266 : {
267 8215 : char *rec = XLogRecGetData(record);
268 8215 : uint8 info = XLogRecGetInfo(record) & ~XLR_INFO_MASK;
269 :
270 8215 : info &= XLOG_HEAP_OPMASK;
271 8215 : if (info == XLOG_HEAP2_PRUNE_ON_ACCESS ||
272 7059 : info == XLOG_HEAP2_PRUNE_VACUUM_SCAN ||
273 : info == XLOG_HEAP2_PRUNE_VACUUM_CLEANUP)
274 1424 : {
275 1424 : xl_heap_prune *xlrec = (xl_heap_prune *) rec;
276 :
277 1424 : if (xlrec->flags & XLHP_HAS_CONFLICT_HORIZON)
278 : {
279 : TransactionId conflict_xid;
280 :
281 1099 : memcpy(&conflict_xid, rec + SizeOfHeapPrune, sizeof(TransactionId));
282 :
283 1099 : appendStringInfo(buf, "snapshotConflictHorizon: %u",
284 : conflict_xid);
285 : }
286 :
287 1424 : appendStringInfo(buf, ", isCatalogRel: %c",
288 1424 : xlrec->flags & XLHP_IS_CATALOG_REL ? 'T' : 'F');
289 :
290 1424 : if (xlrec->flags & XLHP_VM_ALL_VISIBLE)
291 : {
292 268 : uint8 vmflags = VISIBILITYMAP_ALL_VISIBLE;
293 :
294 268 : if (xlrec->flags & XLHP_VM_ALL_FROZEN)
295 255 : vmflags |= VISIBILITYMAP_ALL_FROZEN;
296 268 : appendStringInfo(buf, ", vm_flags: 0x%02X", vmflags);
297 : }
298 :
299 1424 : if (XLogRecHasBlockData(record, 0))
300 : {
301 : Size datalen;
302 : OffsetNumber *redirected;
303 : OffsetNumber *nowdead;
304 : OffsetNumber *nowunused;
305 : int nredirected;
306 : int nunused;
307 : int ndead;
308 : int nplans;
309 : xlhp_freeze_plan *plans;
310 : OffsetNumber *frz_offsets;
311 :
312 1424 : char *cursor = XLogRecGetBlockData(record, 0, &datalen);
313 :
314 1424 : heap_xlog_deserialize_prune_and_freeze(cursor, xlrec->flags,
315 : &nplans, &plans, &frz_offsets,
316 : &nredirected, &redirected,
317 : &ndead, &nowdead,
318 : &nunused, &nowunused);
319 :
320 1424 : appendStringInfo(buf, ", nplans: %u, nredirected: %u, ndead: %u, nunused: %u",
321 : nplans, nredirected, ndead, nunused);
322 :
323 1424 : if (nplans > 0)
324 : {
325 494 : appendStringInfoString(buf, ", plans:");
326 494 : array_desc(buf, plans, sizeof(xlhp_freeze_plan), nplans,
327 : &plan_elem_desc, &frz_offsets);
328 : }
329 :
330 1424 : if (nredirected > 0)
331 : {
332 346 : appendStringInfoString(buf, ", redirected:");
333 346 : array_desc(buf, redirected, sizeof(OffsetNumber) * 2,
334 : nredirected, &redirect_elem_desc, NULL);
335 : }
336 :
337 1424 : if (ndead > 0)
338 : {
339 346 : appendStringInfoString(buf, ", dead:");
340 346 : array_desc(buf, nowdead, sizeof(OffsetNumber), ndead,
341 : &offset_elem_desc, NULL);
342 : }
343 :
344 1424 : if (nunused > 0)
345 : {
346 352 : appendStringInfoString(buf, ", unused:");
347 352 : array_desc(buf, nowunused, sizeof(OffsetNumber), nunused,
348 : &offset_elem_desc, NULL);
349 : }
350 : }
351 : }
352 6791 : else if (info == XLOG_HEAP2_VISIBLE)
353 : {
354 1292 : xl_heap_visible *xlrec = (xl_heap_visible *) rec;
355 :
356 1292 : appendStringInfo(buf, "snapshotConflictHorizon: %u, flags: 0x%02X",
357 1292 : xlrec->snapshotConflictHorizon, xlrec->flags);
358 : }
359 5499 : else if (info == XLOG_HEAP2_MULTI_INSERT)
360 : {
361 3884 : xl_heap_multi_insert *xlrec = (xl_heap_multi_insert *) rec;
362 3884 : bool isinit = (XLogRecGetInfo(record) & XLOG_HEAP_INIT_PAGE) != 0;
363 :
364 3884 : appendStringInfo(buf, "ntuples: %d, flags: 0x%02X", xlrec->ntuples,
365 3884 : xlrec->flags);
366 :
367 3884 : if (xlrec->flags & XLH_INSERT_ALL_FROZEN_SET)
368 0 : appendStringInfo(buf, ", vm_flags: 0x%02X",
369 : VISIBILITYMAP_ALL_VISIBLE |
370 : VISIBILITYMAP_ALL_FROZEN);
371 :
372 3884 : if (XLogRecHasBlockData(record, 0) && !isinit)
373 : {
374 3736 : appendStringInfoString(buf, ", offsets:");
375 3736 : array_desc(buf, xlrec->offsets, sizeof(OffsetNumber),
376 3736 : xlrec->ntuples, &offset_elem_desc, NULL);
377 : }
378 : }
379 1615 : else if (info == XLOG_HEAP2_LOCK_UPDATED)
380 : {
381 0 : xl_heap_lock_updated *xlrec = (xl_heap_lock_updated *) rec;
382 :
383 0 : appendStringInfo(buf, "xmax: %u, off: %u, ",
384 0 : xlrec->xmax, xlrec->offnum);
385 0 : infobits_desc(buf, xlrec->infobits_set, "infobits");
386 0 : appendStringInfo(buf, ", flags: 0x%02X", xlrec->flags);
387 : }
388 1615 : else if (info == XLOG_HEAP2_NEW_CID)
389 : {
390 1615 : xl_heap_new_cid *xlrec = (xl_heap_new_cid *) rec;
391 :
392 1615 : appendStringInfo(buf, "rel: %u/%u/%u, tid: %u/%u",
393 : xlrec->target_locator.spcOid,
394 : xlrec->target_locator.dbOid,
395 : xlrec->target_locator.relNumber,
396 1615 : ItemPointerGetBlockNumber(&(xlrec->target_tid)),
397 1615 : ItemPointerGetOffsetNumber(&(xlrec->target_tid)));
398 1615 : appendStringInfo(buf, ", cmin: %u, cmax: %u, combo: %u",
399 : xlrec->cmin, xlrec->cmax, xlrec->combocid);
400 : }
401 8215 : }
402 :
403 : const char *
404 135551 : heap_identify(uint8 info)
405 : {
406 135551 : const char *id = NULL;
407 :
408 135551 : switch (info & ~XLR_INFO_MASK)
409 : {
410 71605 : case XLOG_HEAP_INSERT:
411 71605 : id = "INSERT";
412 71605 : break;
413 700 : case XLOG_HEAP_INSERT | XLOG_HEAP_INIT_PAGE:
414 700 : id = "INSERT+INIT";
415 700 : break;
416 220 : case XLOG_HEAP_DELETE:
417 220 : id = "DELETE";
418 220 : break;
419 30249 : case XLOG_HEAP_UPDATE:
420 30249 : id = "UPDATE";
421 30249 : break;
422 219 : case XLOG_HEAP_UPDATE | XLOG_HEAP_INIT_PAGE:
423 219 : id = "UPDATE+INIT";
424 219 : break;
425 807 : case XLOG_HEAP_HOT_UPDATE:
426 807 : id = "HOT_UPDATE";
427 807 : break;
428 0 : case XLOG_HEAP_HOT_UPDATE | XLOG_HEAP_INIT_PAGE:
429 0 : id = "HOT_UPDATE+INIT";
430 0 : break;
431 7 : case XLOG_HEAP_TRUNCATE:
432 7 : id = "TRUNCATE";
433 7 : break;
434 0 : case XLOG_HEAP_CONFIRM:
435 0 : id = "HEAP_CONFIRM";
436 0 : break;
437 30441 : case XLOG_HEAP_LOCK:
438 30441 : id = "LOCK";
439 30441 : break;
440 1303 : case XLOG_HEAP_INPLACE:
441 1303 : id = "INPLACE";
442 1303 : break;
443 : }
444 :
445 135551 : return id;
446 : }
447 :
448 : const char *
449 8222 : heap2_identify(uint8 info)
450 : {
451 8222 : const char *id = NULL;
452 :
453 8222 : switch (info & ~XLR_INFO_MASK)
454 : {
455 475 : case XLOG_HEAP2_PRUNE_ON_ACCESS:
456 475 : id = "PRUNE_ON_ACCESS";
457 475 : break;
458 683 : case XLOG_HEAP2_PRUNE_VACUUM_SCAN:
459 683 : id = "PRUNE_VACUUM_SCAN";
460 683 : break;
461 269 : case XLOG_HEAP2_PRUNE_VACUUM_CLEANUP:
462 269 : id = "PRUNE_VACUUM_CLEANUP";
463 269 : break;
464 1293 : case XLOG_HEAP2_VISIBLE:
465 1293 : id = "VISIBLE";
466 1293 : break;
467 3769 : case XLOG_HEAP2_MULTI_INSERT:
468 3769 : id = "MULTI_INSERT";
469 3769 : break;
470 117 : case XLOG_HEAP2_MULTI_INSERT | XLOG_HEAP_INIT_PAGE:
471 117 : id = "MULTI_INSERT+INIT";
472 117 : break;
473 0 : case XLOG_HEAP2_LOCK_UPDATED:
474 0 : id = "LOCK_UPDATED";
475 0 : break;
476 1616 : case XLOG_HEAP2_NEW_CID:
477 1616 : id = "NEW_CID";
478 1616 : break;
479 0 : case XLOG_HEAP2_REWRITE:
480 0 : id = "REWRITE";
481 0 : break;
482 : }
483 :
484 8222 : return id;
485 : }
|