Обсуждение: debug query execution

Поиск
Список
Период
Сортировка

debug query execution

От
vadym nikolaiev
Дата:
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

Re: debug query execution

От
"Kevin Grittner"
Дата:
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