Line data Source code
1 : /*-------------------------------------------------------------------------
2 : *
3 : * heapdesc.c
4 : * rmgr descriptor routines for access/heap/heapam.c
5 : *
6 : * Portions Copyright (c) 1996-2025, 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 104 : infobits_desc(StringInfo buf, uint8 infobits, const char *keyname)
28 : {
29 104 : appendStringInfo(buf, "%s: [", keyname);
30 :
31 : Assert(buf->data[buf->len - 1] != ' ');
32 :
33 104 : if (infobits & XLHL_XMAX_IS_MULTI)
34 0 : appendStringInfoString(buf, "IS_MULTI, ");
35 104 : if (infobits & XLHL_XMAX_LOCK_ONLY)
36 20 : appendStringInfoString(buf, "LOCK_ONLY, ");
37 104 : if (infobits & XLHL_XMAX_EXCL_LOCK)
38 20 : appendStringInfoString(buf, "EXCL_LOCK, ");
39 104 : if (infobits & XLHL_XMAX_KEYSHR_LOCK)
40 0 : appendStringInfoString(buf, "KEYSHR_LOCK, ");
41 104 : if (infobits & XLHL_KEYS_UPDATED)
42 40 : appendStringInfoString(buf, "KEYS_UPDATED, ");
43 :
44 104 : if (buf->data[buf->len - 1] == ' ')
45 : {
46 : /* Truncate-away final unneeded ", " */
47 : Assert(buf->data[buf->len - 2] == ',');
48 60 : buf->len -= 2;
49 60 : buf->data[buf->len] = '\0';
50 : }
51 :
52 104 : appendStringInfoChar(buf, ']');
53 104 : }
54 :
55 : static void
56 0 : truncate_flags_desc(StringInfo buf, uint8 flags)
57 : {
58 0 : appendStringInfoString(buf, "flags: [");
59 :
60 0 : if (flags & XLH_TRUNCATE_CASCADE)
61 0 : appendStringInfoString(buf, "CASCADE, ");
62 0 : if (flags & XLH_TRUNCATE_RESTART_SEQS)
63 0 : appendStringInfoString(buf, "RESTART_SEQS, ");
64 :
65 0 : 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 0 : appendStringInfoChar(buf, ']');
74 0 : }
75 :
76 : static void
77 16 : plan_elem_desc(StringInfo buf, void *plan, void *data)
78 : {
79 16 : xlhp_freeze_plan *new_plan = (xlhp_freeze_plan *) plan;
80 16 : OffsetNumber **offsets = data;
81 :
82 16 : appendStringInfo(buf, "{ xmax: %u, infomask: %u, infomask2: %u, ntuples: %u",
83 : new_plan->xmax,
84 16 : new_plan->t_infomask, new_plan->t_infomask2,
85 16 : new_plan->ntuples);
86 :
87 16 : appendStringInfoString(buf, ", offsets:");
88 16 : array_desc(buf, *offsets, sizeof(OffsetNumber), new_plan->ntuples,
89 : &offset_elem_desc, NULL);
90 :
91 16 : *offsets += new_plan->ntuples;
92 :
93 16 : appendStringInfoString(buf, " }");
94 16 : }
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 22110 : 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 22110 : if (flags & XLHP_HAS_FREEZE_PLANS)
114 : {
115 3456 : xlhp_freeze_plans *freeze_plans = (xlhp_freeze_plans *) cursor;
116 :
117 3456 : *nplans = freeze_plans->nplans;
118 : Assert(*nplans > 0);
119 3456 : *plans = freeze_plans->plans;
120 :
121 3456 : cursor += offsetof(xlhp_freeze_plans, plans);
122 3456 : cursor += sizeof(xlhp_freeze_plan) * *nplans;
123 : }
124 : else
125 : {
126 18654 : *nplans = 0;
127 18654 : *plans = NULL;
128 : }
129 :
130 22110 : if (flags & XLHP_HAS_REDIRECTIONS)
131 : {
132 3940 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
133 :
134 3940 : *nredirected = subrecord->ntargets;
135 : Assert(*nredirected > 0);
136 3940 : *redirected = &subrecord->data[0];
137 :
138 3940 : cursor += offsetof(xlhp_prune_items, data);
139 3940 : cursor += sizeof(OffsetNumber[2]) * *nredirected;
140 : }
141 : else
142 : {
143 18170 : *nredirected = 0;
144 18170 : *redirected = NULL;
145 : }
146 :
147 22110 : if (flags & XLHP_HAS_DEAD_ITEMS)
148 : {
149 12192 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
150 :
151 12192 : *ndead = subrecord->ntargets;
152 : Assert(*ndead > 0);
153 12192 : *nowdead = subrecord->data;
154 :
155 12192 : cursor += offsetof(xlhp_prune_items, data);
156 12192 : cursor += sizeof(OffsetNumber) * *ndead;
157 : }
158 : else
159 : {
160 9918 : *ndead = 0;
161 9918 : *nowdead = NULL;
162 : }
163 :
164 22110 : if (flags & XLHP_HAS_NOW_UNUSED_ITEMS)
165 : {
166 8572 : xlhp_prune_items *subrecord = (xlhp_prune_items *) cursor;
167 :
168 8572 : *nunused = subrecord->ntargets;
169 : Assert(*nunused > 0);
170 8572 : *nowunused = subrecord->data;
171 :
172 8572 : cursor += offsetof(xlhp_prune_items, data);
173 8572 : cursor += sizeof(OffsetNumber) * *nunused;
174 : }
175 : else
176 : {
177 13538 : *nunused = 0;
178 13538 : *nowunused = NULL;
179 : }
180 :
181 22110 : *frz_offsets = (OffsetNumber *) cursor;
182 22110 : }
183 :
184 : void
185 61908 : heap_desc(StringInfo buf, XLogReaderState *record)
186 : {
187 61908 : char *rec = XLogRecGetData(record);
188 61908 : uint8 info = XLogRecGetInfo(record) & ~XLR_INFO_MASK;
189 :
190 61908 : info &= XLOG_HEAP_OPMASK;
191 61908 : if (info == XLOG_HEAP_INSERT)
192 : {
193 61800 : xl_heap_insert *xlrec = (xl_heap_insert *) rec;
194 :
195 61800 : appendStringInfo(buf, "off: %u, flags: 0x%02X",
196 61800 : xlrec->offnum,
197 61800 : xlrec->flags);
198 : }
199 108 : else if (info == XLOG_HEAP_DELETE)
200 : {
201 40 : xl_heap_delete *xlrec = (xl_heap_delete *) rec;
202 :
203 40 : appendStringInfo(buf, "xmax: %u, off: %u, ",
204 40 : xlrec->xmax, xlrec->offnum);
205 40 : infobits_desc(buf, xlrec->infobits_set, "infobits");
206 40 : appendStringInfo(buf, ", flags: 0x%02X", xlrec->flags);
207 : }
208 68 : else if (info == XLOG_HEAP_UPDATE)
209 : {
210 20 : xl_heap_update *xlrec = (xl_heap_update *) rec;
211 :
212 20 : appendStringInfo(buf, "old_xmax: %u, old_off: %u, ",
213 20 : xlrec->old_xmax, xlrec->old_offnum);
214 20 : infobits_desc(buf, xlrec->old_infobits_set, "old_infobits");
215 20 : appendStringInfo(buf, ", flags: 0x%02X, new_xmax: %u, new_off: %u",
216 20 : xlrec->flags, xlrec->new_xmax, xlrec->new_offnum);
217 : }
218 48 : else if (info == XLOG_HEAP_HOT_UPDATE)
219 : {
220 24 : xl_heap_update *xlrec = (xl_heap_update *) rec;
221 :
222 24 : appendStringInfo(buf, "old_xmax: %u, old_off: %u, ",
223 24 : xlrec->old_xmax, xlrec->old_offnum);
224 24 : infobits_desc(buf, xlrec->old_infobits_set, "old_infobits");
225 24 : appendStringInfo(buf, ", flags: 0x%02X, new_xmax: %u, new_off: %u",
226 24 : xlrec->flags, xlrec->new_xmax, xlrec->new_offnum);
227 : }
228 24 : else if (info == XLOG_HEAP_TRUNCATE)
229 : {
230 0 : xl_heap_truncate *xlrec = (xl_heap_truncate *) rec;
231 :
232 0 : truncate_flags_desc(buf, xlrec->flags);
233 0 : appendStringInfo(buf, ", nrelids: %u", xlrec->nrelids);
234 0 : appendStringInfoString(buf, ", relids:");
235 0 : array_desc(buf, xlrec->relids, sizeof(Oid), xlrec->nrelids,
236 : &oid_elem_desc, NULL);
237 : }
238 24 : 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 24 : else if (info == XLOG_HEAP_LOCK)
245 : {
246 20 : xl_heap_lock *xlrec = (xl_heap_lock *) rec;
247 :
248 20 : appendStringInfo(buf, "xmax: %u, off: %u, ",
249 20 : xlrec->xmax, xlrec->offnum);
250 20 : infobits_desc(buf, xlrec->infobits_set, "infobits");
251 20 : appendStringInfo(buf, ", flags: 0x%02X", xlrec->flags);
252 : }
253 4 : else if (info == XLOG_HEAP_INPLACE)
254 : {
255 4 : xl_heap_inplace *xlrec = (xl_heap_inplace *) rec;
256 :
257 4 : appendStringInfo(buf, "off: %u", xlrec->offnum);
258 4 : standby_desc_invalidations(buf, xlrec->nmsgs, xlrec->msgs,
259 : xlrec->dbId, xlrec->tsId,
260 4 : xlrec->relcacheInitFileInval);
261 : }
262 61908 : }
263 :
264 : void
265 150 : heap2_desc(StringInfo buf, XLogReaderState *record)
266 : {
267 150 : char *rec = XLogRecGetData(record);
268 150 : uint8 info = XLogRecGetInfo(record) & ~XLR_INFO_MASK;
269 :
270 150 : info &= XLOG_HEAP_OPMASK;
271 150 : if (info == XLOG_HEAP2_PRUNE_ON_ACCESS ||
272 46 : info == XLOG_HEAP2_PRUNE_VACUUM_SCAN ||
273 : info == XLOG_HEAP2_PRUNE_VACUUM_CLEANUP)
274 108 : {
275 108 : xl_heap_prune *xlrec = (xl_heap_prune *) rec;
276 :
277 108 : if (xlrec->flags & XLHP_HAS_CONFLICT_HORIZON)
278 : {
279 : TransactionId conflict_xid;
280 :
281 38 : memcpy(&conflict_xid, rec + SizeOfHeapPrune, sizeof(TransactionId));
282 :
283 38 : appendStringInfo(buf, "snapshotConflictHorizon: %u",
284 : conflict_xid);
285 : }
286 :
287 108 : appendStringInfo(buf, ", isCatalogRel: %c",
288 108 : xlrec->flags & XLHP_IS_CATALOG_REL ? 'T' : 'F');
289 :
290 108 : if (xlrec->flags & XLHP_VM_ALL_VISIBLE)
291 : {
292 4 : uint8 vmflags = VISIBILITYMAP_ALL_VISIBLE;
293 :
294 4 : if (xlrec->flags & XLHP_VM_ALL_FROZEN)
295 2 : vmflags |= VISIBILITYMAP_ALL_FROZEN;
296 4 : appendStringInfo(buf, ", vm_flags: 0x%02X", vmflags);
297 : }
298 :
299 108 : 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 108 : char *cursor = XLogRecGetBlockData(record, 0, &datalen);
313 :
314 108 : 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 108 : appendStringInfo(buf, ", nplans: %u, nredirected: %u, ndead: %u, nunused: %u",
321 : nplans, nredirected, ndead, nunused);
322 :
323 108 : if (nplans > 0)
324 : {
325 12 : appendStringInfoString(buf, ", plans:");
326 12 : array_desc(buf, plans, sizeof(xlhp_freeze_plan), nplans,
327 : &plan_elem_desc, &frz_offsets);
328 : }
329 :
330 108 : if (nredirected > 0)
331 : {
332 14 : appendStringInfoString(buf, ", redirected:");
333 14 : array_desc(buf, redirected, sizeof(OffsetNumber) * 2,
334 : nredirected, &redirect_elem_desc, NULL);
335 : }
336 :
337 108 : if (ndead > 0)
338 : {
339 84 : appendStringInfoString(buf, ", dead:");
340 84 : array_desc(buf, nowdead, sizeof(OffsetNumber), ndead,
341 : &offset_elem_desc, NULL);
342 : }
343 :
344 108 : if (nunused > 0)
345 : {
346 24 : appendStringInfoString(buf, ", unused:");
347 24 : array_desc(buf, nowunused, sizeof(OffsetNumber), nunused,
348 : &offset_elem_desc, NULL);
349 : }
350 : }
351 : }
352 42 : else if (info == XLOG_HEAP2_VISIBLE)
353 : {
354 0 : xl_heap_visible *xlrec = (xl_heap_visible *) rec;
355 :
356 0 : appendStringInfo(buf, "snapshotConflictHorizon: %u, flags: 0x%02X",
357 0 : xlrec->snapshotConflictHorizon, xlrec->flags);
358 : }
359 42 : else if (info == XLOG_HEAP2_MULTI_INSERT)
360 : {
361 42 : xl_heap_multi_insert *xlrec = (xl_heap_multi_insert *) rec;
362 42 : bool isinit = (XLogRecGetInfo(record) & XLOG_HEAP_INIT_PAGE) != 0;
363 :
364 42 : appendStringInfo(buf, "ntuples: %d, flags: 0x%02X", xlrec->ntuples,
365 42 : xlrec->flags);
366 :
367 42 : 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 42 : if (XLogRecHasBlockData(record, 0) && !isinit)
373 : {
374 40 : appendStringInfoString(buf, ", offsets:");
375 40 : array_desc(buf, xlrec->offsets, sizeof(OffsetNumber),
376 40 : xlrec->ntuples, &offset_elem_desc, NULL);
377 : }
378 : }
379 0 : 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 0 : else if (info == XLOG_HEAP2_NEW_CID)
389 : {
390 0 : xl_heap_new_cid *xlrec = (xl_heap_new_cid *) rec;
391 :
392 0 : 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 0 : ItemPointerGetBlockNumber(&(xlrec->target_tid)),
397 0 : ItemPointerGetOffsetNumber(&(xlrec->target_tid)));
398 0 : appendStringInfo(buf, ", cmin: %u, cmax: %u, combo: %u",
399 : xlrec->cmin, xlrec->cmax, xlrec->combocid);
400 : }
401 150 : }
402 :
403 : const char *
404 61908 : heap_identify(uint8 info)
405 : {
406 61908 : const char *id = NULL;
407 :
408 61908 : switch (info & ~XLR_INFO_MASK)
409 : {
410 58976 : case XLOG_HEAP_INSERT:
411 58976 : id = "INSERT";
412 58976 : break;
413 2824 : case XLOG_HEAP_INSERT | XLOG_HEAP_INIT_PAGE:
414 2824 : id = "INSERT+INIT";
415 2824 : break;
416 40 : case XLOG_HEAP_DELETE:
417 40 : id = "DELETE";
418 40 : break;
419 18 : case XLOG_HEAP_UPDATE:
420 18 : id = "UPDATE";
421 18 : break;
422 2 : case XLOG_HEAP_UPDATE | XLOG_HEAP_INIT_PAGE:
423 2 : id = "UPDATE+INIT";
424 2 : break;
425 24 : case XLOG_HEAP_HOT_UPDATE:
426 24 : id = "HOT_UPDATE";
427 24 : break;
428 0 : case XLOG_HEAP_HOT_UPDATE | XLOG_HEAP_INIT_PAGE:
429 0 : id = "HOT_UPDATE+INIT";
430 0 : break;
431 0 : case XLOG_HEAP_TRUNCATE:
432 0 : id = "TRUNCATE";
433 0 : break;
434 0 : case XLOG_HEAP_CONFIRM:
435 0 : id = "HEAP_CONFIRM";
436 0 : break;
437 20 : case XLOG_HEAP_LOCK:
438 20 : id = "LOCK";
439 20 : break;
440 4 : case XLOG_HEAP_INPLACE:
441 4 : id = "INPLACE";
442 4 : break;
443 : }
444 :
445 61908 : return id;
446 : }
447 :
448 : const char *
449 150 : heap2_identify(uint8 info)
450 : {
451 150 : const char *id = NULL;
452 :
453 150 : switch (info & ~XLR_INFO_MASK)
454 : {
455 82 : case XLOG_HEAP2_PRUNE_ON_ACCESS:
456 82 : id = "PRUNE_ON_ACCESS";
457 82 : break;
458 22 : case XLOG_HEAP2_PRUNE_VACUUM_SCAN:
459 22 : id = "PRUNE_VACUUM_SCAN";
460 22 : break;
461 4 : case XLOG_HEAP2_PRUNE_VACUUM_CLEANUP:
462 4 : id = "PRUNE_VACUUM_CLEANUP";
463 4 : break;
464 0 : case XLOG_HEAP2_VISIBLE:
465 0 : id = "VISIBLE";
466 0 : break;
467 42 : case XLOG_HEAP2_MULTI_INSERT:
468 42 : id = "MULTI_INSERT";
469 42 : break;
470 0 : case XLOG_HEAP2_MULTI_INSERT | XLOG_HEAP_INIT_PAGE:
471 0 : id = "MULTI_INSERT+INIT";
472 0 : break;
473 0 : case XLOG_HEAP2_LOCK_UPDATED:
474 0 : id = "LOCK_UPDATED";
475 0 : break;
476 0 : case XLOG_HEAP2_NEW_CID:
477 0 : id = "NEW_CID";
478 0 : break;
479 0 : case XLOG_HEAP2_REWRITE:
480 0 : id = "REWRITE";
481 0 : break;
482 : }
483 :
484 150 : return id;
485 : }
|