explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FGMU

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

Limit (cost=16.04..20.75 rows=1 width=300) (actual time=2.644..2.644 rows=0 loops=1)

2.          

Initplan (for Limit)

3. 1.316 1.316 ↓ 0.0 0 1

Index Only Scan using uk_property_preferences_cid_property_id_key on property_preferences pp (cost=0.42..2.64 rows=1 width=0) (actual time=1.316..1.316 rows=0 loops=1)

  • Index Cond: ((cid = 1826) AND (property_id = 928906) AND (key = 'HIDE_LIVE_CHAT'::text))
  • Heap Fetches: 0
4. 0.529 0.529 ↓ 0.0 0 1

Index Scan using pk_website_preferences on website_preferences wp (cost=0.29..2.51 rows=1 width=0) (actual time=0.528..0.529 rows=0 loops=1)

  • Index Cond: (cid = 1826)
  • Filter: (((key)::text = 'HIDE_LIVE_CHAT'::text) AND (website_id = 25931))
5. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_website_preferences on website_preferences wp_1 (cost=0.29..2.51 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (cid = 1826)
  • Filter: ((value IS NOT NULL) AND ((key)::text = 'WEBSITE_CHAT_HTML'::text) AND (website_id = 25931))
6. 1.854 2.643 ↓ 0.0 0 1

Result (cost=8.38..13.10 rows=1 width=300) (actual time=2.643..2.643 rows=0 loops=1)

  • One-Time Filter: ((NOT $0) AND (NOT $1) AND (NOT $2))
7. 0.000 0.789 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.38..13.10 rows=1 width=300) (actual time=0.789..0.789 rows=0 loops=1)

  • Join Filter: ((cupg.cid = cup.cid) AND (cupg.company_user_id = cup.company_user_id))
  • Filter: ((cu.is_administrator = 1) OR (pga.property_id = 928906))
8. 0.001 0.789 ↓ 0.0 0 1

Nested Loop (cost=0.84..5.52 rows=1 width=308) (actual time=0.789..0.789 rows=0 loops=1)

  • Join Filter: (cu.id = cup.company_user_id)
9. 0.788 0.788 ↓ 0.0 0 1

Index Scan using pk_company_users on company_users cu (cost=0.42..2.63 rows=1 width=300) (actual time=0.788..0.788 rows=0 loops=1)

  • Index Cond: (cid = 1826)
  • Filter: ((default_company_user_id IS NULL) AND (deleted_on IS NULL) AND (is_disabled = 0) AND (company_user_type_id = 2))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_company_user_preferences_cid_company_user_id_key on company_user_preferences cup (cost=0.42..2.88 rows=1 width=8) (never executed)

  • Index Cond: ((cid = 1826) AND ((key)::text = 'IS_AVAILABLE_FOR_CHAT'::text))
  • Filter: (value = '1'::text)
11. 0.000 0.000 ↓ 0.0 0

Unique (cost=7.54..7.55 rows=1 width=12) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Sort (cost=7.54..7.54 rows=1 width=12) (never executed)

  • Sort Key: cupg.company_user_id, pga.property_id
13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..7.53 rows=1 width=12) (never executed)

  • Join Filter: (cupg.property_group_id = pga.property_group_id)
14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..5.01 rows=1 width=16) (never executed)

  • Join Filter: (cupg.property_group_id = pg.id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_property_groups on property_groups pg (cost=0.28..2.50 rows=1 width=8) (never executed)

  • Index Cond: (cid = 1826)
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL))
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uk_cupg_cid_company_user_id_property_group_id on company_user_property_groups cupg (cost=0.29..2.50 rows=1 width=12) (never executed)

  • Index Cond: (cid = 1826)
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_property_group_associations_master on property_group_associations pga (cost=0.28..2.50 rows=1 width=12) (never executed)

  • Index Cond: (cid = 1826)
  • Heap Fetches: 0
Planning time : 91.598 ms
Execution time : 2.758 ms