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
-> Seq Scan on public.orders_ad (cost=0.00..249.66 rows=2384 width=143) (actual time=0.009..1.826 rows=2384 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
-> 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