Join Filter: (sj.id_groupe = gp.id_groupe) Join Filter: (gp.id_application = app.id_application) Now, When I'm trying the same query for the current month ( we are the 6th of April, so I'm trying to get all the application_id of April) with the same query SELECT DISTINCT app.id_applicationĪND date_stat Nested Loop (cost=63.49 rows=1 width=4) (actual time=1.945.186619.404 rows=118990 loops=1) > Hash (cost=11.67.11.67 rows=667 width=4) (actual time=0.206.0.206 rows=692 loops=1)īuckets: 1024 Batches: 1 Memory Usage: 25kB ANALYZE collects statistics about the contents of Postgres tables, and stores the results in the system table pgstatistic. Hash Cond: (gp.id_application = app.id_application) LEFT OUTER JOIN application app ON app.id_application = gp.id_applicationĪND date_stat Hash Join (cost=278.99 rows=3186 width=4) (actual time=6.144.2271.984 rows=263274 loops=1) LEFT OUTER JOIN groupe gp ON gp.id_groupe = sj.id_groupe 7.98K subscribers Subscribe 9.9K views 1 year ago pgAdmin Tutorials Nikhil Mohite from EDB demonstrates the Explain and Explain Analyze feature available in pgAdmin 4.
This is my working query : SELECT DISTINCT app.id_application My request doesn't do the same operation. Depending on wich date paramter I'm using. I am using PostgreSQL and I have a weird problem with my SQL query.
0 kommentar(er)
