explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8MeM

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

Aggregate (cost=8.23..8.24 rows=1 width=32) (actual rows= loops=)

2.          

CTE amounts

3. 0.000 0.000 ↓ 0.0

Index Scan using hold_user_id_idx on hold (cost=0.14..8.17 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (user_id = '9104b1ca-ead6-4bbe-b5b5-843fb0667df3'::uuid)
  • Filter: (((money_type)::text = 'crypto'::text) AND ((operation_type)::text = ANY ('{withdraw,transfer,unhold_error}'::text[])) AND (created_at > date_trunc('day'
4. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.00..0.05 rows=1 width=30) (actual rows= loops=)

  • Join Filter: (amounts.ref_id = amounts_1.id)
5. 0.000 0.000 ↓ 0.0

CTE Scan on amounts (cost=0.00..0.02 rows=1 width=38) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

CTE Scan on amounts amounts_1 (cost=0.00..0.02 rows=1 width=8) (actual rows= loops=)