explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HuajH

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

Limit (cost=29,158.53..38,877.62 rows=1,000 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.28..220,245.46 rows=22,661 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..209,388.94 rows=10,141 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using pk_customer on customer customer0_ (cost=0.42..167,564.14 rows=10,141 width=16) (actual rows= loops=)

  • Filter: (enterprise_id = 2)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_business_entity on business_entity businessen1_ (cost=0.42..4.11 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (web_id = customer0_.business_entity_id)
6. 0.000 0.000 ↓ 0.0

Index Scan using ix_business_entity_address__business_entity_id on business_entity_address relatedadd2_ (cost=0.43..0.90 rows=17 width=16) (actual rows= loops=)

  • Index Cond: (businessen1_.web_id = business_entity_id)