explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VbC

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 7,382.201 ↓ 0.0 0 1

Nested Loop (cost=1.26..3,739.72 rows=106 width=511) (actual time=7,382.200..7,382.201 rows=0 loops=1)

2. 0.000 7,382.200 ↓ 0.0 0 1

Nested Loop (cost=0.99..3,705.71 rows=106 width=302) (actual time=7,382.200..7,382.200 rows=0 loops=1)

3. 3.858 3.858 ↓ 8.0 5,394 1

Index Scan using ix_subscription_partner_organization_ueid on subscription (cost=0.56..761.50 rows=677 width=137) (actual time=0.023..3.858 rows=5,394 loops=1)

  • Index Cond: ((partner_organization_ueid)::text = 'c2f7765c-a04c-4ace-9006-d13005b3a2c2'::text)
4. 7,378.992 7,378.992 ↓ 0.0 0 5,394

Index Scan using ix_box_fk_box_user_id on box (cost=0.43..4.34 rows=1 width=165) (actual time=1.368..1.368 rows=0 loops=5,394)

  • Index Cond: (user_id = subscription.user_id)
  • Filter: ((lower((original_reg_number)::text) ~~ 'kk%'::text) OR (lower((original_reg_number)::text) ~~ 'кк%'::text))
  • Rows Removed by Filter: 1845
5. 0.000 0.000 ↓ 0.0 0

Index Scan using subscription_type_pkey on subscription_type (cost=0.27..0.32 rows=1 width=209) (never executed)

  • Index Cond: (id = subscription.subscription_type_id)
Planning time : 0.433 ms
Execution time : 7,382.254 ms