explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F3Ra

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

Sort (cost=17.68..17.68 rows=1 width=25) (actual rows= loops=)

  • Sort Key: mga_person_statuses.gambling_problems
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..17.67 rows=1 width=25) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..17.37 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.89 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using index_first_last_names_dob on profiles (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (((first_name)::text = 'Vlad'::text) AND ((last_name)::text = 'Ivanov'::text) AND (date_of_birth = '1999-02-24'::date))
  • Filter: ((gender)::text = 'm'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using players_pkey on players (cost=0.42..8.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = profiles.player_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using people_pkey on people (cost=0.42..0.47 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = players.person_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using index_mga_person_statuses_on_person_id on mga_person_statuses (cost=0.28..0.30 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (person_id = people.id)