explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RpET

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

Limit (cost=59,124,940.85..59,124,940.88 rows=10 width=772) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=59,124,940.85..59,180,705.20 rows=22,305,740 width=772) (actual rows= loops=)

  • Sort Key: payment_outlet.name
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,926,480.19..58,642,921.83 rows=22,305,740 width=772) (actual rows= loops=)

  • Hash Cond: ((sell_order.payment_account_id)::text = (payment_account.payment_account_id)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on sell_order (cost=0.00..16,824,450.56 rows=160,114,656 width=755) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=5,428,191.50..5,428,191.50 rows=22,379,255 width=50) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=142.35..5,428,191.50 rows=22,379,255 width=50) (actual rows= loops=)

  • Hash Cond: ((payment_account.payment_outlet_id)::text = (payment_outlet.payment_outlet_id)::text)
7. 0.000 0.000 ↓ 0.0

Seq Scan on payment_account (cost=0.00..5,005,457.61 rows=160,642,361 width=45) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=138.92..138.92 rows=275 width=40) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using outlet_region_index on payment_outlet (cost=0.28..138.92 rows=275 width=40) (actual rows= loops=)

  • Index Cond: ((region)::text = 'TH'::text)