gistfile1.txt

Subquery Scan on readings  (cost=10.73..102015.07 rows=1389693 width=114) (actual time=22.032..1301.076 rows=1395727 loops=1)
  ->  Append  (cost=10.73..88118.14 rows=1389693 width=114) (actual time=22.031..1152.558 rows=1395727 loops=1)
        ->  Subquery Scan on "*SELECT* 1"  (cost=10.73..74194.32 rows=1170975 width=65) (actual time=22.030..974.524 rows=1176991 loops=1)
              ->  Hash Join  (cost=10.73..56629.69 rows=1170975 width=57) (actual time=22.029..841.099 rows=1176991 loops=1)
                    Hash Cond: ((hmr.serial_from_message)::text = (hm.serial_number)::text)
                    ->  Seq Scan on heat_meter_reading hmr  (cost=0.00..53501.59 rows=1170975 width=84) (actual time=21.886..521.456 rows=1176991 loops=1)
                          Filter: (COALESCE(datetime_heat_meter, timestamp_utc) IS NOT NULL)
                    ->  Hash  (cost=6.99..6.99 rows=299 width=41) (actual time=0.128..0.130 rows=299 loops=1)
                          Buckets: 1024  Batches: 1  Memory Usage: 23kB
                          ->  Seq Scan on heat_meter hm  (cost=0.00..6.99 rows=299 width=41) (actual time=0.015..0.073 rows=299 loops=1)
        ->  Seq Scan on modbus_reading  (cost=0.00..4788.18 rows=218718 width=61) (actual time=0.097..58.733 rows=218736 loops=1)
Planning Time: 0.536 ms
JIT:
  Functions: 17
  Options: Inlining false, Optimization false, Expressions true, Deforming true
  Timing: Generation 3.213 ms, Inlining 0.000 ms, Optimization 1.648 ms, Emission 19.789 ms, Total 24.650 ms
Execution Time: 1357.278 ms