explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AVOU

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

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

2. 2.970 12.493 ↓ 8.0 5,394 1

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

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

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

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

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

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

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

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