explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0wDe

Settings

Optimization(s) for this plan:

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

Sort (cost=32.12..32.13 rows=1 width=137) (actual rows= loops=)

  • Sort Key: tb.cf_roomid, td.transaction_amount DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.04..32.11 rows=1 width=137) (actual rows= loops=)

  • -> Index Scan using bs_room_pub_matchday_pk on bs_room_pub_matchday tb (cost=0.28..5.46 rows=1 width=50)' Index Cond: ((cf_tourid = '1'::numeric) AND (cf_roomid = ts.cf_roomid) AND (cf_tour_matchdayid = '2359'::numeric))'
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.77..26.19 rows=1 width=140) (actual rows= loops=)

  • Join Filter: ((u.cf_userid = ts.cf_userid) AND (td.cf_user_tour_teamid = ts.cf_user_tour_teamid) AND (td.cf_roomid = ts.cf_roomid))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.49..23.59 rows=1 width=216) (actual rows= loops=)

  • Join Filter: (td.cf_user_tour_teamid = (tc.cf_user_tour_teamid)::numeric)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.22..12.65 rows=1 width=195) (actual rows= loops=)

  • Hash Cond: (u.cf_userid = td.cf_userid)
6. 0.000 0.000 ↓ 0.0

Seq Scan on bs_user u (cost=0.00..1.31 rows=31 width=35) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=11.21..11.21 rows=1 width=160) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=0.00..11.21 rows=1 width=160) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on bs_room_pub_matchday_payout_transaction_md2359 td (cost=0.00..11.20 rows=1 width=160) (actual rows= loops=)

  • Filter: ((cf_tour_matchdayid = '2359'::numeric) AND (cf_tourid = '1'::numeric))
10. 0.000 0.000 ↓ 0.0

Index Scan using bs_user_tour_team_master_tno_ix on bs_user_tour_team_master tc (cost=0.28..10.92 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((cf_userid = u.cf_userid) AND (cf_tour_matchdayid = '2359'::numeric) AND (cf_tourid = '1'::numeric))
11. 0.000 0.000 ↓ 0.0

Index Scan using bs_user_room_pub_pk on bs_user_room_pub ts (cost=0.28..2.59 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((cf_user_tour_teamid = (tc.cf_user_tour_teamid)::numeric) AND (cf_tour_matchdayid = '2359'::numeric) AND (cf_tourid = '1'::numeric))
  • Filter: (tc.cf_userid = cf_userid)