explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tbo

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)