Aggregate  (cost=3′596.32..3′596.33 rows=1 width=8) (actual time=11.919..11.928 rows=1 loops=1)
  ->  Nested Loop Left Join  (cost=322.16..3′596.31 rows=1 width=0) (actual time=3.821..11.906 rows=79 loops=1)
        Filter: (((COALESCE(am.payment_state, 'paid'::character varying))::character varying(32))::text = 'paid'::text)
        ->  Hash Join  (cost=321.72..3′549.86 rows=28 width=16) (actual time=3.739..8.696 rows=79 loops=1)
              Hash Cond: (c.type_id = ct.id)
              ->  Hash Join  (cost=320.49..3′548.53 rows=28 width=20) (actual time=3.709..8.613 rows=79 loops=1)
                    Hash Cond: (t.connector_uuid = (c.enelx_uuid)::uuid)
                    ->  Nested Loop  (cost=68.32..3′285.30 rows=20 width=32) (actual time=1.410..6.215 rows=79 loops=1)
                          ->  Index Scan using res_partner_pkey on res_partner p  (cost=0.29..2.81 rows=1 width=9) (actual time=0.037..0.040 rows=1 loops=1)
                                Index Cond: (id = 17′079)
                          ->  Nested Loop  (cost=68.03..3′282.29 rows=20 width=36) (actual time=1.371..6.160 rows=79 loops=1)
                                ->  Hash Join  (cost=67.76..3′275.57 rows=20 width=40) (actual time=1.353..5.964 rows=79 loops=1)
                                      Hash Cond: ((cp.enelx_uuid)::uuid = t.charge_point_uuid)
                                      ->  Seq Scan on cpms_cp cp  (cost=0.00..3′167.78 rows=678 width=41) (actual time=0.011..3.909 rows=678 loops=1)
                                      ->  Hash  (cost=67.57..67.57 rows=15 width=60) (actual time=1.265..1.267 rows=79 loops=1)
                                            Buckets: 1′024  Batches: 1  Memory Usage: 16kB
                                            ->  Index Scan using idx_customer_stopped on transactions t  (cost=0.42..67.57 rows=15 width=60) (actual time=0.067..1.229 rows=79 loops=1)
                                                  Index Cond: (customer_id = 17′079)
                                                  Filter: (((id IS NOT NULL) OR (reservation_id IS NOT NULL)) AND (total_amount > '1'::numeric) AND ((owner_id <> 2) OR (owner_id IS NULL)))
                                                  Rows Removed by Filter: 42
                                ->  Index Only Scan using cpms_object_pkey on cpms_object o  (cost=0.27..0.34 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=79)
                                      Index Cond: (id = cp.object_id)
                                      Heap Fetches: 8
                    ->  Hash  (cost=234.30..234.30 rows=1′430 width=41) (actual time=2.275..2.276 rows=1′430 loops=1)
                          Buckets: 2′048  Batches: 1  Memory Usage: 123kB
                          ->  Seq Scan on cpms_cp_connector c  (cost=0.00..234.30 rows=1′430 width=41) (actual time=0.011..0.856 rows=1′430 loops=1)
              ->  Hash  (cost=1.10..1.10 rows=10 width=4) (actual time=0.015..0.016 rows=10 loops=1)
                    Buckets: 1′024  Batches: 1  Memory Usage: 9kB
                    ->  Seq Scan on cpms_cp_connector_type ct  (cost=0.00..1.10 rows=10 width=4) (actual time=0.006..0.009 rows=10 loops=1)
        ->  Memoize  (cost=0.44..2.96 rows=1 width=42) (actual time=0.039..0.040 rows=1 loops=79)
              Cache Key: ((t.uuid)::character varying)::text
              Cache Mode: logical
              Hits: 0  Misses: 79  Evictions: 0  Overflows: 0  Memory Usage: 14kB
              ->  Index Scan using account_move_reference_uuid_index on account_move am  (cost=0.43..2.95 rows=1 width=42) (actual time=0.037..0.038 rows=1 loops=79)
                    Index Cond: ((reference_uuid)::text = ((t.uuid)::character varying)::text)
                    Filter: ((invoice_origin)::text = 'transaction'::text)
Planning Time: 5.863 ms
Execution Time: 12.175 ms