explain.depesz.com

PostgreSQL's explain analyze made readable

Result: exsB

Settings
# exclusive inclusive rows x rows loops node
1. 2,801.707 4,356.323 ↓ 936.2 9,951,531 1

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

2. 2.583 6.538 ↓ 8.0 5,394 1

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

  • Hash Cond: (subscription.subscription_type_id = subscription_type.id)
3. 3.818 3.818 ↓ 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.020..3.818 rows=5,394 loops=1)

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

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

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

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

6. 1,548.078 1,548.078 ↓ 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.287 rows=1,845 loops=5,394)

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