Re: [GENERAL] Tables used in query not listed in EXPLAIN

2014-10-16 Thread Tom Lane
Alvaro Melo writes: > I have a peculiar situation here. I'm optimizing some queries and I > noticed that EXPLAIN doesn't always show the tables involved in the > query. Below is a little example, but I have other examples with longer > queries. Note that the tables tabela_documento_fiscal and p

[GENERAL] Tables used in query not listed in EXPLAIN

2014-10-16 Thread Alvaro Melo
Hi, I have a peculiar situation here. I'm optimizing some queries and I noticed that EXPLAIN doesn't always show the tables involved in the query. Below is a little example, but I have other examples with longer queries. Note that the tables tabela_documento_fiscal and pessoa aren't considere