explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1mIn

Settings
# 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)