Home > mailing lists

parse tree reading - Mailing list pgsql-admin

From	Katherina Litvina
Subject	parse tree reading
Date	March 18, 2011 07:14:12
Msg-id	AANLkTin99GY-tOJk6FOZhq8zA8v6RyJePMqOGed3Nj-k@mail.gmail.com Whole thread Raw
List	pgsql-admin

Tree view

In order to implement the incremental updates of materialized views I need to read parse trees from csv logs (debug_print_parse option). How can I interpret the indexes of all operations and tables and get the real names of all relations?

For example, which data and operation types do the values 1760 and 1700 refer to?

OPEXPR 
         :opno 1760 
         :opfuncid 0 
         :opresulttype 1700 
         :opretset false

Best regards,
Katherina Litvina

pgsql-admin by date:

From: leslie samuel
Date: 18 March 2011, 05:16:55
Subject: Re: pg_stat_all_tables column value reseting problem.

From: Tapio Pitkäranta
Date: 18 March 2011, 07:14:21
Subject: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?

parse tree reading - Mailing list pgsql-admin

Previous

Next