explain.depesz.com

PostgreSQL's explain analyze made readable

Result: msCK

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

HashAggregate (cost=80.99..83.99 rows=200 width=76) (actual rows= loops=)

  • Group Key: "*SELECT* 1".account_id, "*SELECT* 1".asset_id, date_trunc('day'::text, "*SELECT* 1".date)
2. 0.000 0.000 ↓ 0.0

Result (cost=9.72..73.51 rows=748 width=48) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=9.72..64.16 rows=748 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=9.72..30.21 rows=374 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=9.72..26.47 rows=374 width=1,104) (actual rows= loops=)

  • Hash Cond: (e.asset_id = a.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on entries e (cost=0.00..15.74 rows=374 width=40) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=7.10..7.10 rows=210 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on assets a (cost=0.00..7.10 rows=210 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=9.72..30.21 rows=374 width=48) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=9.72..26.47 rows=374 width=1,104) (actual rows= loops=)

  • Hash Cond: (e_1.asset_id = a_1.id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on entries e_1 (cost=0.00..15.74 rows=374 width=48) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=7.10..7.10 rows=210 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on assets a_1 (cost=0.00..7.10 rows=210 width=16) (actual rows= loops=)