• NAME
• SYNOPSIS
• DESCRIPTION
  • Arguements
• BUGS
• CAVEATS
• COPYRIGHT
• AVAILABILITY
• AUTHOR

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>