explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sv18

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

Sort (cost=111,820.89..111,820.95 rows=24 width=56) (actual rows= loops=)

  • Sort Key: o.usage_telephony_rating_id
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=83,263.45..111,820.34 rows=24 width=56) (actual rows= loops=)

  • Hash Cond: (o.usage_telephony_rating_id = r.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on usage_telephony_rating_offset o (cost=0.00..23,992.93 rows=1,216,993 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=82,689.48..82,689.48 rows=45,917 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using usage_telephony_rating_idx1 on usage_telephony_rating r (cost=0.70..82,689.48 rows=45,917 width=8) (actual rows= loops=)

  • Index Cond: (service_subscription_period_id = 8139804)