Nested Loop  (cost=8.88..7653.69 rows=121 width=12) (actual time=0.155..48.251 rows=28669 loops=1)
      Buffers: shared hit=37748
      ->  Nested Loop  (cost=8.46..7633.26 rows=22 width=12) (actual time=0.143..20.697 rows=1064 loops=1)
            Buffers: shared hit=10584
            ->  Hash Join  (cost=8.18..7622.70 rows=23 width=12) (actual time=0.102..16.798 rows=1109 loops=1)
                  Hash Cond: (capturing_devices.capturing_device_type_id = capturing_device_types.id)
                  Buffers: shared hit=7258
                  ->  Seq Scan on capturing_devices  (cost=0.00..7539.77 rows=28377 width=16) (actual time=0.008..9.492 rows=28377 loops=1)
                        Buffers: shared hit=7256
                  ->  Hash  (cost=8.17..8.17 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)
                        Buckets: 1024  Batches: 1  Memory Usage: 9kB
                        Buffers: shared hit=2
                        ->  Index Scan using index_capturing_device_types_on_name on capturing_device_types  (cost=0.15..8.17 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)
                              Index Cond: ((name)::text = 'ENERGY_COMFOAIR'::text)
                              Buffers: shared hit=2
            ->  Index Scan using gateways_pkey on gateways  (cost=0.28..0.46 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1109)
                  Index Cond: (id = capturing_devices.gateway_id)
                  Filter: (NOT inactive)
                  Rows Removed by Filter: 0
                  Buffers: shared hit=3326
      ->  Index Scan using parameters_type_device_unique on parameters  (cost=0.42..0.82 rows=11 width=12) (actual time=0.005..0.020 rows=27 loops=1064)
            Index Cond: (capturing_device_id = capturing_devices.id)
            Buffers: shared hit=27164
    Planning Time: 0.631 ms
    Execution Time: 62.471 ms