explain-analyze.info | query-plan-1148

Summary: Sort (cost=65.50..65.51 rows=5 width=37) Sort Key: (sum(date_part('epoch'::text, se.duree))) -> HashAggregate (cost=65.35..65.44 rows=5 width=37) -> Nested Loop (cost=18.17..65.30 rows=5 width=37) -> Hash Join (cost=18.17..28.12 rows=3 width=31) Hash Cond: (svc.id = se.service) -> Seq Scan on services svc (cost=0.00..8.85 rows=285 width=15) -> Hash (cost=18.13..18.13 rows=3 width=24) -> Append (cost=4.27..18.13 rows=3 width=24) -> Bitmap Heap Scan on stats_entrantes se (cost=4.27..9.62 rows=2 width=24) Recheck Cond: ((dt_cx >= '2008-10-20 03:00:00+02'::timestamp with time zone) AND (dt_cx <= '2008-10-20 16:00:00+02'::timestamp with time zone)) -> Bitmap Index Scan on stats_entrantesidx1 (cost=0.00..4.27 rows=2 width=0) Index Cond: ((dt_cx >= '2008-10-20 03:00:00+02'::timestamp with time zone) AND (dt_cx <= '2008-10-20 16:00:00+02'::timestamp with time zone)) -> Index Scan using stats_entrantes_200810_dt_cx_key on stats_entrantes_200810 se (cost=0.00..8.51 rows=1 width=24) Index Cond: ((dt_cx >= '2008-10-20 03:00:00+02'::timestamp with time zone) AND (dt_cx <= '2008-10-20 16:00:00+02'::timestamp with time zone)) -> Index Scan using appels_entrants_pkey on appels_entrants ae (cost=0.00..12.37 rows=2 width=14) Index Cond: (ae.id_cx = se.id_cx)

To check the planner's accuracy, run [EXPLAIN ANALYZE].
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.