Search Postgresql Archives

Re: Show <parameter> in psql does any calculations?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2011-12-27 at 14:56 +0530, Raghavendra wrote:
> 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.
> 

-E works only for meta-commands, ie commands which start with \

Moreover, SHOW is an actual SQL command. So I'm not sure what you're
trying to find with the -E command line switch.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com
  PostgreSQL Sessions #3: http://www.postgresql-sessions.org


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux