CF 6958 v01: what the progress views show, per command Produced by cf6958-matrix.sh (attached) on 2026-10-29, one run per build. Builds (all --enable-debug -O2): master 61553eacadb, with asserts base 994f770a0fd (where v01 applies), with asserts v01 on base, asserts v01 on base, no asserts v01 does not apply to current master (conflicts in index.c, index.h, toasting.c and backend_progress.c with 4b445479f9e), so it was measured on its own base. The base behaves like master in every row below. Each line: samples per row seen. A = pg_stat_progress_analyze row (phase, relid), C = pg_stat_progress_copy row (command, type, relid), "(none)" = backend active, no row in either view. acq = acquiring sample rows, acq-inh = acquiring inherited sample rows, compute = computing statistics, final = finalizing analyze. "max bytes" = largest bytes_processed sampled; "sent" = bytes the client received. Sample counts differ between builds because each run is timed by the command itself; compare which rows appear, not the counts. ------------------------------------------------------------------------ analyze_ft: ANALYZE ft master 61553eacadb: 727 (none); 332 C COPY FROM FILE relid=ft [max bytes 60940913; sent 0] base 994f770a0fd: 743 (none); 336 C COPY FROM FILE relid=ft [max bytes 60875386; sent 0] v01 on base, asserts: 728 A compute relid=ft; 329 A acq relid=ft; 4 A final relid=ft [max bytes 61006441; sent 0] v01 on base, no asserts: 715 A compute relid=ft; 253 A acq relid=ft; 2 A final relid=ft [max bytes 61006441; sent 0] ------------------------------------------------------------------------ analyze_partitioned: ANALYZE parted master 61553eacadb: 1379 (none); 638 C COPY FROM FILE relid=p_ft; 51 A compute relid=p_heap; 25 A acq relid=p_heap; 24 A acq-inh relid=parted children 0/2; 3 A final relid=p_heap [max bytes 60875386; sent 0] base 994f770a0fd: 1413 (none); 661 C COPY FROM FILE relid=p_ft; 50 A compute relid=p_heap; 29 A acq-inh relid=parted children 0/2; 20 A acq relid=p_heap; 3 A final relid=p_heap [max bytes 61043138; sent 0] v01 on base, asserts: 728 A compute relid=p_ft; 611 A compute relid=parted children 2/2; 328 A acq relid=p_ft; 299 A acq-inh relid=parted children 1/2; 50 A compute relid=p_heap; 25 A acq-inh relid=parted children 0/2; 14 A acq relid=p_heap; 5 A final relid=p_ft; 4 A final relid=p_heap; 3 A final relid=parted children 2/2; 1 (none) [max bytes 61006441; sent 0] v01 on base, no asserts: 701 A compute relid=p_ft; 600 A compute relid=parted children 2/2; 255 A acq relid=p_ft; 224 A acq-inh relid=parted children 1/2; 30 A compute relid=p_heap; 21 A acq-inh relid=parted children 0/2; 18 A acq relid=p_heap; 4 A final relid=p_ft; 2 A final relid=p_heap; 1 A final relid=parted children 2/2 [max bytes 61043138; sent 0] ------------------------------------------------------------------------ vacuum_analyze_parted: VACUUM ANALYZE parted master 61553eacadb: 634 (none); 306 C COPY FROM FILE relid=p_ft; 50 A compute relid=p_heap; 26 A acq-inh relid=parted children 0/2; 18 A acq relid=p_heap; 4 A final relid=p_heap [max bytes 60940913; sent 0] base 994f770a0fd: 624 (none); 309 C COPY FROM FILE relid=p_ft; 50 A compute relid=p_heap; 26 A acq-inh relid=parted children 0/2; 21 A acq relid=p_heap; 3 A final relid=p_heap [max bytes 60809859; sent 0] v01 on base, asserts: 636 A compute relid=parted children 2/2; 299 A acq-inh relid=parted children 1/2; 49 A compute relid=p_heap; 26 A acq-inh relid=parted children 0/2; 23 A acq relid=p_heap; 8 (none); 5 A final relid=parted children 2/2; 3 A final relid=p_heap [max bytes 60809859; sent 0] v01 on base, no asserts: 596 A compute relid=parted children 2/2; 236 A acq- inh relid=parted children 1/2; 28 A compute relid=p_heap; 22 A acq relid=p_heap; 19 A acq-inh relid=parted children 0/2; 5 (none); 2 A final relid=parted children 2/2; 2 A final relid=p_heap [max bytes 61006441; sent 0] ------------------------------------------------------------------------ analyze_all: ANALYZE master 61553eacadb: 617 (none); 295 C COPY FROM FILE relid=p_ft; 49 A compute relid=p_heap; 36 A (catalogs); 24 A acq relid=p_heap; 21 A acq- inh relid=parted children 0/2; 4 A final relid=p_heap; 1 A final relid=t3 [max bytes 61043138; sent 0] base 994f770a0fd: 621 (none); 323 C COPY FROM FILE relid=p_ft; 51 A compute relid=p_heap; 35 A (catalogs); 28 A acq-inh relid=parted children 0/2; 19 A acq relid=p_heap; 3 A final relid=p_heap; 1 A final relid=t3 [max bytes 61006441; sent 0] v01 on base, asserts: 639 A compute relid=parted children 2/2; 301 A acq-inh relid=parted children 1/2; 51 A compute relid=p_heap; 35 A (catalogs); 22 A acq-inh relid=parted children 0/2; 18 A acq relid=p_heap; 4 A final relid=p_heap; 3 A final relid=parted children 2/2; 1 (none) [max bytes 60809859; sent 0] v01 on base, no asserts: 600 A compute relid=parted children 2/2; 241 A acq- inh relid=parted children 1/2; 30 A compute relid=p_heap; 30 A (catalogs); 20 A acq-inh relid=parted children 0/2; 14 A acq relid=p_heap; 2 A final relid=parted children 2/2; 1 A final relid=p_heap [max bytes 60809859; sent 0] ------------------------------------------------------------------------ copy_to_select_ft: COPY (SELECT a FROM ft) TO STDOUT master 61553eacadb: 208 C COPY TO PIPE relid=- [max bytes 55502101; sent 10888896] base 994f770a0fd: 232 C COPY TO PIPE relid=- [max bytes 38596021; sent 10888896] v01 on base, asserts: 230 C COPY FROM FILE relid=ft [max bytes 0; sent 10888896] v01 on base, no asserts: 183 C COPY FROM FILE relid=ft [max bytes 0; sent 10888896] ------------------------------------------------------------------------ copy_from_trigger: COPY t3 FROM '/three.txt' master 61553eacadb: 94 C COPY FROM FILE relid=ft_small [max bytes 7797796; sent 0] base 994f770a0fd: 102 C COPY FROM FILE relid=ft_small; 2 (none) [max bytes 7732273; sent 0] v01 on base, asserts: 96 C COPY FROM FILE relid=t3 [max bytes 6; sent 0] v01 on base, no asserts: 75 C COPY FROM FILE relid=t3 [max bytes 6; sent 0] ------------------------------------------------------------------------ copy_from_trigger_copy_to: COPY t4 FROM '/three.txt' master 61553eacadb: 81 C COPY TO FILE relid=- [max bytes 6421694; sent 0] base 994f770a0fd: 105 C COPY TO FILE relid=-; 1 (none) [max bytes 1310569; sent 0] v01 on base, asserts: (no samples) [sent 0; CRASH TRAP: failed Assert("false"), File: "backend_progress.c", Line: 62, PID: 510381] v01 on base, no asserts: 25 (none); 23 C COPY FROM FILE relid=ft_small; 20 C COPY FROM FILE relid=t4 [max bytes 6; sent 0] ------------------------------------------------------------------------ copy_to_two_scans: COPY (SELECT a FROM ft UNION ALL SELECT a FROM ft_small) TO STDOUT master 61553eacadb: 245 C COPY TO PIPE relid=- [max bytes 12169608; sent 12177791] base 994f770a0fd: 279 C COPY TO PIPE relid=- [max bytes 12146613; sent 12177791] v01 on base, asserts: 273 (none) [max bytes 0; sent 12177791] v01 on base, no asserts: 203 (none) [max bytes 0; sent 12177791] ------------------------------------------------------------------------ insert_select_ft: INSERT INTO t SELECT * FROM ft master 61553eacadb: 937 C COPY FROM FILE relid=ft [max bytes 61043138; sent 0] base 994f770a0fd: 962 C COPY FROM FILE relid=ft; 1 (none) [max bytes 61006441; sent 0] v01 on base, asserts: 937 C COPY FROM FILE relid=ft [max bytes 61043138; sent 0] v01 on base, no asserts: 624 C COPY FROM FILE relid=ft [max bytes 61006441; sent 0] ------------------------------------------------------------------------ ctas_ft: CREATE TABLE ctas AS SELECT * FROM ft master 61553eacadb: 774 C COPY FROM FILE relid=ft; 1 (none) [max bytes 61006441; sent 0] base 994f770a0fd: 927 C COPY FROM FILE relid=ft [max bytes 61043138; sent 0] v01 on base, asserts: 750 C COPY FROM FILE relid=ft; 1 (none) [max bytes 61006441; sent 0] v01 on base, no asserts: 468 C COPY FROM FILE relid=ft; 1 (none) [max bytes 61006441; sent 0] ------------------------------------------------------------------------ select_ft: SELECT count(*) FROM ft master 61553eacadb: 239 C COPY FROM FILE relid=ft [max bytes 61006441; sent 38] base 994f770a0fd: 254 C COPY FROM FILE relid=ft [max bytes 60940913; sent 38] v01 on base, asserts: 248 C COPY FROM FILE relid=ft [max bytes 61006441; sent 38] v01 on base, no asserts: 185 C COPY FROM FILE relid=ft; 1 (none) [max bytes 60744328; sent 38] ------------------------------------------------------------------------ explain_then_select: EXPLAIN SELECT * FROM ft_small; SELECT count(*) FROM ft master 61553eacadb: 229 C COPY FROM FILE relid=ft [max bytes 60875386; sent 346] base 994f770a0fd: 262 C COPY FROM FILE relid=ft [max bytes 60940913; sent 348] v01 on base, asserts: 243 (none) [max bytes 0; sent 344] v01 on base, no asserts: 186 (none) [max bytes 0; sent 346] ------------------------------------------------------------------------ select_program: SELECT count(*) FROM ft_prog master 61553eacadb: 250 C COPY FROM PROGRAM relid=ft_prog [max bytes 61006441; sent 38] base 994f770a0fd: 290 C COPY FROM PROGRAM relid=ft_prog; 1 (none) [max bytes 60875386; sent 38] v01 on base, asserts: 255 C COPY FROM PROGRAM relid=ft_prog [max bytes 61006441; sent 38] v01 on base, no asserts: 206 C COPY FROM PROGRAM relid=ft_prog [max bytes 61006441; sent 38] ------------------------------------------------------------------------ copy_to_program: COPY (SELECT a FROM ft_prog) TO STDOUT master 61553eacadb: 225 C COPY TO PIPE relid=- [max bytes 10886576; sent 10888896] base 994f770a0fd: 249 C COPY TO PIPE relid=- [max bytes 10886064; sent 10888896] v01 on base, asserts: 278 C COPY FROM PROGRAM relid=ft_prog [max bytes 0; sent 10888896] v01 on base, no asserts: 197 C COPY FROM PROGRAM relid=ft_prog [max bytes 0; sent 10888896] ------------------------------------------------------------------------ copy_to_plain: COPY (SELECT a FROM t) TO STDOUT master 61553eacadb: 104 C COPY TO PIPE relid=- [max bytes 10838856; sent 10888896] base 994f770a0fd: 105 C COPY TO PIPE relid=- [max bytes 10837992; sent 10888896] v01 on base, asserts: 105 C COPY TO PIPE relid=-; 1 (none) [max bytes 10785880; sent 10888896] v01 on base, no asserts: 81 C COPY TO PIPE relid=- [max bytes 10792984; sent 10888896] ------------------------------------------------------------------------ select_two_scans: SELECT (SELECT count(*) FROM ft) + (SELECT count(*) FROM ft_small) master 61553eacadb: 216 C COPY FROM FILE relid=ft_small bytes>total; 61 C COPY FROM FILE relid=ft_small [max bytes 61043138; sent 41] base 994f770a0fd: 229 C COPY FROM FILE relid=ft_small bytes>total; 67 C COPY FROM FILE relid=ft_small; 1 (none) [max bytes 60940913; sent 41] v01 on base, asserts: 282 (none) [max bytes 0; sent 41] v01 on base, no asserts: 216 (none) [max bytes 0; sent 41] ------------------------------------------------------------------------ select_rescan: SELECT count(*) FROM generate_series(1, 3) g(i), LATERAL (SELECT a FROM ft WHERE a > i OFFSET 0) s master 61553eacadb: 567 C COPY FROM FILE relid=ft [max bytes 61043138; sent 38] base 994f770a0fd: 588 C COPY FROM FILE relid=ft [max bytes 61006441; sent 38] v01 on base, asserts: 627 C COPY FROM FILE relid=ft [max bytes 60940913; sent 38] v01 on base, no asserts: 479 C COPY FROM FILE relid=ft [max bytes 61006441; sent 38] ------------------------------------------------------------------------ select_error: SELECT count(*) FROM ft_bad master 61553eacadb: 14 C COPY FROM FILE relid=ft_bad [max bytes 3669540; sent 0] base 994f770a0fd: 17 C COPY FROM FILE relid=ft_bad [max bytes 3669540; sent 0] v01 on base, asserts: 15 C COPY FROM FILE relid=ft_bad [max bytes 3735066; sent 0] v01 on base, no asserts: 11 C COPY FROM FILE relid=ft_bad [max bytes 3604005; sent 0] ------------------------------------------------------------------------ after_error: same session, after the error above master 61553eacadb: (no samples) [rows for own pid: 0] base 994f770a0fd: (no samples) [rows for own pid: 0] v01 on base, asserts: (no samples) [rows for own pid: 0] v01 on base, no asserts: (no samples) [rows for own pid: 0]