Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.

MarcJBrooker's profile picture

Marc Brooker

25,627 subscribers

47,031 görüntüleme • 11 ay önce •via X (Twitter)

Bilim & TeknolojiFinans
LIVE

Anya Rossi• Live Now

Private livecam show

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

🆕 Introducing PrismaGPT, a query helper built on GPT-4 🎉 * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query 👍
0:43

🆕 Introducing PrismaGPT, a query helper built on GPT-4 🎉 * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query 👍

Ryan Chenkie

94,229 görüntüleme • 3 yıl önce

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!
0:44

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!

Tyler Shukert

16,336 görüntüleme • 5 ay önce

Can you guess how much this will cost to the airline?
0:27

Can you guess how much this will cost to the airline?

aircraftmaintenancengineer

53,520 görüntüleme • 2 ay önce

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
5:48

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results

Alex Xu

23,200 görüntüleme • 2 ay önce

How much does it cost to open a DLMM position? Heavymetalcook breaks down the costs involved to create a position — position rent (refundable) and bin array creation rent (non-refundable) — as well as how you can view the full cost details on the position creation UI.
1:33

How much does it cost to open a DLMM position? Heavymetalcook breaks down the costs involved to create a position — position rent (refundable) and bin array creation rent (non-refundable) — as well as how you can view the full cost details on the position creation UI.

Meteora

16,174 görüntüleme • 1 yıl önce

Just made a calculator that will tell you exactly how much money you're leaving on the table with your current sales process It's SHOCKING how many agency owners don't use math to make decisions It also breaks down: - Each step of the sales process so you know which would be the highest leverage to improve - Exactly how many leads, calls, and closes you need in order to hit your target revenue Like + comment "math" and send it to you (Must be following so I can dm you otherwise I can't)
8:19

Just made a calculator that will tell you exactly how much money you're leaving on the table with your current sales process It's SHOCKING how many agency owners don't use math to make decisions It also breaks down: - Each step of the sales process so you know which would be the highest leverage to improve - Exactly how many leads, calls, and closes you need in order to hit your target revenue Like + comment "math" and send it to you (Must be following so I can dm you otherwise I can't)

Clinton

20,177 görüntüleme • 1 yıl önce

Introducing Judgment vSQL: Your coding agent SHOULD query all your agent data in standard SQL, with no made-up DSL or limited look-up tools. > Ask your coding agent "Compare my last few agent versions, did anything regress?" > It writes one SQL query that joins your traces, the steps inside them, and the labels our judges gave them > It runs the query in a sandbox you can inspect > It brings back a ranked list of where your agents are failing
0:24

Introducing Judgment vSQL: Your coding agent SHOULD query all your agent data in standard SQL, with no made-up DSL or limited look-up tools. > Ask your coding agent "Compare my last few agent versions, did anything regress?" > It writes one SQL query that joins your traces, the steps inside them, and the labels our judges gave them > It runs the query in a sandbox you can inspect > It brings back a ranked list of where your agents are failing

Judgment Labs

14,792 görüntüleme • 8 gün önce

Still blows my mind how much of “work” is just circulating information. How much faster would teams move if everyone knew everything everyone else knows? Surprising how close you can get by just having a single agent sit on all your meetings that everyone can query.
0:30

Still blows my mind how much of “work” is just circulating information. How much faster would teams move if everyone knew everything everyone else knows? Surprising how close you can get by just having a single agent sit on all your meetings that everyone can query.

Flo Crivello

38,232 görüntüleme • 2 ay önce

SEO Tip: Ahrefs new "Content Changes" feature will show you the EXACT changes a competitor used to improve organic traffic. Here's how you use it: This is one of the biggest feature adds to any SEO tool that I can remember. Ahrefs new "Content Changes" will automatically detect when substantial changes were made to a page. Then you can see the exactly changes that were made to the content so you can leverage those insights for your own page. Here's how you do it:
2:50

SEO Tip: Ahrefs new "Content Changes" feature will show you the EXACT changes a competitor used to improve organic traffic. Here's how you use it: This is one of the biggest feature adds to any SEO tool that I can remember. Ahrefs new "Content Changes" will automatically detect when substantial changes were made to a page. Then you can see the exactly changes that were made to the content so you can leverage those insights for your own page. Here's how you do it:

Chris Long

21,688 görüntüleme • 2 yıl önce

How peak experiences slowly leave you feeling disappointed… According to Andrew Huberman, these moments come at a cost. Here’s how they affect you and what you can do to fix it:
0:27

How peak experiences slowly leave you feeling disappointed… According to Andrew Huberman, these moments come at a cost. Here’s how they affect you and what you can do to fix it:

Mathew Bowyer

23,706 görüntüleme • 1 yıl önce

Do your Pushups exactly how he says and see how many you can do.
1:15

Do your Pushups exactly how he says and see how many you can do.

Calisthenic Kyle

73,091 görüntüleme • 6 ay önce

Here’s my question for Republicans in Congress: How can you explain to Americans that you voted to double or triple the cost of their health insurance?
1:28

Here’s my question for Republicans in Congress: How can you explain to Americans that you voted to double or triple the cost of their health insurance?

Elizabeth Warren

119,144 görüntüleme • 10 ay önce

Did you know that you can query your bill through *977#. This video explains the steps you can take to check your electricity bill.
0:31

Did you know that you can query your bill through *977#. This video explains the steps you can take to check your electricity bill.

Kenya Power

20,639 görüntüleme • 1 yıl önce

when you dont know how to read a flowchart but have to explain the cost of school meal
2:19

when you dont know how to read a flowchart but have to explain the cost of school meal

Joel Picard

4,108,167 görüntüleme • 1 yıl önce

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 görüntüleme • 1 yıl önce

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL
1:32

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL

rahul

48,216 görüntüleme • 1 yıl önce

How much do you think it can cost to set up this business?
0:38

How much do you think it can cost to set up this business?

Remilekun Ayoola

115,241 görüntüleme • 1 ay önce