explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t6Mr : aadas

Settings

Optimization(s) for this plan:

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

Subquery Scan on v_dash_deposit (cost=6.99..7.02 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=6.99..7.01 rows=1 width=163) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=6.99..7.00 rows=1 width=163) (actual rows= loops=)

  • Sort Key: ((COALESCE((SubPlan 1), '0'::numeric) - COALESCE((SubPlan 2), '0'::numeric))), ((SubPlan 3)), ((SubPlan 4)), ((SubPlan 5))
4. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction a (cost=0.00..6.98 rows=1 width=163) (actual rows= loops=)

  • Filter: (account_id = '\x314d526a766775674653316a654a47715544353341474b695379344e35475a557931'::bytea)
5.          

SubPlan (for Seq Scan)

6. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction b (cost=0.00..1.16 rows=2 width=8) (actual rows= loops=)

  • Filter: ((trx_type = 1) AND (status = 1) AND (account_id = a.account_id))
8. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction c (cost=0.00..1.16 rows=1 width=8) (actual rows= loops=)

  • Filter: ((trx_type <> 1) AND (status = 1) AND (account_id = a.account_id))
10. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction d (cost=0.00..1.16 rows=1 width=8) (actual rows= loops=)

  • Filter: ((trx_type = 2) AND (status = 1) AND (account_id = a.account_id))
12. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction g (cost=0.00..1.16 rows=2 width=8) (actual rows= loops=)

  • Filter: ((trx_type = 1) AND (status = 1) AND (account_id = a.account_id))
14. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on d_deposit_transaction f (cost=0.00..1.16 rows=1 width=8) (actual rows= loops=)

  • Filter: ((trx_type = 0) AND (status = 1) AND (account_id = a.account_id))