#	exclusive	inclusive	rows x	rows	loops	node
1.	0.099	12.928	↑ 1.0	1	1	→ Aggregate (cost=50.49..50.50 rows=1 width=0) (actual time=12.927..12.928 rows=1 loops=1)
2.	0.894	12.829	↓ 452.0	452	1	→ Nested Loop (cost=0.00..50.49 rows=1 width=0) (actual time=1.720..12.829 rows=452 loops=1) Join Filter: (stoqs_measuredparameter.parameter_id = stoqs_parameter.id)
3.	0.011	0.011	↑ 1.0	1	1	→ Seq Scan on stoqs_parameter (cost=0.00..2.16 rows=1 width=4) (actual time=0.008..0.011 rows=1 loops=1) Filter: ((name)::text = 'bbp700'::text)
4.	4.068	11.924	↓ 410.9	4520	1	→ Nested Loop (cost=0.00..48.19 rows=11 width=4) (actual time=1.708..11.924 rows=4520 loops=1)
5.	0.320	5.596	↓ 226.0	452	1	→ Nested Loop (cost=0.00..46.89 rows=2 width=4) (actual time=1.704..5.596 rows=452 loops=1)
6.	1.728	4.372	↓ 226.0	452	1	→ Nested Loop (cost=0.00..43.96 rows=2 width=4) (actual time=1.697..4.372 rows=452 loops=1) Join Filter: (stoqs_activity.id = stoqs_instantpoint.activity_id)
7.	0.014	0.036	↓ 16.0	16	1	→ Nested Loop (cost=0.00..17.23 rows=1 width=4) (actual time=0.005..0.036 rows=16 loops=1) Join Filter: (stoqs_activity.platform_id = stoqs_platform.id)
8.	0.003	0.003	↑ 1.0	1	1	→ Seq Scan on stoqs_platform (cost=0.00..12.38 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1) Filter: ((name)::text = 'dorado'::text)
9.	0.019	0.019	↑ 1.0	38	1	→ Seq Scan on stoqs_activity (cost=0.00..4.38 rows=38 width=8) (actual time=0.001..0.019 rows=38 loops=1)
10.	2.608	2.608	↓ 1.2	481	16	→ Index Scan using stoqs_instantpoint_timevalue on stoqs_instantpoint (cost=0.00..21.56 rows=413 width=8) (actual time=0.005..0.163 rows=481 loops=16) Index Cond: ((timevalue <= '2010-10-14 15:33:54-07'::timestamp with time zone) AND (timevalue >= '2010-10-13 19:33:47-07'::timestamp with time zone))
11.	0.904	0.904	↑ 1.0	1	452	→ Index Scan using stoqs_measurement_instantpoint_id on stoqs_measurement (cost=0.00..1.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=452) Index Cond: (instantpoint_id = stoqs_instantpoint.id) Filter: ((depth >= (-2.1)::double precision) AND (depth <= 43.34::double precision))
12.	2.260	2.260	↓ 1.4	10	452	→ Index Scan using stoqs_measuredparameter_measurement_id on stoqs_measuredparameter (cost=0.00..0.56 rows=7 width=8) (actual time=0.002..0.005 rows=10 loops=452) Index Cond: (measurement_id = stoqs_measurement.id)

                                                                                      QUERY PLAN                                                                                       
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=50.49..50.50 rows=1 width=0) (actual time=12.927..12.928 rows=1 loops=1)
   ->  Nested Loop  (cost=0.00..50.49 rows=1 width=0) (actual time=1.720..12.829 rows=452 loops=1)
         Join Filter: (stoqs_measuredparameter.parameter_id = stoqs_parameter.id)
         ->  Seq Scan on stoqs_parameter  (cost=0.00..2.16 rows=1 width=4) (actual time=0.008..0.011 rows=1 loops=1)
               Filter: ((name)::text = 'bbp700'::text)
         ->  Nested Loop  (cost=0.00..48.19 rows=11 width=4) (actual time=1.708..11.924 rows=4520 loops=1)
               ->  Nested Loop  (cost=0.00..46.89 rows=2 width=4) (actual time=1.704..5.596 rows=452 loops=1)
                     ->  Nested Loop  (cost=0.00..43.96 rows=2 width=4) (actual time=1.697..4.372 rows=452 loops=1)
                           Join Filter: (stoqs_activity.id = stoqs_instantpoint.activity_id)
                           ->  Nested Loop  (cost=0.00..17.23 rows=1 width=4) (actual time=0.005..0.036 rows=16 loops=1)
                                 Join Filter: (stoqs_activity.platform_id = stoqs_platform.id)
                                 ->  Seq Scan on stoqs_platform  (cost=0.00..12.38 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1)
                                       Filter: ((name)::text = 'dorado'::text)
                                 ->  Seq Scan on stoqs_activity  (cost=0.00..4.38 rows=38 width=8) (actual time=0.001..0.019 rows=38 loops=1)
                           ->  Index Scan using stoqs_instantpoint_timevalue on stoqs_instantpoint  (cost=0.00..21.56 rows=413 width=8) (actual time=0.005..0.163 rows=481 loops=16)
                                 Index Cond: ((timevalue <= '2010-10-14 15:33:54-07'::timestamp with time zone) AND (timevalue >= '2010-10-13 19:33:47-07'::timestamp with time zone))
                     ->  Index Scan using stoqs_measurement_instantpoint_id on stoqs_measurement  (cost=0.00..1.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=452)
                           Index Cond: (instantpoint_id = stoqs_instantpoint.id)
                           Filter: ((depth >= (-2.1)::double precision) AND (depth <= 43.34::double precision))
               ->  Index Scan using stoqs_measuredparameter_measurement_id on stoqs_measuredparameter  (cost=0.00..0.56 rows=7 width=8) (actual time=0.002..0.005 rows=10 loops=452)
                     Index Cond: (measurement_id = stoqs_measurement.id)
 Total runtime: 13.000 ms
(22 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.099 ms	0.8 %
Index Scan	3	5.772 ms	44.6 %
Nested Loop	5	7.024 ms	54.3 %
Seq Scan	3	0.033 ms	0.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
stoqs_activity	1	0.019 ms	0.1 %
Seq Scan	1	0.019 ms	100.0 %
stoqs_instantpoint	1	2.608 ms	20.2 %
Index Scan	1	2.608 ms	100.0 %
stoqs_measuredparameter	1	2.260 ms	17.5 %
Index Scan	1	2.260 ms	100.0 %
stoqs_measurement	1	0.904 ms	7.0 %
Index Scan	1	0.904 ms	100.0 %
stoqs_parameter	1	0.011 ms	0.1 %
Seq Scan	1	0.011 ms	100.0 %
stoqs_platform	1	0.003 ms	0.0 %
Seq Scan	1	0.003 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tbo

Colorize:

Columns visibility:

Per node type stats

Per table stats