Evan Carroll > PSQL-Query > psql-plus

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

Annotate this POD

Source  

NAME ^

psql-plus - Utility to enhance the functionality of psql

SYNOPSIS ^

        echo 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

        psql-plus --dom-char x --printf "%d"

DESCRIPTION ^

Arguments

--dom-char ( graphic char for dom-level '%d' representation )
--printf ( Operation Row )
        %n = name
        %s = src
        %d = dom_level ( see notes below )

        %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

* dom_level: If you run an explain this is the whitespace significant portion from the left-margin to the first \S.

--printf-info ( OperationInfo Row )
        %n = Info name
        %v = Info verbose (not currently further parsed)
        %s = Source (unmodified)

PSQL::Query

This is currently just a script for the PSQL::Query library. All of the voodoo happens there.

Not-yet-implimented --lookforward-to

Roadmap to .01:

Roadmap to .02:

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: