explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKa : test

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

Sort (cost=33.63..33.64 rows=1 width=364) (actual rows= loops=)

  • Sort Key: icctx.id DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13.66..33.62 rows=1 width=364) (actual rows= loops=)

  • Filter: (icctxd.id IS NULL)
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=13.51..25.45 rows=1 width=364) (actual rows= loops=)

  • Hash Cond: (icctxr.issued_credit_card_transaction_id = icctx.id)
  • Filter: (icctxr.id IS NULL)
4. 0.000 0.000 ↓ 0.0

Seq Scan on issued_credit_card_transaction_receiveds icctxr (cost=0.00..11.40 rows=140 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=13.50..13.50 rows=1 width=364) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on issued_credit_card_transactions icctx (cost=0.00..13.50 rows=1 width=364) (actual rows= loops=)

  • Filter: ((created_at >= '2020-10-10 00:00:00+09'::timestamp with time zone) AND (created_at < '2020-10-10 00:00:00+09'::timestamp with time zone) AND (billing_amount <= 100))
7. 0.000 0.000 ↓ 0.0

Index Scan using issued_credit_card_transactio_issued_credit_card_transactio_key on issued_credit_card_transaction_deleteds icctxd (cost=0.15..8.17 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (issued_credit_card_transaction_id = icctx.id)