explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wBT4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 57,989.364 ↓ 0.0 0 1

Unique (cost=4,381.54..4,382.11 rows=115 width=511) (actual time=57,989.364..57,989.364 rows=0 loops=1)

2. 0.028 57,989.364 ↓ 0.0 0 1

Sort (cost=4,381.54..4,381.82 rows=115 width=511) (actual time=57,989.364..57,989.364 rows=0 loops=1)

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

Nested Loop (cost=1.26..4,377.60 rows=115 width=511) (actual time=57,989.336..57,989.336 rows=0 loops=1)

4. 2.740 57,989.335 ↓ 0.0 0 1

Nested Loop (cost=0.99..4,340.74 rows=115 width=302) (actual time=57,989.335..57,989.335 rows=0 loops=1)

5. 179.097 179.097 ↓ 7.9 5,394 1

Index Scan using ix_subscription_partner_organization_ueid on subscription (cost=0.56..779.18 rows=684 width=137) (actual time=0.112..179.097 rows=5,394 loops=1)

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

Index Scan using ix_box_fk_box_user_id on box (cost=0.43..5.20 rows=1 width=165) (actual time=10.717..10.717 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 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 : 1.552 ms
Execution time : 57,989.439 ms