explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h9hJ : Optimization for: Optimization for: plan #11S0; plan #lXKf

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 7,419.846 ↓ 0.0 0 1

Unique (cost=3,760.51..3,761.04 rows=106 width=37) (actual time=7,419.846..7,419.846 rows=0 loops=1)

2. 0.004 7,419.846 ↓ 0.0 0 1

Sort (cost=3,760.51..3,760.77 rows=106 width=37) (actual time=7,419.846..7,419.846 rows=0 loops=1)

  • Sort Key: subscription.unique_exchange_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 7,419.842 ↓ 0.0 0 1

Nested Loop (cost=1.26..3,756.94 rows=106 width=37) (actual time=7,419.842..7,419.842 rows=0 loops=1)

4. 0.000 7,419.841 ↓ 0.0 0 1

Nested Loop (cost=0.99..3,725.51 rows=106 width=41) (actual time=7,419.841..7,419.841 rows=0 loops=1)

5. 3.805 3.805 ↓ 8.0 5,394 1

Index Scan using ix_subscription_partner_organization_ueid on subscription (cost=0.56..770.30 rows=677 width=45) (actual time=0.017..3.805 rows=5,394 loops=1)

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

Index Scan using ix_box_fk_box_user_id on box (cost=0.43..4.36 rows=1 width=4) (actual time=1.375..1.375 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
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using subscription_type_pkey on subscription_type (cost=0.27..0.30 rows=1 width=4) (never executed)

  • Index Cond: (id = subscription.subscription_type_id)
  • Heap Fetches: 0
Planning time : 0.401 ms
Execution time : 7,419.878 ms