explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o2Vu

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.300 ↑ 880.0 1 1

Nested Loop Left Join (cost=2.03..1,716.57 rows=880 width=68) (actual time=0.275..0.300 rows=1 loops=1)

2. 0.015 0.067 ↑ 880.0 1 1

Nested Loop (cost=0.15..35.77 rows=880 width=36) (actual time=0.049..0.067 rows=1 loops=1)

3. 0.036 0.036 ↑ 1.0 1 1

Index Only Scan using user_account_pk on account a (cost=0.15..8.17 rows=1 width=4) (actual time=0.029..0.036 rows=1 loops=1)

  • Index Cond: (id = 1)
  • Heap Fetches: 1
4. 0.016 0.016 ↑ 880.0 1 1

Seq Scan on currency (cost=0.00..18.80 rows=880 width=32) (actual time=0.012..0.016 rows=1 loops=1)

5. 0.103 0.218 ↑ 1.0 1 1

Aggregate (cost=1.88..1.89 rows=1 width=32) (actual time=0.214..0.218 rows=1 loops=1)

6. 0.115 0.115 ↑ 1.0 27 1

Seq Scan on account_operation ao (cost=0.00..1.81 rows=27 width=5) (actual time=0.016..0.115 rows=27 loops=1)

  • Filter: ((account_id = a.id) AND (currency_id = currency.id))
  • Rows Removed by Filter: 39
Planning time : 0.387 ms
Execution time : 0.462 ms