explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11S0

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2,791.050 4,405.091 ↓ 936.2 9,951,531 1

Nested Loop (cost=26.41..3,745.95 rows=10,630 width=511) (actual time=0.312..4,405.091 rows=9,951,531 loops=1)

2. 2.642 6.629 ↓ 8.0 5,394 1

Hash Join (cost=25.98..797.51 rows=677 width=346) (actual time=0.297..6.629 rows=5,394 loops=1)

  • Hash Cond: (subscription.subscription_type_id = subscription_type.id)
3. 3.750 3.750 ↓ 8.0 5,394 1

Index Scan using ix_subscription_partner_organization_ueid on subscription (cost=0.56..770.30 rows=677 width=137) (actual time=0.019..3.750 rows=5,394 loops=1)

  • Index Cond: ((partner_organization_ueid)::text = 'c2f7765c-a04c-4ace-9006-d13005b3a2c2'::text)
4. 0.184 0.237 ↑ 1.0 463 1

Hash (cost=19.63..19.63 rows=463 width=209) (actual time=0.237..0.237 rows=463 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 119kB
5. 0.053 0.053 ↑ 1.0 463 1

Seq Scan on subscription_type (cost=0.00..19.63 rows=463 width=209) (actual time=0.004..0.053 rows=463 loops=1)

6. 1,607.412 1,607.412 ↓ 615.0 1,845 5,394

Index Scan using ix_box_fk_box_user_id on box (cost=0.43..4.33 rows=3 width=165) (actual time=0.003..0.298 rows=1,845 loops=5,394)

  • Index Cond: (user_id = subscription.user_id)
Planning time : 0.401 ms
Execution time : 4,730.674 ms