explain.depesz.com

A tool for finding a real cause for slow queries.

Result: KE8

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 3.233 3,627.180 ↑ 2.4 469 1

Limit (cost=7,364.69..7,384.10 rows=1,109 width=48) (actual time=3,622.157..3,627.180 rows=469 loops=1)

2. 645.297 3,623.947 ↑ 2.4 469 1

HashAggregate (cost=7,364.69..7,384.10 rows=1,109 width=48) (actual time=3,622.148..3,623.947 rows=469 loops=1)

3. 531.729 2,978.650 ↓ 4.7 66,122 1

Merge Join (cost=6,163.19..6,522.65 rows=14,034 width=48) (actual time=2,207.216..2,978.650 rows=66,122 loops=1)

  • Merge Cond: (((weather_station.id)::bigint) = ((core.post_proc_result.fk_weather_station_id)::bigint))
4. 7.922 13.103 ↑ 1.5 784 1

Sort (cost=82.71..85.58 rows=1,148 width=27) (actual time=10.425..13.103 rows=784 loops=1)

  • Sort Key: ((weather_station.id)::bigint)
  • Sort Method: quicksort Memory: 140kB
5. 5.181 5.181 ↑ 1.0 1,126 1

Seq Scan on weather_station (cost=0.00..24.36 rows=1,148 width=27) (actual time=0.015..5.181 rows=1,126 loops=1)

  • Filter: ((friendly_name)::text <> ''::text)
6. 501.405 2,433.818 ↓ 28.1 68,789 1

Sort (cost=6,080.48..6,086.59 rows=2,445 width=33) (actual time=2,196.766..2,433.818 rows=68,789 loops=1)

  • Sort Key: ((core.post_proc_result.fk_weather_station_id)::bigint)
  • Sort Method: quicksort Memory: 8447kB
7. 267.655 1,932.413 ↓ 28.1 68,789 1

Hash Join (cost=5,884.58..5,942.88 rows=2,445 width=33) (actual time=1,660.685..1,932.413 rows=68,789 loops=1)

  • Hash Cond: ((geo_location.id)::bigint = core.post_proc_result.fk_weather_station_id)
8. 4.114 4.114 ↑ 1.0 1,149 1

Seq Scan on geo_location (cost=0.00..19.49 rows=1,149 width=21) (actual time=0.011..4.114 rows=1,149 loops=1)

9. 267.038 1,660.644 ↓ 66.7 68,789 1

Hash (cost=5,871.68..5,871.68 rows=1,032 width=28) (actual time=1,660.644..1,660.644 rows=68,789 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4031kB
10. 275.066 1,393.606 ↓ 66.7 68,789 1

Hash Join (cost=4,897.42..5,871.68 rows=1,032 width=28) (actual time=1,115.949..1,393.606 rows=68,789 loops=1)

  • Hash Cond: ((((core.post_proc_result.fk_weather_parameter_id)::bigint) = core.post_proc_result.fk_weather_parameter_id) AND (((core.post_proc_result.fk_weather_station_id)::bigint) = core.post_proc_result.fk_weather_station_id))
11. 267.068 533.690 ↑ 2.0 719 1

HashAggregate (cost=2,362.72..2,388.19 rows=1,455 width=8) (actual time=531.057..533.690 rows=719 loops=1)

12. 266.622 266.622 ↑ 1.0 68,789 1

Seq Scan on post_proc_result (cost=0.00..1,846.81 rows=68,789 width=8) (actual time=0.012..266.622 rows=68,789 loops=1)

13. 287.075 584.850 ↑ 1.0 68,789 1

Hash (cost=1,502.86..1,502.86 rows=68,789 width=16) (actual time=584.850..584.850 rows=68,789 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 3225kB
14. 297.775 297.775 ↑ 1.0 68,789 1

Seq Scan on post_proc_result (cost=0.00..1,502.86 rows=68,789 width=16) (actual time=0.014..297.775 rows=68,789 loops=1)

  • Filter: (calc_type = 'avg'::bpchar)