explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vvt8J

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

Update on refund_rule (cost=12.63..922.32 rows=1,881 width=124) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.63..922.32 rows=1,881 width=124) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.63..624.86 rows=1 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.35..624.56 rows=1 width=22) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.92..624.08 rows=1 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using idx_contract_number on client_contract cc (cost=0.55..2.77 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (number = 'ИМ1209114'::text)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on contracts_sellers cs (cost=11.38..614.28 rows=704 width=14) (actual rows= loops=)

  • Recheck Cond: ((contract_id)::integer = cc.id)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on contracts_sellers_pkey (cost=0.00..11.20 rows=704 width=0) (actual rows= loops=)

  • Index Cond: ((contract_id)::integer = cc.id)
9. 0.000 0.000 ↓ 0.0

Index Scan using seller_pkey on seller s (cost=0.42..0.48 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (id = (cs.seller_id)::integer)
10. 0.000 0.000 ↓ 0.0

Index Scan using refund_rule_pkey on refund_rule rr (cost=0.28..0.30 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (id = (s.refund_rule_id)::integer)
11. 0.000 0.000 ↓ 0.0

Seq Scan on refund_rule (cost=0.00..245.73 rows=5,173 width=68) (actual rows= loops=)