explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RA2o

Settings
# exclusive inclusive rows x rows loops node
1. 1.355 659.382 ↓ 1.1 1,431 1

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

  • Sort Key: plutus_entries.created_at DESC
  • Sort Method: quicksort Memory: 250kB
2. 464.792 658.027 ↓ 1.1 1,431 1

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

  • 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)))
  • Rows Removed by Join Filter: 565007
3. 122.745 122.745 ↑ 1.0 566,453 1

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

4. 49.967 70.490 ↑ 1.0 132,190 1

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

  • Buckets: 65536 Batches: 4 Memory Usage: 3310kB
5. 20.523 20.523 ↑ 1.0 132,190 1

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