Events Add an event Speakers Talks Collections
 
Duration 06:40
16+
Play
Video

PGConf India 2020 - Lightning Talk - Auto Explain - Ashutosh Bapat - 2ndQuadrant

Ashutosh Bapat
Senior PostgreSQL Architect at EDB
  • Video
  • Table of contents
  • Video
PGConf India, 2020
February 26, 2020, Bengaluru, India
PGConf India, 2020
Request Q&A
PGConf India, 2020
From the conference
PGConf India, 2020
Request Q&A
Video
PGConf India 2020 - Lightning Talk - Auto Explain - Ashutosh Bapat - 2ndQuadrant
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Add to favorites
27
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
  • Description
  • Transcript
  • Discussion

About speaker

Ashutosh Bapat
Senior PostgreSQL Architect at EDB

Long experience in the field of core database server development in the areas like storage, buffer manager, query processing and optimization. Special exposure to distributed database servers. Ability to adapt to the work cultures from world class large organizations like Sybase to start-ups like EnterpriseDB. Good experience in customer interaction at various levels, representing organization at conferences, technical talks and marketing events.

View the profile

About the talk

Share

So yeah. Hi, this is Tasha. Tasha from second quadrant. So the idea of lightning taxes that you have fun but also share small, bits of information. So how many of you know what are Tieks playlist? Okay, so maybe that's a good thing to start. 70 Petit Louis Vuitton explain is probably that if you explain a credit shows you what land is being used for the credit. For example here you will see it's a some joint the where clause and it will show you that the joint when executed will use the hydrant method and the sequential

scan on the table. One of the tables will rehash, a hash table will be created. These plants have a lot of information in them, which is useful for divulging, queries running very slow. Then you can look at these plants and find out. The portions of the plants which are actually running slow. You can explain with Annalise and have more information by accident. According to the query, capturing timings at each of these notes and son. But this is, if you are

developing crazy, is what if you have many queries are Aquarius, which are not directly on the servant and one of the greatest starts taking a lot of time. Start jogging resources takes locks and son then it becomes very difficult to what exactly is going wrong. So many tools and one of the tools that is useful is not explain What does stool is available at Country Mart in equal. So don't have to do anything like install anything. It just travel there

once in the world. This will automatically log explain plans for doing the law. So, the ladies might be donning and some of you can consider it so that you get the plants of these queries in your server log. So that if you start finding that, the server is going down, or if yesterday, something bad happened, you could go back to your logs, find out what, where is it was running? What were the plans for plants that was used for the doors and song? so, Yeah, it's good for

catching bad plants and then finding out are there in each week that we have to do to set up a parameter so that you get good plans or if you're using credit constructs which are problematic Peter, Noone problematic, like not adding the proper conditions are not adding them at proper places and so you could catch those kind of problems. Also, by looking at this plan plan, it's very flexible. You could just stay low. Explain to Lord this model in one of the station's where you want to have this deep work information, all

you could add a pin share, preload Library. So that all your patience inherit, this facility and all the queries run in. The server are locked. I mean they have that explains Lancelot I don't think so. Yeah. I just lowered will load will load the library. No, no no, no no. So it's configurable, there are many parameters, but some of the important ones I have listed here. For example, of manipulation controls how long a credit should run before it explain planned his output to disable lock. So if you have basically

it's good for debugging. Which are running longer than expected and then you don't get your locks collided with its planes. Land of all the crazy is that you run anywhere in this area, but that would be like you. Are there any sample rate than there are some more consideration for them to switch to tell you like what get output today explained plan and son. Coming to the last. This is useful, but the perception of a longer carry actually is very subjective. For example, an update can be very quickly if it's the point of dead

children within milliseconds. If it's analytical query that is being run, it will take seconds probably and if you're running a hybrid model transaction load running, on the same side that log mean, duration hardly helped you because an update also can have bad plants and it might be taking a second instead of 10:00, and you want to catch that. So that's that's one of the problems and there are a few others. So I mean, I am just listing some of the possible improvements that we could, you know, some ideas about what possibility we could improve in order to explain, for example, of one of the

things that came up in a discussion was, how about logging the plans for cancel. I will you usually cancel pretty by hand if it's running too long, longer than expected, that's the usual pattern. So how about adding those plants in your logs and then, you know, you get to the book or some of the bad patterns in the plants for example, join a clan touching mini partitions of tables. So that might indicate that you do not have the proper partition key. And there

are some other. So if you have more ideas, how to improve this tool, please let us know. Talk to the time here around tomorrow or just mail me on my email ID.

Cackle comments for the website

Buy this talk

Access to the talk “PGConf India 2020 - Lightning Talk - Auto Explain - Ashutosh Bapat - 2ndQuadrant”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Standart

Get access to all videos “PGConf India, 2020”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ticket

Interested in topic “IT & Technology”?

You might be interested in videos from this event

September 28, 2018
Moscow
16
179
app store, apps, development, google play, mobile, soft

Similar talks

Apoorva Aggarwal
Database Engineer at Clarisights
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ashesh Vashi
Principal Software Architect at EnterpriseDB
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Jobin Augustine
Senior Support Engineer at Percona
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Buy this video

Video

Access to the talk “PGConf India 2020 - Lightning Talk - Auto Explain - Ashutosh Bapat - 2ndQuadrant”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
816 conferences
32658 speakers
12329 hours of content