Where the time was spent ?- Analyze explain plan.

[haiza...@gmail.com]

Hi All and happy new year...

I use cstore as my main data store in pg.

I execute a query and  when I analyze the "explain analyze" log, the "actual time" jump to higher numbers and I can't find the command/s that spent the time.

I will be thankful to get any direction.

Thanks in advance,

Hai

[Murat Tuncer]

Could you tell us about the jump ? How much is when you run the query, and  how much is when you do explain analyze ?

analyzing the table helps postges making better decisions especially for queries involving joins and subqueries.

Could you try "analyze  <your_cstore_table>" if  you  haven't done so ?

thanks

--
You received this message because you are subscribed to the Google Groups "cstore users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cstore-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Murat Tuncer
Software Engineer | Citus Data
mtu...@citusdata.com

[haiza...@gmail.com]

Thanks Murat,

I check and updated in the post.

Hai