Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKk0w-00ASMm-6H for pgsql-admin@arkaria.postgresql.org; Thu, 29 May 2025 20:38:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uKk0u-00CAb8-Gv for pgsql-admin@arkaria.postgresql.org; Thu, 29 May 2025 20:38:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKk0u-00CAb0-2D for pgsql-admin@lists.postgresql.org; Thu, 29 May 2025 20:38:08 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uKk0q-000mBl-2G for pgsql-admin@postgresql.org; Thu, 29 May 2025 20:38:07 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-2d0920ce388so734979fac.0 for ; Thu, 29 May 2025 13:38:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748551082; x=1749155882; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=rTW/DxCTvyoEdmPbtxLgzYlAy6b8rT4thzTfGafNrXE=; b=jRerx9Sa5fHeltTEFBti/eRDgeJ3/pDjOFeAzHB2icsK10lJifekF9oujlB1juj2j0 v/Y73SMGag9Omh0ltQF3nbH1VUSFGPHeHBoquOCaVw0grOj/2gYGS0FrWWc9wwUdwMuE Ey1lZ5I6im3VbuJNavO0hA5VdWShlPftGIaB9qga6nffNx/4U4vrcX5xBCKt/5MMeP/g AzoOAmQp9Elvs5O41pLx01f00fiediMPFHOuYNJ8oaybEXV1EkYhg07J651Jg5xR4O6m n0DxWQ/zBdBvkUt2JPgIpUkg46ENgxF7Hzs3xUdr4IxgA1CTLxOa91yR8Gqgtrdmq5Mx Gsdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748551082; x=1749155882; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=rTW/DxCTvyoEdmPbtxLgzYlAy6b8rT4thzTfGafNrXE=; b=TgdLnPccXR2jJEcnLBttop9h8C4zh0vSOfBcsJe4bYZ/jqETzBqW5X8JzyZ5qOWXHZ XtO8hdK/IHN+u+Y4D/kENpBiiS5Z3IUEPq2yWXBSYG3yLhprAkLcGe7+vNLreKB98e7U 2z8Fv5g7I90I/bk7yAHFiVTF22wMgR0aAHbYLyE1G/VSAz0qRQFwlDynur9lPa/zSza1 VWgbTytA3Gemt1dZSWNvvqDalFVrmFFwdD9JWjGGg/1Y7mUYrLhorCodVgI5AYM2kU9N V1ZXVu6rjer2H9RXQaBPSki75YVheDVpetz60sOT7o4GFHSbXjqboBJblxe7Hfgpc8oX tooA== X-Gm-Message-State: AOJu0YzzMYeQdS0hMvTZbHRQlMMZVBpEI7ev9yxCmnWRCbN8plvieXCI QF/ZYcscXK/4hrVdmMMlDgiNehoDjI3OXe7uQnMFB50wkkxLDOuNb7K+mCVRVRtY+3rHC1f5Cs4 gowF//CRJ+M73ZwgA6KeoNg/2BYknQJn0eMmX X-Gm-Gg: ASbGncszPMF1TSOi3b/jg/YMVxbMdxUFJDz3Z2MqLOeC6cppRGKJ4rTILXocqPS84b6 ke7FUrbHj0yeb/5NlZhapBE+0qCdbnrNQPfI9yRk8WHbraYxr0hhoE+UsWqx2Cph548/CFVFit/ nnBNgdy4SoZpwYAZYyW6i94MqwbyFHQnX2BmidBUvl6ZJu X-Google-Smtp-Source: AGHT+IEzcqF0TBNfGWuX2e+hDnR3zFaj8wJy1s8mLe4+hi0nskKG16adoudZ+rp42qsdtmDHkE6QxLBLR1tsafTgPyA= X-Received: by 2002:a05:6870:c085:b0:29e:5e83:150e with SMTP id 586e51a60fabf-2e92151e2cfmr452806fac.27.1748551082299; Thu, 29 May 2025 13:38:02 -0700 (PDT) MIME-Version: 1.0 From: Ron Johnson Date: Thu, 29 May 2025 16:37:50 -0400 X-Gm-Features: AX0GCFsNjXFNkQgeZhUCQjjULKNsAV8ka0CMXvsCqpUzV52vCFedaDBv7eHnVGM Message-ID: Subject: pg_dump verbose start and stop times? To: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000021d82806364c4612" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000021d82806364c4612 Content-Type: text/plain; charset="UTF-8" https://www.postgresql.org/docs/15/app-pgdump.html " Specifies verbose mode. This will cause pg_dump to output detailed object comments and start/stop times to the dump file, and progress messages to standard error. " But I don't see any timing messages. What am I misunderstanding in the docs? $ pg_dump -V pg_dump (PostgreSQL) 16.9 $ postgres -V postgres (PostgreSQL) 16.9 $ pg_dump -Fp -v ccoremultid > ~/ccoremultid.sql pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: flagging inherited columns in subtables pg_dump: reading partitioning data pg_dump: reading indexes pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row-level security policies pg_dump: reading publications pg_dump: reading publication membership of tables pg_dump: reading publication membership of schemas pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: creating SCHEMA "dba" pg_dump: creating EXTENSION "pgstattuple" pg_dump: creating COMMENT "EXTENSION pgstattuple" pg_dump: creating FUNCTION "dba.get_fk_referenced_by(text)" pg_dump: creating FUNCTION "dba.get_fk_references(text)" pg_dump: creating VIEW "dba.aggregate_cache_hits" pg_dump: creating VIEW "dba.all_indices" pg_dump: creating VIEW "dba.all_indices_types" pg_dump: creating VIEW "dba.latest_vacuum_and_analyze" pg_dump: creating VIEW "dba.analyze_levels" pg_dump: creating TABLE "dba.index_bloat_1stg" pg_dump: creating TABLE "dba.index_bloat_2stg" pg_dump: creating VIEW "dba.index_cache_hits" pg_dump: creating VIEW "dba.latest_toast_vacuum" pg_dump: creating TABLE "dba.pre_analyze_hot" pg_dump: creating VIEW "dba.statio_tables" pg_dump: creating TABLE "dba.table_bloat_1stg" pg_dump: creating TABLE "dba.table_bloat_2stg" pg_dump: creating VIEW "dba.table_cache_hits" pg_dump: creating VIEW "dba.toast_cache_hits" pg_dump: creating TABLE "dba.track_analyze_hot" pg_dump: creating VIEW "dba.v_parents_and_loners" pg_dump: creating VIEW "dba.v_relations" pg_dump: creating VIEW "dba.v_table_size" pg_dump: processing data for table "dba.index_bloat_1stg" pg_dump: dumping contents of table "dba.index_bloat_1stg" pg_dump: processing data for table "dba.index_bloat_2stg" pg_dump: dumping contents of table "dba.index_bloat_2stg" pg_dump: processing data for table "dba.pre_analyze_hot" pg_dump: dumping contents of table "dba.pre_analyze_hot" pg_dump: processing data for table "dba.table_bloat_1stg" pg_dump: dumping contents of table "dba.table_bloat_1stg" pg_dump: processing data for table "dba.table_bloat_2stg" pg_dump: dumping contents of table "dba.table_bloat_2stg" pg_dump: processing data for table "dba.track_analyze_hot" pg_dump: dumping contents of table "dba.track_analyze_hot" pg_dump: creating CONSTRAINT "dba.index_bloat_1stg index_bloat_1stg_pkey" pg_dump: creating CONSTRAINT "dba.index_bloat_2stg index_bloat_2stg_pkey" pg_dump: creating CONSTRAINT "dba.pre_analyze_hot pre_analyze_hot_pkey" pg_dump: creating CONSTRAINT "dba.table_bloat_1stg table_bloat_1stg_pkey" pg_dump: creating CONSTRAINT "dba.table_bloat_2stg table_bloat_2stg_pkey" pg_dump: creating CONSTRAINT "dba.track_analyze_hot track_analyze_hot_pkey" pg_dump: creating ACL "SCHEMA dba" pg_dump: creating ACL "dba.TABLE all_indices" pg_dump: creating ACL "dba.TABLE all_indices_types" pg_dump: creating ACL "dba.TABLE latest_vacuum_and_analyze" pg_dump: creating ACL "dba.TABLE analyze_levels" pg_dump: creating ACL "dba.TABLE latest_toast_vacuum" pg_dump: creating ACL "dba.TABLE v_relations" -- Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000021d82806364c4612 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

"
Specifies= verbose mode. This will cause=C2=A0pg_dump=C2= =A0to output detailed object comments and start/stop times to the dump file= , and progress messages to standard error.
"

But I don't see any timing messages.=C2=A0 What am I m= isunderstanding in the docs?

$ pg_dump -V
pg_du= mp (PostgreSQL) 16.9
$ postgres -V
postgres (PostgreSQL) 16.9
$ pg_dump -Fp -v ccoremultid > ~/ccoremultid.sql
pg_dump: last= built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifyi= ng extension members
pg_dump: reading schemas
pg_dump: reading user-d= efined tables
pg_dump: reading user-defined functions
pg_dump: readin= g user-defined types
pg_dump: reading procedural languages
pg_dump: r= eading user-defined aggregate functions
pg_dump: reading user-defined op= erators
pg_dump: reading user-defined access methods
pg_dump: reading= user-defined operator classes
pg_dump: reading user-defined operator fa= milies
pg_dump: reading user-defined text search parsers
pg_dump: rea= ding user-defined text search templates
pg_dump: reading user-defined te= xt search dictionaries
pg_dump: reading user-defined text search configu= rations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: = reading user-defined foreign servers
pg_dump: reading default privileges=
pg_dump: reading user-defined collations
pg_dump: reading user-defin= ed conversions
pg_dump: reading type casts
pg_dump: reading transform= s
pg_dump: reading table inheritance information
pg_dump: reading eve= nt triggers
pg_dump: finding extension tables
pg_dump: finding inheri= tance relationships
pg_dump: reading column info for interesting tables<= br>pg_dump: flagging inherited columns in subtables
pg_dump: reading par= titioning data
pg_dump: reading indexes
pg_dump: flagging indexes in = partitioned tables
pg_dump: reading extended statistics
pg_dump: read= ing constraints
pg_dump: reading triggers
pg_dump: reading rewrite ru= les
pg_dump: reading policies
pg_dump: reading row-level security pol= icies
pg_dump: reading publications
pg_dump: reading publication memb= ership of tables
pg_dump: reading publication membership of schemas
p= g_dump: reading subscriptions
pg_dump: reading large objects
pg_dump:= reading dependency data
pg_dump: saving encoding =3D UTF8
pg_dump: s= aving standard_conforming_strings =3D on
pg_dump: saving search_path =3D=
pg_dump: creating SCHEMA "dba"
pg_dump: creating EXTENSIO= N "pgstattuple"
pg_dump: creating COMMENT "EXTENSION pgst= attuple"
pg_dump: creating FUNCTION "dba.get_fk_referenced_by(= text)"
pg_dump: creating FUNCTION "dba.get_fk_references(text)= "
pg_dump: creating VIEW "dba.aggregate_cache_hits"
pg= _dump: creating VIEW "dba.all_indices"
pg_dump: creating VIEW = "dba.all_indices_types"
pg_dump: creating VIEW "dba.lates= t_vacuum_and_analyze"
pg_dump: creating VIEW "dba.analyze_leve= ls"
pg_dump: creating TABLE "dba.index_bloat_1stg"
pg_= dump: creating TABLE "dba.index_bloat_2stg"
pg_dump: creating = VIEW "dba.index_cache_hits"
pg_dump: creating VIEW "dba.l= atest_toast_vacuum"
pg_dump: creating TABLE "dba.pre_analyze_h= ot"
pg_dump: creating VIEW "dba.statio_tables"
pg_dump= : creating TABLE "dba.table_bloat_1stg"
pg_dump: creating TABL= E "dba.table_bloat_2stg"
pg_dump: creating VIEW "dba.tabl= e_cache_hits"
pg_dump: creating VIEW "dba.toast_cache_hits&quo= t;
pg_dump: creating TABLE "dba.track_analyze_hot"
pg_dump:= creating VIEW "dba.v_parents_and_loners"
pg_dump: creating VI= EW "dba.v_relations"
pg_dump: creating VIEW "dba.v_table_= size"
pg_dump: processing data for table "dba.index_bloat_1stg= "
pg_dump: dumping contents of table "dba.index_bloat_1stg&quo= t;
pg_dump: processing data for table "dba.index_bloat_2stg"pg_dump: dumping contents of table "dba.index_bloat_2stg"
pg= _dump: processing data for table "dba.pre_analyze_hot"
pg_dump= : dumping contents of table "dba.pre_analyze_hot"
pg_dump: pro= cessing data for table "dba.table_bloat_1stg"
pg_dump: dumping= contents of table "dba.table_bloat_1stg"
pg_dump: processing = data for table "dba.table_bloat_2stg"
pg_dump: dumping content= s of table "dba.table_bloat_2stg"
pg_dump: processing data for= table "dba.track_analyze_hot"
pg_dump: dumping contents of ta= ble "dba.track_analyze_hot"
pg_dump: creating CONSTRAINT "= ;dba.index_bloat_1stg index_bloat_1stg_pkey"
pg_dump: creating CONS= TRAINT "dba.index_bloat_2stg index_bloat_2stg_pkey"
pg_dump: c= reating CONSTRAINT "dba.pre_analyze_hot pre_analyze_hot_pkey"
= pg_dump: creating CONSTRAINT "dba.table_bloat_1stg table_bloat_1stg_pk= ey"
pg_dump: creating CONSTRAINT "dba.table_bloat_2stg table_b= loat_2stg_pkey"
pg_dump: creating CONSTRAINT "dba.track_analyz= e_hot track_analyze_hot_pkey"
pg_dump: creating ACL "SCHEMA db= a"
pg_dump: creating ACL "dba.TABLE all_indices"
pg_du= mp: creating ACL "dba.TABLE all_indices_types"
pg_dump: creati= ng ACL "dba.TABLE latest_vacuum_and_analyze"
pg_dump: creating= ACL "dba.TABLE analyze_levels"
pg_dump: creating ACL "db= a.TABLE latest_toast_vacuum"
pg_dump: creating ACL "dba.TABLE = v_relations"

--
Death to <Redacted>, and butter= sauce.
Don't boil me, I'm still alive.
<Redact= ed> lobster!
--00000000000021d82806364c4612--