debug query execution

Started by vadym nikolaievabout 14 years ago2 messages
#1vadym nikolaiev
vadym.nikolaiev@gmail.com

Hi.

I would like to ask you which sources are responsible for execute queries in
PostgreSQL?
( i would like to run a simple query and debug it execution on PostgreSql
server for understanding how PostgeSql does query processing internally)

regards,
Vadym

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: vadym nikolaiev (#1)
Re: debug query execution

vadym nikolaiev <vadym.nikolaiev@gmail.com> wrote:

I would like to ask you which sources are responsible for execute
queries in PostgreSQL?

http://wiki.postgresql.org/wiki/Developer_FAQ#How_is_the_source_code_organized.3F

( i would like to run a simple query and debug it execution on
PostgreSql server for understanding how PostgeSql does query
processing internally)

Pick any function you know will be executed, set a breakpoint, get a
stacktrace from there, and pick where you want to get in next time
you run the query.

-Kevin