Benchmarking PostgreSQL queries

CheckQueryRunTime

checkqueryruntime

CheckQueryRunTime

Change the extension to .pl and run with ‘-help’ to see a detailed usage explanation.

Bookmark the permalink.

2 Responses to CheckQueryRunTime

  1. tr!ckle says:

    I had an error after execution of this script:

    install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 4) line 3.
    Perhaps the DBD::Pg perl module hasn't been fully installed,
    or perhaps the capitalisation of 'Pg' isn't right.
    Available drivers: DBM, ExampleP, File, Gofer, PgLite, PgPP, Proxy, SQLite, Sponge, mysql.

    Solution:
    In line 208 if you change DBI:Pg to DBI:PgPP there is everything ok.

    Regards.

  2. yuval says:

    Thanks for the tip!
    Another solution would be to install the Perl DBD::Pg module (the RPM is perl-DBD-Pg).

Leave a Reply

Your email address will not be published. Required fields are marked *