Show in psql does any calculations?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Show in psql does any calculations?
Дата
Msg-id CA+h6AhjWypc-m=zQNizy1_dAcxQF14to_udvozOZDfJO9d-OEg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Show in psql does any calculations?
Список pgsql-general
Дерево обсуждения
Respected,

Am in PG 9.1. See below ouputs.

By query:
postgres=# SELECT name, setting, unit,context FROM pg_settings WHERE category like '%Resource Usage / Memory%' ORDER BY name;
           name            | setting | unit |  context
---------------------------+---------+------+------------
 maintenance_work_mem      | 16384   | kB   | user
 max_prepared_transactions  | 0          |       | postmaster
 max_stack_depth                 | 2048    | kB   | superuser
 shared_buffers                     | 4096    | 8kB  | postmaster
 temp_buffers                       | 1024    | 8kB  | user
 track_activity_query_size     | 1024    |      | postmaster
 work_mem                          | 2048    | kB   | user
(7 rows)

By session command:
postgres=# show work_mem ;
 work_mem
----------
 2MB
(1 row)

postgres=# show shared_buffers ;
 shared_buffers
----------------
 32MB
(1 row)

By the query, its clear that "setting" value is multiplied with unit to get the sesssion level command value which is displayed here. However, I am trying to get the query of it which is executed at session-level with SHOW command. I tried "psql -E" option tooo..

-bash-3.2$ psql -E
psql.bin (9.1.0)
Type "help" for help.

postgres=# show work_mem ;
 work_mem
----------
 2MB
(1 row)

Why the query is not displayed with -E option ?  
Am I missing something here, please help me in clarifying it.

---
Regards,
Raghavendra
EnterpriseDB Corporation

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

Предыдущее
От: AI Rumman
Дата:
Сообщение: Re: Why does index not use for CTE query?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Show in psql does any calculations?