explain.depesz.com

A tool for finding a real cause for slow queries.

Result: kAY

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Subquery Scan on x (cost=196839.11..196839.13 rows=1 width=204) (actual time=.. rows= loops=)

  • Filter: (x.rank = 1)
2. 0.000 0.000 ↓ 0.0

Sort (cost=196839.11..196839.12 rows=1 width=162) (actual time=.. rows= loops=)

  • Sort Key: tr.begin_time, f.dataset_id
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=196839.07..196839.10 rows=1 width=162) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=196839.07..196839.08 rows=1 width=162) (actual time=.. rows= loops=)

  • Sort Key: f.dataset_id, f.coordinate_1_id, f.shadow_coordinate_2_id, f.produced_id
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..196839.06 rows=1 width=162) (actual time=.. rows= loops=)

  • Join Filter: (s.type_id = st.id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..196838.04 rows=1 width=160) (actual time=.. rows= loops=)

  • Join Filter: (f.dataset_id = d.id)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..196818.55 rows=25 width=142) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on time_ranges tr (cost=0.00..4632.38 rows=1 width=20) (actual time=.. rows= loops=)

  • Filter: ((begin_time >= '2012-03-22 00:00:00'::timestamp without time zone) AND (begin_time <= '2012-03-2
9. 0.000 0.000 ↓ 0.0

Index Scan using files_pkey on files f (cost=0.00..192185.43 rows=59 width=126) (actual time=.. rows= loops=)

  • Index Cond: (coordinate_1_id = tr.id)
10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..18.74 rows=2 width=18) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..18.73 rows=2 width=18) (actual time=.. rows= loops=)

  • Join Filter: (s.id = d.sensor_id)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..2.03 rows=1 width=12) (actual time=.. rows= loops=)

  • Join Filter: (s.platform_id = p.id)
13. 0.000 0.000 ↓ 0.0

Seq Scan on sensors s (cost=0.00..1.01 rows=1 width=12) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on platforms p (cost=0.00..1.01 rows=1 width=8) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on ingested_datasets d (cost=0.00..16.62 rows=6 width=14) (actual time=.. rows= loops=)

  • Filter: ((ingest_file_type)::text = ANY ('{GITCO,SVI01,SVI02,SVI03,SVI04,SVI05}'::text[]))
16. 0.000 0.000 ↓ 0.0

Seq Scan on sensor_types st (cost=0.00..1.01 rows=1 width=10) (actual time=.. rows= loops=)