#	exclusive	inclusive	rows x	rows	loops	node
1.	0.010	0.060	↑ 1.0	1	1	→ Aggregate (cost=8.28..8.29 rows=1 width=8) (actual time=0.059..0.060 rows=1 loops=1)
2.	0.050	0.050	↑ 1.0	1	1	→ Index Scan using finop_partner_id_idx on financeoperations (cost=0.00..8.27 rows=1 width=8) (actual time=0.047..0.050 rows=1 loops=1) Index Cond: (partner_id = 1) Filter: ((date > '2011-02-01'::date) AND (date < '2012-09-09'::date))

                                                                  QUERY PLAN                                                                  
----------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=8.28..8.29 rows=1 width=8) (actual time=0.059..0.060 rows=1 loops=1)
   ->  Index Scan using finop_partner_id_idx on financeoperations  (cost=0.00..8.27 rows=1 width=8) (actual time=0.047..0.050 rows=1 loops=1)
         Index Cond: (partner_id = 1)
         Filter: ((date > '2011-02-01'::date) AND (date < '2012-09-09'::date))
 Total runtime: 0.227 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.010 ms	16.7 %
Index Scan	1	0.050 ms	83.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
financeoperations	1	0.050 ms	83.3 %
Index Scan	1	0.050 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: zd7

Colorize:

Columns visibility:

Per node type stats

Per table stats