Evan Carroll > PSQL-Query-0.01_01 > psql-plus

Download:
PSQL-Query-0.01_01.tar.gz

Annotate this POD

Source   Latest Release: PSQL-Query-0.01_02

NAME ^

psql-plus - Utility to enhance the functionality of psql

SYNOPSIS ^

        EXPLAIN SELECT * FROM <table> | psql -d <database> | psql-plus --printf "%n"

        psql -d database
        \o|psql-plus --printf "%n"
        EXPLAIN SELECT * FROM <table>
        EXPLAIN SELECT * FROM <other table>
        ^D

DESCRIPTION ^

Arguements

--printf ( Operation Row )
        %n = name
        %s = src
        %d = dom_level

        %e*  explain/estimate
        %a*  actual

        %es = Estimate startup
        %et = Estimate total
        %er = Estimate rows
        %ew = Estimate width

        %as = Actual (time) Startup
        %at = Actual (time) Total
        %ar = Actual Rows
        %al = Actual Loops
--printf-info ( OperationInfo Row )
        %n = Info name
        %v = Info verbose (not currently further parsed)
        %s = Source (unmodified)

BUGS ^

Email me they will get fixed in .05 seconds, or you can sue someone else.

CAVEATS ^

Currently limited to "Enhancing" only the functionality of EXPLAIN and EXPLAIN ANALYZE

COPYRIGHT ^

Artistic or GPL, like 99.9% of CPAN-distributed stuff.

AVAILABILITY ^

CPAN

http://repo.or.cz/w/Pqsl-Perl.git

AUTHOR ^

Evan Carroll <me at evancarroll.com>

syntax highlighting: