explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xjje

Settings
# exclusive inclusive rows x rows loops node
1. 5.153 1,657.324 ↑ 351.7 1,982 1

GroupAggregate (cost=453,234.83..454,977.53 rows=697,081 width=48) (actual time=1,650.108..1,657.324 rows=1,982 loops=1)

  • Group Key: ((tb_asset_operation.id_asset)::character varying), tb_asset_fund.id_portfolio
2. 19.289 1,652.171 ↑ 14.6 47,895 1

Sort (cost=453,234.83..453,409.10 rows=697,081 width=40) (actual time=1,650.099..1,652.171 rows=47,895 loops=1)

  • Sort Key: ((tb_asset_operation.id_asset)::character varying), tb_asset_fund.id_portfolio
  • Sort Method: quicksort Memory: 3782kB
3. 148.734 1,632.882 ↑ 14.6 47,895 1

Merge Join (cost=399,358.90..446,469.32 rows=697,081 width=40) (actual time=554.427..1,632.882 rows=47,895 loops=1)

  • Merge Cond: (tb_asset_fund.id_fund = tb_asset_operation.id_fund)
4. 928.127 928.127 ↓ 1.0 1,154,739 1

Index Scan using tb_asset_fund_pk on tb_asset_fund (cost=0.04..45,428.51 rows=1,152,978 width=12) (actual time=0.005..928.127 rows=1,154,739 loops=1)

5. 14.566 556.021 ↑ 14.6 47,895 1

Sort (cost=399,358.85..399,533.12 rows=697,081 width=8) (actual time=550.375..556.021 rows=47,895 loops=1)

  • Sort Key: tb_asset_operation.id_fund
  • Sort Method: quicksort Memory: 3782kB
6. 541.455 541.455 ↑ 14.6 47,895 1

Index Scan using tb_asset_operation_cd_operation_state_cd_status_reprocess_idx on tb_asset_operation (cost=0.06..392,593.34 rows=697,081 width=8) (actual time=0.039..541.455 rows=47,895 loops=1)

  • Index Cond: ((cd_operation_state = 'A'::bpchar) AND ((cd_status_reprocess)::text = 'PEND'::text))
  • Filter: (id_asset = 97)
  • Rows Removed by Filter: 1209721
Planning time : 0.435 ms
Execution time : 1,657.467 ms