explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wqhi

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4.986 ↓ 0.0 0 1

Nested Loop (cost=33.56..10,441.08 rows=73 width=509) (actual time=4.986..4.986 rows=0 loops=1)

2. 0.823 4.985 ↓ 0.0 0 1

Nested Loop (cost=33.29..10,408.33 rows=73 width=301) (actual time=4.985..4.985 rows=0 loops=1)

3. 1.731 2.025 ↓ 3.9 2,137 1

Bitmap Heap Scan on subscription (cost=32.86..2,138.58 rows=555 width=137) (actual time=0.371..2.025 rows=2,137 loops=1)

  • Recheck Cond: ((partner_organization_ueid)::text = 'c2f7765c-a04c-4ace-9006-d13005b3a2c2'::text)
  • Heap Blocks: exact=547
4. 0.294 0.294 ↓ 3.9 2,137 1

Bitmap Index Scan on ix_subscription_partner_organization_ueid (cost=0.00..32.72 rows=555 width=0) (actual time=0.294..0.294 rows=2,137 loops=1)

  • Index Cond: ((partner_organization_ueid)::text = 'c2f7765c-a04c-4ace-9006-d13005b3a2c2'::text)
5. 2.137 2.137 ↓ 0.0 0 2,137

Index Scan using ix_box_fk_box_user_id on box (cost=0.43..14.89 rows=1 width=164) (actual time=0.001..0.001 rows=0 loops=2,137)

  • 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: 0
6. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = subscription.subscription_type_id)
Planning time : 0.650 ms
Execution time : 5.061 ms