Performance Analysis in PostgreSQL

Question

I am using PostgreSQL with c++ and I am trying to analyse the performance of different queries. I tried using EXPLAIN ANALYZE but I can't figure out how to print the result on screen. How can I do so?

What exactly do you mean with "print the result on screen". When running EXPLAIN ANALYZE, the result returned from the server will be the execution plan. So you'd print it as any other result you obtain through your SQL client. How exactly are you running the EXPLAIN? Which tool are you using? — user330315
– user330315, Commented May 2, 2011 at 9:14
I tried to print it with: res1 = PQexec(conn, explainQuery.c_str()); for (int i= 0; i < PQntuples(res1); i++) { for (int j = 0; j < nFields; j++) { temp_value = PQgetvalue(res1, i, j); cout << temp_value; } } — Performance
– Performance, Commented May 2, 2011 at 9:53
Should work as it is "just a result" But I don't do C++, so I cannot tell for sure. Did you try it with psql? — user330315
– user330315, Commented May 2, 2011 at 9:59
It's weird but the same syntax seems to work now. I guess I messed up while declaring variables or something. Thanks though. :) — Performance
– Performance, Commented May 2, 2011 at 10:13

Zan Lynx · Accepted Answer · 2011-05-02 15:32:26Z

1

The psql command-line tool will run queries and display the results.

answered May 2, 2011 at 15:32

Zan Lynx

54.7k11 gold badges85 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Performance Analysis in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related