Nested Loop (cost=1.39..40.14 rows=1 width=94) (actual time=0.065..0.578 rows=14 loops=1)
Buffers: shared hit=175 read=1
I/O Timings: read=0.006
-> Nested Loop (cost=0.97..39.36 rows=1 width=94) (actual time=0.054..0.438 rows=14 loops=1)
Buffers: shared hit=119 read=1
I/O Timings: read=0.006
-> Nested Loop (cost=0.56..37.52 rows=4 width=18) (actual time=0.042..0.276 rows=14 loops=1)
Buffers: shared hit=61 read=1
I/O Timings: read=0.006
-> Index Scan using subscription_user_idx on subscription subscripti2_ (cost=0.56..2.58 rows=1 width=18) (actual time=0.019..0.019 rows=1 loops=1)
Index Cond: ((user_id)::text = 'u-j5eax9g0tyci1tmh'::text)
Filter: (date_deleted IS NULL)
Buffers: shared hit=5
-> Append (cost=0.00..34.79 rows=15 width=36) (actual time=0.021..0.244 rows=14 loops=1)
Buffers: shared hit=56 read=1
I/O Timings: read=0.006
-> Seq Scan on subscription_lifecycle subscripti3_ (cost=0.00..0.00 rows=1 width=1032) (actual time=0.002..0.002 rows=0 loops=1)
Filter: ((date_deleted IS NULL) AND ((subscripti2_.id)::text = (subscription_id)::text) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
-> Index Scan using sl_jabe027lh9r2mpz_subscription_idx on subscription_lifecycle_jabe027lh9r2mpz subscripti3__1 (cost=0.43..2.48 rows=1 width=36) (actual time=0.017..0.017 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe02wm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe02
-> Seq Scan on subscription_lifecycle subscripti3_ (cost=0.00..0.00 rows=1 width=1032) (actual time=0.002..0.002 rows=0 loops=1)
Filter: ((date_deleted IS NULL) AND ((subscripti2_.id)::text = (subscription_id)::text) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDE
R_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghh
sy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx
6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
-> Index Scan using sl_jabe027lh9r2mpz_subscription_idx on subscription_lifecycle_jabe027lh9r2mpz subscripti3__1 (cost=0.43..2.48 rows=1 width=36) (actu
al time=0.017..0.017 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN
_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxg
wm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe02
7lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jbgbyyzjv2dc181e_subscription_idx on subscription_lifecycle_jbgbyyzjv2dc181e subscripti3__2 (cost=0.43..2.48 rows=1 width=36) (actual time=0.015..0.016 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jctgn8zwdaalofm_subscription_idx on subscription_lifecycle_jctgn8zwdaalofm subscripti3__3 (cost=0.43..2.48 rows=1 width=37) (actual time=0.015..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jdyppatx6lmyae7_subscription_idx on subscription_lifecycle_jdyppatx6lmyae7 subscripti3__4 (cost=0.43..2.48 rows=1 width=37) (actual time=0.015..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxg_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxg
wm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe02
7lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jdyppatx6lmyae7_subscription_idx on subscription_lifecycle_jdyppatx6lmyae7 subscripti3__4 (cost=0.43..2.48 rows=1 width=37) (actu
al time=0.015..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN
_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxg
wm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jf8fb3bcor4e881_subscription_idx on subscription_lifecycle_jf8fb3bcor4e881 subscripti3__5 (cost=0.43..2.48 rows=1 width=36) (actual time=0.014..0.014 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jgmz0lla7bhe1q7n_subscription_idx on subscription_lifecycle_jgmz0lla7bhe1q7n subscripti3__6 (cost=0.43..2.48 rows=1 width=36) (actual time=0.014..0.014 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jhs9oqphrlssgg4_subscription_idx on subscription_lifecycle_jhs9oqphrlssgg4 subscripti3__7 (cost=0.43..2.48 rows=1 width=37) (actual time=0.024..0.024 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=3 read=1
I/O Timings: read=0.006
-> Index Scan using sl_jiuheglhc5bn1j34_subscription_idx on subscription_lifecycle_jiuheglhc5bn1j34 subscripti3__8 (cost=0.43..2.48 rows=1 width=37) (actual time=0.014..0.014 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jk8ihmfsdhcm1h5_subscription_idx on subscription_lifecycle_jk8ihmfsdhcm1h5 subscripti3__9 (cost=0.43..2.48 rows=1 width=36) (actual time=0.015..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jl4dxgwm78se1ifc_subscription_idx on subscription_lifecycle_jl4dxgwm78se1ifc subscripti3__10 (cost=0.43..2.48 rows=1 width=36) (actual time=0.014..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jmmdaai0xfs16cx_subscription_idx on subscription_lifecycle_jmmdaai0xfs16cx subscripti3__11 (cost=0.43..2.48 rows=1 width=36) (actual time=0.016..0.016 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jnqdjbf0f7d014qo_subscription_idx on subscription_lifecycle_jnqdjbf0f7d014qo subscripti3__12 (cost=0.43..2.48 rows=1 width=37) (actual time=0.015..0.015 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jp1pl3ghhsy012lt_subscription_idx on subscription_lifecycle_jp1pl3ghhsy012lt subscripti3__13 (cost=0.43..2.48 rows=1 width=36) (actual time=0.013..0.014 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=4
-> Index Scan using sl_jpym51jdsk46kbc_subscription_idx on subscription_lifecycle_jpym51jdsk46kbc subscripti3__14 (cost=0.56..2.60 rows=1 width=35) (actual time=0.017..0.017 rows=1 loops=1)
Index Cond: ((subscription_id)::text = (subscripti2_.id)::text)
Filter: ((date_deleted IS NULL) AND ((state)::text = ANY ('{ERROR_KITTING_ORDER,KITTING_ORDER_CREATED,READY_TO_ASSIGN,ERROR_SHIPPING,BAG_ASSIGNED,IN_WAREHOUSE,PAYMENT_SUCCESS,SHIPPED,DELIVERED}'::text[])) AND ((cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=5
-> Index Scan using glam_bag_pkey on glam_bag glambag0_ (cost=0.41..0.45 rows=1 width=94) (actual time=0.010..0.010 rows=1 loops=14)
Index Cond: (((id)::text = (subscripti3_.glam_bag_id)::text) AND (id IS NOT NULL))
Filter: ((date_deleted IS NULL) AND ((subscription_cycle_id)::text = ANY ('{sc-jpym51jdsk46kbc,sc-jp1pl3ghhsy012lt,sc-jnqdjbf0f7d014qo,sc-jmmdaai0xfs16cx,sc-jl4dxgwm78se1ifc,sc-jk8ihmfsdhcm1h5,sc-jiuheglhc5bn1j34,sc-jhs9oqphrlssgg4,sc-jgmz0lla7bhe1q7n,sc-jf8fb3bcor4e881,sc-jdyppatx6lmyae7,sc-jctgn8zwdaalofm,sc-jbgbyyzjv2dc181e,sc-jabe027lh9r2mpz}'::text[])))
Buffers: shared hit=58
-> Index Scan using product_pkey on product product1_ (cost=0.41..0.77 rows=1 width=17) (actual time=0.008..0.009 rows=1 loops=14)
Index Cond: ((id)::text = (glambag0_.bag_product_id)::text)
Filter: (date_deleted IS NULL)