58 Check settings

    58 Check settings

    59 ==============

    59 ==============

    60 ::

    60 ::

    61 

    61 

    62    SELECT name, setting FROM pg_settings;

    62    SELECT name, setting FROM pg_settings;

    63 

    64 

    64 Check extensions

    65 Check extensions

    65 ================

    66 ================

    66 ::

    67 ::

    67 

    68 

   495 

   496 

   496 Connect by::

   497 Connect by::

   497 

   498 

   498   $ psql -U $USER -h $HOST -p $PORT  $SCHEMA

   499   $ psql -U $USER -h $HOST -p $PORT  $SCHEMA

   499 

   500 

   500 How to view execution plan::

   505 How to view execution plan::

   501 

   506 

   502   EXPLAIN query;

   507   EXPLAIN query;

   503   EXPLAIN ANALYZE query;

   508   EXPLAIN ANALYZE query;

   504 

   509