explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TRj5

Settings
# exclusive inclusive rows x rows loops node
1. 5.913 310.710 ↑ 1.0 1 1

Aggregate (cost=37,552.83..37,552.84 rows=1 width=8) (actual time=310.710..310.710 rows=1 loops=1)

2. 43.216 304.797 ↑ 1.0 87,390 1

Hash Join (cost=12,576.65..37,329.96 rows=89,145 width=0) (actual time=165.035..304.797 rows=87,390 loops=1)

  • Hash Cond: (aml.move_id = am.id)
3. 112.292 148.161 ↑ 1.0 87,390 1

Bitmap Heap Scan on account_move_line aml (cost=2,071.30..25,052.61 rows=89,145 width=4) (actual time=50.883..148.161 rows=87,390 loops=1)

  • Recheck Cond: (partner_id = 2330)
  • Heap Blocks: exact=18010
4. 35.869 35.869 ↑ 1.0 87,648 1

Bitmap Index Scan on account_move_line_partner_id_ref_idx (cost=0.00..2,049.01 rows=89,145 width=0) (actual time=35.869..35.869 rows=87,648 loops=1)

  • Index Cond: (partner_id = 2330)
5. 47.551 113.420 ↑ 1.0 214,973 1

Hash (cost=6,978.18..6,978.18 rows=214,974 width=4) (actual time=113.420..113.420 rows=214,973 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2926kB
6. 65.869 65.869 ↑ 1.0 214,973 1

Seq Scan on account_move am (cost=0.00..6,978.18 rows=214,974 width=4) (actual time=0.059..65.869 rows=214,973 loops=1)

  • Filter: ((state)::text = 'posted'::text)
  • Rows Removed by Filter: 1
Planning time : 1.676 ms
Execution time : 310.825 ms