Re: [PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one

2016-10-14 Thread Kyle Moser
he index due to the types being numeric and the index being bigint? (I suppose my question here is how to interpret the output properly - so I don't make this mistake again). On Fri, Oct 14, 2016 at 1:46 PM, Tom Lane wrote: > Kyle Moser writes: > > The depesz link for explain (ana

[PERFORM] Hibernate generated query slow compared to 'equivalent' hand written one

2016-10-14 Thread Kyle Moser
The depesz link for explain (analyze, buffers) is shown below for 3 different queries. The first two queries show a log dump of the postgres log, showing a query that was generated by Java Hibernate. The third query was one I wrote and ran in pgadmin that I think is similar to what Hibernate is doi