explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dgPb

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 6.503 ↓ 12.0 24 1

Sort (cost=536.33..536.33 rows=2 width=696) (actual time=6.499..6.503 rows=24 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Sort Key: finance_paymentdestination.name
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=2020
2. 0.036 6.455 ↓ 12.0 24 1

Hash Join (cost=534.21..536.32 rows=2 width=696) (actual time=6.427..6.455 rows=24 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Hash Cond: (u2."paymentDestination_id" = finance_paymentdestination.id)
  • Buffers: shared hit=2020
3. 0.187 6.008 ↑ 1.8 50 1

HashAggregate (cost=517.48..518.36 rows=88 width=4) (actual time=5.996..6.008 rows=50 loops=1)

  • Output: u2."paymentDestination_id
  • Buffers: shared hit=2014
4. 0.468 5.821 ↓ 4.2 585 1

Nested Loop (cost=175.37..517.13 rows=140 width=4) (actual time=1.710..5.821 rows=585 loops=1)

  • Output: u2."paymentDestination_id
  • Buffers: shared hit=2014
5. 0.917 4.183 ↓ 4.2 585 1

Hash Join (cost=175.09..435.09 rows=140 width=4) (actual time=1.700..4.183 rows=585 loops=1)

  • Output: u0."bankAccount_id
  • Hash Cond: (u0."balanceSheet_id" = u1.id)
  • Buffers: shared hit=251
6. 1.581 1.581 ↑ 1.0 2,384 1

Seq Scan on public.orders_ad u0 (cost=0.00..249.66 rows=2,384 width=8) (actual time=0.002..1.581 rows=2,384 loops=1)

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

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

  • Output: u1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=63
8. 1.552 1.552 ↓ 1.0 498 1

Seq Scan on public.sell_balancesheet u1 (cost=0.00..168.88 rows=497 width=4) (actual time=0.015..1.552 rows=498 loops=1)

  • Output: u1.id
  • Filter: (u1."currentBalance" > 0::numeric)
  • Rows Removed by Filter: 7973
  • Buffers: shared hit=63
9. 1.170 1.170 ↑ 1.0 1 585

Index Scan using orders_bankaccount_pkey on public.orders_bankaccount u2 (cost=0.28..0.58 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=585)

  • Output: u2.id, u2."paymentDestination_id", u2.owner_id, u2.active, u2.name, u2.number, u2.country, u2.fiat_id, u2."accountHash
  • Index Cond: (u2.id = u0."bankAccount_id")
  • Buffers: shared hit=1763
10. 0.023 0.411 ↓ 10.3 31 1

Hash (cost=16.70..16.70 rows=3 width=696) (actual time=0.411..0.411 rows=31 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
  • Buffers: shared hit=6
11. 0.065 0.388 ↓ 10.3 31 1

Hash Left Join (cost=9.08..16.70 rows=3 width=696) (actual time=0.202..0.388 rows=31 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Hash Cond: (finance_paymentdestination_countries.country_id = wallofcoins_country.id)
  • Filter: (((wallofcoins_country."isoName")::text = 'us'::text) OR (finance_paymentdestination_countries.country_id IS NULL))
  • Rows Removed by Filter: 136
  • Buffers: shared hit=6
12. 0.120 0.291 ↓ 1.0 167 1

Hash Right Join (cost=6.69..11.62 rows=165 width=700) (actual time=0.157..0.291 rows=167 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate", finance_paymentdestination_countries.country_id
  • Hash Cond: (finance_paymentdestination_countries.paymentdestination_id = finance_paymentdestination.id)
  • Buffers: shared hit=5
13. 0.031 0.031 ↑ 1.0 166 1

Seq Scan on public.finance_paymentdestination_countries (cost=0.00..2.66 rows=166 width=8) (actual time=0.003..0.031 rows=166 loops=1)

  • Output: finance_paymentdestination_countries.id, finance_paymentdestination_countries.paymentdestination_id, finance_paymentdestination_countries.country_id
  • Buffers: shared hit=1
14. 0.088 0.140 ↓ 1.0 120 1

Hash (cost=5.20..5.20 rows=119 width=696) (actual time=0.140..0.140 rows=120 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=4
15. 0.052 0.052 ↓ 1.0 120 1

Seq Scan on public.finance_paymentdestination (cost=0.00..5.20 rows=119 width=696) (actual time=0.006..0.052 rows=120 loops=1)

  • Output: finance_paymentdestination.id, finance_paymentdestination.name, finance_paymentdestination."englishName", finance_paymentdestination.country, finance_paymentdestination.state, finance_paymentdestination."verificationClass_id", finance_paymentdestination."highRisk", finance_paymentdestination.url, finance_paymentdestination."locationsUrl", finance_paymentdestination."locationsInstalled", finance_paymentdestination.logo, finance_paymentdestination.icon, finance_paymentdestination.identifier, finance_paymentdestination.trigger, finance_paymentdestination."userSuppliedLocations", finance_paymentdestination."buyInstructionsTemplate
  • Filter: (NOT finance_paymentdestination."userSuppliedLocations")
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
16. 0.018 0.032 ↑ 1.0 62 1

Hash (cost=1.62..1.62 rows=62 width=7) (actual time=0.032..0.032 rows=62 loops=1)

  • Output: wallofcoins_country.id, wallofcoins_country."isoName
  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
  • Buffers: shared hit=1
17. 0.014 0.014 ↑ 1.0 62 1

Seq Scan on public.wallofcoins_country (cost=0.00..1.62 rows=62 width=7) (actual time=0.002..0.014 rows=62 loops=1)

  • Output: wallofcoins_country.id, wallofcoins_country."isoName
  • Buffers: shared hit=1
Total runtime : 6.622 ms