author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Mon, 21 Oct 2019 21:19:27 +0300 | |
changeset 2388 | 4339ed4bd568 |
parent 2387 | eede82d48288 |
child 2389 | 6548a372f31f |
postgres.rst | file | annotate | diff | comparison | revisions |
--- a/postgres.rst Mon Oct 21 18:23:02 2019 +0300 +++ b/postgres.rst Mon Oct 21 21:19:27 2019 +0300 @@ -60,6 +60,7 @@ :: SELECT name, setting FROM pg_settings; + SELECT name, current_setting(name), source FROM pg_settings; Check extensions ================ @@ -497,6 +498,10 @@ $ psql -U $USER -h $HOST -p $PORT $SCHEMA +Switch to long lines format:: + + \x + How to view execution plan:: EXPLAIN query;