explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KQa3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..19.43 rows=1 width=1,718) (actual rows= loops=)

  • Output: payments_wallet.id, payments_wallet.method_id, payments_wallet.user_id, payments_wallet.wallet_num, payments_wallet.token, payments_wallet.created_at, payments_wallet.valid_till, payments_wallet.active, payments_wallet.deactivated_at, payments_wallet.deactivation_reason, payments_wallet.product_id, payments_wallet.channel, payments_wallet.amount_period_id, payments_wallet.receipt_data, payments_wallet.is_new_ios_receipt, payments_wallet.params_json
2. 0.000 0.000 ↓ 0.0

Seq Scan on public.payments_paymentmethod (cost=0.00..11.25 rows=1 width=4) (actual rows= loops=)

  • Output: payments_paymentmethod.id, payments_paymentmethod.name, payments_paymentmethod.slug, payments_paymentmethod.url, payments_paymentmethod.payment_system_id, payments_paymentmethod.description, payments_paymentmethod.image, payments_paymentmethod.visible, payments_paymentmethod.rebillable, payments_paymentmethod.platforms
  • Filter: ((payments_paymentmethod.slug)::text = 'mts'::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using payments_wallet_method_id_d8b226f3 on public.payments_wallet (cost=0.14..8.17 rows=1 width=1,718) (actual rows= loops=)

  • Output: payments_wallet.id, payments_wallet.method_id, payments_wallet.user_id, payments_wallet.wallet_num, payments_wallet.token, payments_wallet.created_at, payments_wallet.valid_till, payments_wallet.active, payments_wallet.deactivated_at, payments_wallet.deactivation_reason, payments_wallet.product_id, payments_wallet.channel, payments_wallet.amount_period_id, payments_wallet.receipt_data, payments_wallet.is_new_ios_receipt, payments_wallet.params_json
  • Index Cond: (payments_wallet.method_id = payments_paymentmethod.id)
  • Filter: ((NOT payments_wallet.active) AND (payments_wallet.valid_till >= '2019-10-15 00:00:00'::timestamp without time zone) AND ((payments_wallet.params_json -> 'Msisdn'::text) = '"79161234567"'::jsonb))