explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1487

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

Unique (cost=4,408,146.06..4,520,113.99 rows=5,593,131 width=54) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=4,408,146.06..4,464,130.02 rows=22,393,587 width=54) (actual rows= loops=)

  • Sort Key: asset_pool_transfers_default.asset_number, asset_pool_transfers_default.system_date DESC, asset_pool_transfers_default.encumbrance_pool_id, asset_pool_transfers_default.encumbrance_external_pool_id, asset_pool_transfers_default.activity
3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..908,863.76 rows=22,393,587 width=54) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on asset_pool_transfers_default (cost=0.00..796,895.82 rows=22,393,587 width=54) (actual rows= loops=)

  • Filter: ((activity <> 'Add'::text) AND (snapshot_date <= '2019-11-26'::date))