explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eOrO

Settings
# exclusive inclusive rows x rows loops node
1. 0.956 4.643 ↓ 4.2 585 1

Hash Join (cost=175.09..435.09 rows=140 width=143) (actual time=1.903..4.643 rows=585 loops=1)

  • Output: orders_ad.id, orders_ad."bankAccount_id", orders_ad.balance, orders_ad."buyCurrency_id", orders_ad."sellCrypto_id", orders_ad."currentPrice", orders_ad."systemDiscount", orders_ad."dynamicPrice", orders_ad.dynamic_id, orders_ad.virtual, orders_ad."createdIp", orders_ad."instructionViews", orders_ad.email, orders_ad.phone, orders_ad.verified, orders_ad.auth_id, orders_ad.device_id, orders_ad.published, orders_ad."createdOn", orders_ad."firstFundedOn", orders_ad."onHold", orders_ad."publicBalance", orders_ad."userEnabled", orders_ad."minPayment", orders_ad."maxPayment", orders_ad."affiliateHash", orders_ad."reservedHold", orders_ad."allowWocGateway", orders_ad.label, orders_ad."useSharedFunding", orders_ad."balanceSheet_id", orders_ad."ignoreAudit
  • Hash Cond: (orders_ad."balanceSheet_id" = sell_balancesheet.id)
  • Buffers: shared hit=254
2. 1.826 1.826 ↑ 1.0 2,384 1

Seq Scan on public.orders_ad (cost=0.00..249.66 rows=2,384 width=143) (actual time=0.009..1.826 rows=2,384 loops=1)

  • Output: orders_ad.id, orders_ad.balance, orders_ad."buyCurrency_id", orders_ad."dynamicPrice", orders_ad."currentPrice", orders_ad.email, orders_ad.phone, orders_ad."onHold", orders_ad."publicBalance", orders_ad."sellCrypto_id", orders_ad."bankAccount_id", orders_ad.dynamic_id, orders_ad."createdIp", orders_ad.auth_id, orders_ad.published, orders_ad.verified, orders_ad."createdOn", orders_ad."instructionViews", orders_ad.device_id, orders_ad.virtual, orders_ad."firstFundedOn", orders_ad."maxPayment", orders_ad."minPayment", orders_ad."userEnabled", orders_ad."systemDiscount", orders_ad."affiliateHash", orders_ad."reservedHold", orders_ad."allowWocGateway", orders_ad.label, orders_ad."balanceSheet_id", orders_ad."useSharedFunding", orders_ad."ignoreAudit
  • Filter: orders_ad.published
  • Rows Removed by Filter: 3782
  • Buffers: shared hit=188
3. 1.861 1.861 ↓ 1.0 498 1

Hash (cost=168.88..168.88 rows=497 width=4) (actual time=1.861..1.861 rows=498 loops=1)

  • Output: sell_balancesheet.id
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB