explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x6Up

Settings
# exclusive inclusive rows x rows loops node
1. 41.263 1,489.543 ↑ 96.7 7 1

GroupAggregate (cost=1.26..741,257.89 rows=677 width=37) (actual time=122.639..1,489.543 rows=7 loops=1)

  • Group Key: t.account_id
2. 47.196 1,448.280 ↓ 2.7 276,010 1

Nested Loop (cost=1.26..740,729.84 rows=103,917 width=11) (actual time=0.053..1,448.280 rows=276,010 loops=1)

3. 0.157 0.157 ↑ 1.3 11 1

Index Scan using accounts_pk on accounts a (cost=0.56..438.69 rows=14 width=14) (actual time=0.030..0.157 rows=11 loops=1)

  • Index Cond: (company_id = '1351589930'::numeric)
  • Filter: (account_type_id = '10'::numeric)
  • Rows Removed by Filter: 75
4. 1,400.927 1,400.927 ↓ 13.8 25,092 11

Index Scan using txdetails_account_date on transactiondetails t (cost=0.70..52,859.78 rows=1,816 width=20) (actual time=46.804..127.357 rows=25,092 loops=11)

  • Index Cond: ((company_id = '1351589930'::numeric) AND (account_id = a.account_id) AND (account_id IS NOT NULL))
Planning time : 0.306 ms
Execution time : 1,489.583 ms