explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WlEp

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

Sort (cost=122,509.83..122,751.60 rows=96,707 width=48) (actual rows= loops=)

  • Sort Key: usage_telephony_rating_offset.id
2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=83,263.45..111,526.85 rows=96,707 width=48) (actual rows= loops=)

  • Hash Cond: (usage_telephony_rating_offset.usage_telephony_rating_id = usage_telephony_rating.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on usage_telephony_rating_offset (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 (cost=0.70..82,689.48 rows=45,917 width=8) (actual rows= loops=)

  • Index Cond: (service_subscription_period_id = 8139804)