explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NIr

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

Sort (cost=34,197.52..34,200.74 rows=1,289 width=50) (actual rows= loops=)

  • Sort Key: plutus_entries.created_at DESC
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,662.27..34,130.93 rows=1,289 width=50) (actual rows= loops=)

  • Hash Cond: (ams.entry_id = plutus_entries.id)
  • Join Filter: ((ams.account_id = 106700) OR (((plutus_entries.commercial_document_type)::text = 'User'::text) AND (plutus_entries.commercial_document_id = 6701)))
3. 0.000 0.000 ↓ 0.0

Seq Scan on plutus_amounts ams (cost=0.00..10,714.53 rows=566,453 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=2,718.90..2,718.90 rows=132,190 width=50) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on plutus_entries (cost=0.00..2,718.90 rows=132,190 width=50) (actual rows= loops=)