#	exclusive	inclusive	rows x	rows	loops	node
1.	0.125	0.578	↓ 14.0	14	1	→ 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
2.	0.162	0.438	↓ 14.0	14	1	→ 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
3.	0.013	0.276	↓ 3.5	14	1	→ 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
4.	0.019	0.019	↑ 1.0	1	1	→ 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
5.	0.065	0.244	↑ 1.1	14	1	→ 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 -> Index Scan using sl_jabe027lh9r2mpz_subscription_idx on subscription_lifecycle_jabe027lh9r2mpz subscripti3__1 (cost=0.43..2.48 rows=1 width=36) (actu -> Index Scan using sl_jdyppatx6lmyae7_subscription_idx on subscription_lifecycle_jdyppatx6lmyae7 subscripti3__4 (cost=0.43..2.48 rows=1 width=37) (actu
6.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on subscription_lifecycle subscripti3_ (cost=0.00..0.00 rows=1 width=1,032) (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[])))
7.	0.017	0.017	↑ 1.0	1	1	→ 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
8.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on subscription_lifecycle subscripti3_ (cost=0.00..0.00 rows=1 width=1,032) (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 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 Buffers: shared hit=4
9.	0.016	0.016	↑ 1.0	1	1	→ 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
10.	0.015	0.015	↑ 1.0	1	1	→ 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
11.	0.015	0.015	↑ 1.0	1	1	→ 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) 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 Buffers: shared hit=4 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 Buffers: shared hit=4
12.	0.014	0.014	↑ 1.0	1	1	→ 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
13.	0.014	0.014	↑ 1.0	1	1	→ 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
14.	0.024	0.024	↑ 1.0	1	1	→ 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) 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
15.	0.014	0.014	↑ 1.0	1	1	→ 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
16.	0.015	0.015	↑ 1.0	1	1	→ 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
17.	0.015	0.015	↑ 1.0	1	1	→ 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
18.	0.016	0.016	↑ 1.0	1	1	→ 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
19.	0.000	0.015	↑ 1.0	1	1	→ 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
20.	0.014	0.014	↑ 1.0	1	1	→ 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
21.	0.017	0.017	↑ 1.0	1	1	→ 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
22.	0.140	0.140	↑ 1.0	1	14	→ 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
23.	0.126	0.126	↑ 1.0	1	14	→ 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)

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)

Per node type stats

node type	count	sum of times	% of query
Append	1	0.065 ms	11.2 %
Index Scan	17	0.491 ms	84.9 %
Nested Loop	3	0.300 ms	51.9 %
Seq Scan	2	0.004 ms	0.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
glam_bag	1	0.140 ms	24.2 %
Index Scan	1	0.140 ms	100.0 %
product	1	0.126 ms	21.8 %
Index Scan	1	0.126 ms	100.0 %
subscription	1	0.019 ms	3.3 %
Index Scan	1	0.019 ms	100.0 %
subscription_lifecycle	2	0.004 ms	0.7 %
Seq Scan	2	0.004 ms	100.0 %
subscription_lifecycle_jabe027lh9r2mpz	1	0.017 ms	2.9 %
Index Scan	1	0.017 ms	100.0 %
subscription_lifecycle_jbgbyyzjv2dc181e	1	0.016 ms	2.8 %
Index Scan	1	0.016 ms	100.0 %
subscription_lifecycle_jctgn8zwdaalofm	1	0.015 ms	2.6 %
Index Scan	1	0.015 ms	100.0 %
subscription_lifecycle_jdyppatx6lmyae7	1	0.015 ms	2.6 %
Index Scan	1	0.015 ms	100.0 %
subscription_lifecycle_jf8fb3bcor4e881	1	0.014 ms	2.4 %
Index Scan	1	0.014 ms	100.0 %
subscription_lifecycle_jgmz0lla7bhe1q7n	1	0.014 ms	2.4 %
Index Scan	1	0.014 ms	100.0 %
subscription_lifecycle_jhs9oqphrlssgg4	1	0.024 ms	4.2 %
Index Scan	1	0.024 ms	100.0 %
subscription_lifecycle_jiuheglhc5bn1j34	1	0.014 ms	2.4 %
Index Scan	1	0.014 ms	100.0 %
subscription_lifecycle_jk8ihmfsdhcm1h5	1	0.015 ms	2.6 %
Index Scan	1	0.015 ms	100.0 %
subscription_lifecycle_jl4dxgwm78se1ifc	1	0.015 ms	2.6 %
Index Scan	1	0.015 ms	100.0 %
subscription_lifecycle_jmmdaai0xfs16cx	1	0.016 ms	2.8 %
Index Scan	1	0.016 ms	100.0 %
subscription_lifecycle_jnqdjbf0f7d014qo	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
subscription_lifecycle_jp1pl3ghhsy012lt	1	0.014 ms	2.4 %
Index Scan	1	0.014 ms	100.0 %
subscription_lifecycle_jpym51jdsk46kbc	1	0.017 ms	2.9 %
Index Scan	1	0.017 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1mIn

Color mode:

Visible columns:

Per node type stats

Per table stats