forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit10ea0f9
committed
Expose some information about backend subxact status.
A new function pg_stat_get_backend_subxact() can be used to getinformation about the number of subtransactions in the cache ofa particular backend and whether that cache has overflowed. Thiscan be useful for tracking down performance problems that canresult from overflowed snapshots.Dilip Kumar, reviewed by Zhihong Yu, Nikolay Samokhvalov,Justin Pryzby, Nathan Bossart, Ashutosh Sharma, JulienRouhaud. Additional design comments from Andres Freund,Tom Lane, Bruce Momjian, and David G. Johnston.Discussion:http://postgr.es/m/CAFiTN-ut0uwkRJDQJeDPXpVyTWD46m3gt3JDToE02hTfONEN=Q@mail.gmail.com1 parent7122f9d commit10ea0f9
File tree
8 files changed
+90
-7
lines changed- doc/src/sgml
- src
- backend
- storage/ipc
- utils
- activity
- adt
- include
- catalog
- storage
- utils
8 files changed
+90
-7
lines changedLines changed: 18 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
5671 | 5671 |
| |
5672 | 5672 |
| |
5673 | 5673 |
| |
| 5674 | + | |
| 5675 | + | |
| 5676 | + | |
| 5677 | + | |
| 5678 | + | |
| 5679 | + | |
| 5680 | + | |
| 5681 | + | |
| 5682 | + | |
| 5683 | + | |
| 5684 | + | |
| 5685 | + | |
| 5686 | + | |
| 5687 | + | |
| 5688 | + | |
| 5689 | + | |
| 5690 | + | |
| 5691 | + | |
5674 | 5692 |
| |
5675 | 5693 |
| |
5676 | 5694 |
| |
|
Lines changed: 9 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
404 | 404 |
| |
405 | 405 |
| |
406 | 406 |
| |
407 |
| - | |
408 |
| - | |
409 |
| - | |
| 407 | + | |
| 408 | + | |
| 409 | + | |
410 | 410 |
| |
411 | 411 |
| |
412 |
| - | |
| 412 | + | |
| 413 | + | |
413 | 414 |
| |
414 | 415 |
| |
415 | 416 |
| |
416 | 417 |
| |
417 | 418 |
| |
| 419 | + | |
| 420 | + | |
418 | 421 |
| |
419 | 422 |
| |
420 | 423 |
| |
| |||
428 | 431 |
| |
429 | 432 |
| |
430 | 433 |
| |
| 434 | + | |
| 435 | + | |
431 | 436 |
| |
432 | 437 |
| |
433 | 438 |
| |
|
Lines changed: 3 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
855 | 855 |
| |
856 | 856 |
| |
857 | 857 |
| |
858 |
| - | |
| 858 | + | |
| 859 | + | |
| 860 | + | |
859 | 861 |
| |
860 | 862 |
| |
861 | 863 |
| |
|
Lines changed: 38 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
687 | 687 |
| |
688 | 688 |
| |
689 | 689 |
| |
| 690 | + | |
| 691 | + | |
| 692 | + | |
| 693 | + | |
| 694 | + | |
| 695 | + | |
| 696 | + | |
| 697 | + | |
| 698 | + | |
| 699 | + | |
| 700 | + | |
| 701 | + | |
| 702 | + | |
| 703 | + | |
| 704 | + | |
| 705 | + | |
| 706 | + | |
| 707 | + | |
| 708 | + | |
| 709 | + | |
| 710 | + | |
| 711 | + | |
| 712 | + | |
| 713 | + | |
| 714 | + | |
| 715 | + | |
| 716 | + | |
| 717 | + | |
| 718 | + | |
| 719 | + | |
| 720 | + | |
| 721 | + | |
| 722 | + | |
| 723 | + | |
| 724 | + | |
| 725 | + | |
| 726 | + | |
| 727 | + | |
690 | 728 |
| |
691 | 729 |
| |
692 | 730 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
57 | 57 |
| |
58 | 58 |
| |
59 | 59 |
| |
60 |
| - | |
| 60 | + | |
61 | 61 |
| |
62 | 62 |
|
Lines changed: 7 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
5441 | 5441 |
| |
5442 | 5442 |
| |
5443 | 5443 |
| |
| 5444 | + | |
| 5445 | + | |
| 5446 | + | |
| 5447 | + | |
| 5448 | + | |
| 5449 | + | |
| 5450 | + | |
5444 | 5451 |
| |
5445 | 5452 |
| |
5446 | 5453 |
| |
|
Lines changed: 3 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
32 | 32 |
| |
33 | 33 |
| |
34 | 34 |
| |
35 |
| - | |
| 35 | + | |
| 36 | + | |
| 37 | + | |
36 | 38 |
| |
37 | 39 |
| |
38 | 40 |
| |
|
Lines changed: 11 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
266 | 266 |
| |
267 | 267 |
| |
268 | 268 |
| |
| 269 | + | |
| 270 | + | |
| 271 | + | |
| 272 | + | |
| 273 | + | |
| 274 | + | |
| 275 | + | |
| 276 | + | |
| 277 | + | |
| 278 | + | |
| 279 | + | |
269 | 280 |
| |
270 | 281 |
| |
271 | 282 |
| |
|
0 commit comments
Comments
(0)