Cost and execution plan

Поиск
Список
Период
Сортировка
От AminPG Jaffer
Тема Cost and execution plan
Дата
Msg-id CAJ9dAqmsxHiTR_F5252cRMCaW3AGaeaHL5DMteS_3qOMdFkpBQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cost and execution plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: GiST "choose subtree" support function to inline penalty
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cost and execution plan