Cost and execution plan

From: AminPG Jaffer <aminjaffer(dot)pg(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Cost and execution plan
Date: 2019-06-27 03:49:08
Message-ID: CAJ9dAqmsxHiTR_F5252cRMCaW3AGaeaHL5DMteS_3qOMdFkpBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

We are facing an issue where the cost shows up "cost=10000000000.00" so
trying to find where that is set.

Could anyone point me to the code where the cost "cost=10000000000.00" is
set?

It doesn't show up when searching through find.

find . -type f -print | xargs grep 10000000000 | grep -v "/test/" | grep -v
"/btree_gist/"
./postgresql-9.6.12/contrib/pgcrypto/sql/blowfish.sql:decode('1000000000000001',
'hex'),
./postgresql-9.6.12/contrib/pgcrypto/expected/blowfish.out:decode('1000000000000001',
'hex'),
./postgresql-9.6.12/doc/src/sgml/html/functions-admin.html:
00000001000000000000000D | 4039624
./postgresql-9.6.12/doc/src/sgml/html/wal-internals.html:>000000010000000000000000</TT
./postgresql-9.6.12/doc/src/sgml/func.sgml: 00000001000000000000000D |
4039624
./postgresql-9.6.12/doc/src/sgml/wal.sgml:
<filename>000000010000000000000000</filename>. The numbers do not wrap,
./postgresql-9.6.12/src/bin/pg_archivecleanup/pg_archivecleanup.c: *
000000010000000000000010.partial and
./postgresql-9.6.12/src/bin/pg_archivecleanup/pg_archivecleanup.c: *
000000010000000000000010.00000020.backup are after
./postgresql-9.6.12/src/bin/pg_archivecleanup/pg_archivecleanup.c: *
000000010000000000000010.
./postgresql-9.6.12/src/bin/pg_archivecleanup/pg_archivecleanup.c:
" pg_archivecleanup /mnt/server/archiverdir
000000010000000000000010.00000020.backup\n");
./postgresql-9.6.12/src/backend/utils/adt/numeric.c: * For input like
10000000000, we must treat stripped digits as real. So
./postgresql-9.6.12/src/backend/utils/adt/numeric.c: * For input like
10000000000, we must treat stripped digits as real. So
./postgresql-9.6.12/src/backend/utils/adt/cash.c: m4 = (val /
INT64CONST(100000000000)) % 1000; /* billions */
./postgresql-9.6.12/src/backend/utils/adt/cash.c: m5 = (val /
INT64CONST(100000000000000)) % 1000; /* trillions */
./postgresql-9.6.12/src/backend/utils/adt/cash.c: m6 = (val /
INT64CONST(100000000000000000)) % 1000; /* quadrillions */
./postgresql-9.6.12/src/backend/utils/adt/date.c:
10000000000.0
./postgresql-9.6.12/src/include/utils/date.h:#define TIME_PREC_INV
10000000000.0

Thanks

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-06-27 04:03:14 Re: Cost and execution plan
Previous Message Tom Lane 2019-06-27 03:00:51 Re: GiST "choose subtree" support function to inline penalty