- Notifications
You must be signed in to change notification settings - Fork5
Commit4f42b54
committed
Separate state from query string in pg_stat_activity
This separates the state (running/idle/idleintransaction etc) intoit's own field ("state"), and leaves the query field containing justquery text.The query text will now mean "current query" when a query is runningand "last query" in other states. Accordingly,the field has beenrenamed from current_query to query.Since backwards compatibility was broken anyway to make that, the procpidfield has also been renamed to pid - along with the same field inpg_stat_replication for consistency.Scott Mead and Magnus Hagander, review work from Greg Smith1 parentfa352d6 commit4f42b54
File tree
10 files changed
+378
-85
lines changed- doc/src/sgml
- src
- backend
- catalog
- postmaster
- tcop
- utils/adt
- include
- catalog
- test/regress/expected
10 files changed
+378
-85
lines changedLines changed: 219 additions & 14 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
242 | 242 |
| |
243 | 243 |
| |
244 | 244 |
| |
245 |
| - | |
246 |
| - | |
247 |
| - | |
248 |
| - | |
249 |
| - | |
250 |
| - | |
251 |
| - | |
252 |
| - | |
253 |
| - | |
254 |
| - | |
255 |
| - | |
256 |
| - | |
257 |
| - | |
258 |
| - | |
| 245 | + | |
| 246 | + | |
| 247 | + | |
| 248 | + | |
| 249 | + | |
| 250 | + | |
| 251 | + | |
| 252 | + | |
| 253 | + | |
| 254 | + | |
| 255 | + | |
| 256 | + | |
| 257 | + | |
| 258 | + | |
259 | 259 |
| |
260 | 260 |
| |
261 | 261 |
| |
| |||
529 | 529 |
| |
530 | 530 |
| |
531 | 531 |
| |
| 532 | + | |
| 533 | + | |
| 534 | + | |
| 535 | + | |
| 536 | + | |
| 537 | + | |
| 538 | + | |
| 539 | + | |
| 540 | + | |
| 541 | + | |
| 542 | + | |
| 543 | + | |
| 544 | + | |
| 545 | + | |
| 546 | + | |
| 547 | + | |
| 548 | + | |
| 549 | + | |
| 550 | + | |
| 551 | + | |
| 552 | + | |
| 553 | + | |
| 554 | + | |
| 555 | + | |
| 556 | + | |
| 557 | + | |
| 558 | + | |
| 559 | + | |
| 560 | + | |
| 561 | + | |
| 562 | + | |
| 563 | + | |
| 564 | + | |
| 565 | + | |
| 566 | + | |
| 567 | + | |
| 568 | + | |
| 569 | + | |
| 570 | + | |
| 571 | + | |
| 572 | + | |
| 573 | + | |
| 574 | + | |
| 575 | + | |
| 576 | + | |
| 577 | + | |
| 578 | + | |
| 579 | + | |
| 580 | + | |
| 581 | + | |
| 582 | + | |
| 583 | + | |
| 584 | + | |
| 585 | + | |
| 586 | + | |
| 587 | + | |
| 588 | + | |
| 589 | + | |
| 590 | + | |
| 591 | + | |
| 592 | + | |
| 593 | + | |
| 594 | + | |
| 595 | + | |
| 596 | + | |
| 597 | + | |
| 598 | + | |
| 599 | + | |
| 600 | + | |
| 601 | + | |
| 602 | + | |
| 603 | + | |
| 604 | + | |
| 605 | + | |
| 606 | + | |
| 607 | + | |
| 608 | + | |
| 609 | + | |
| 610 | + | |
| 611 | + | |
| 612 | + | |
| 613 | + | |
| 614 | + | |
| 615 | + | |
| 616 | + | |
| 617 | + | |
| 618 | + | |
| 619 | + | |
| 620 | + | |
| 621 | + | |
| 622 | + | |
| 623 | + | |
| 624 | + | |
| 625 | + | |
| 626 | + | |
| 627 | + | |
| 628 | + | |
| 629 | + | |
| 630 | + | |
| 631 | + | |
| 632 | + | |
| 633 | + | |
| 634 | + | |
| 635 | + | |
| 636 | + | |
| 637 | + | |
| 638 | + | |
| 639 | + | |
| 640 | + | |
| 641 | + | |
| 642 | + | |
| 643 | + | |
| 644 | + | |
| 645 | + | |
| 646 | + | |
| 647 | + | |
| 648 | + | |
| 649 | + | |
| 650 | + | |
| 651 | + | |
| 652 | + | |
| 653 | + | |
| 654 | + | |
| 655 | + | |
| 656 | + | |
| 657 | + | |
| 658 | + | |
| 659 | + | |
| 660 | + | |
| 661 | + | |
| 662 | + | |
| 663 | + | |
| 664 | + | |
| 665 | + | |
| 666 | + | |
| 667 | + | |
| 668 | + | |
| 669 | + | |
| 670 | + | |
| 671 | + | |
| 672 | + | |
| 673 | + | |
| 674 | + | |
| 675 | + | |
| 676 | + | |
| 677 | + | |
| 678 | + | |
| 679 | + | |
| 680 | + | |
| 681 | + | |
| 682 | + | |
| 683 | + | |
| 684 | + | |
| 685 | + | |
| 686 | + | |
| 687 | + | |
| 688 | + | |
| 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 | + | |
| 728 | + | |
| 729 | + | |
| 730 | + | |
| 731 | + | |
| 732 | + | |
| 733 | + | |
| 734 | + | |
| 735 | + | |
532 | 736 |
| |
533 | 737 |
| |
534 | 738 |
| |
| |||
1264 | 1468 |
| |
1265 | 1469 |
| |
1266 | 1470 |
| |
| 1471 | + | |
1267 | 1472 |
| |
1268 | 1473 |
| |
1269 | 1474 |
| |
|
Lines changed: 6 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
520 | 520 |
| |
521 | 521 |
| |
522 | 522 |
| |
523 |
| - | |
| 523 | + | |
524 | 524 |
| |
525 | 525 |
| |
526 | 526 |
| |
| |||
530 | 530 |
| |
531 | 531 |
| |
532 | 532 |
| |
| 533 | + | |
533 | 534 |
| |
534 |
| - | |
| 535 | + | |
| 536 | + | |
535 | 537 |
| |
536 | 538 |
| |
537 | 539 |
| |
538 | 540 |
| |
539 | 541 |
| |
540 | 542 |
| |
541 |
| - | |
| 543 | + | |
542 | 544 |
| |
543 | 545 |
| |
544 | 546 |
| |
| |||
556 | 558 |
| |
557 | 559 |
| |
558 | 560 |
| |
559 |
| - | |
| 561 | + | |
560 | 562 |
| |
561 | 563 |
| |
562 | 564 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2781 | 2781 |
| |
2782 | 2782 |
| |
2783 | 2783 |
| |
2784 |
| - | |
| 2784 | + | |
2785 | 2785 |
| |
2786 | 2786 |
| |
2787 | 2787 |
| |
|
Lines changed: 44 additions & 11 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2410 | 2410 |
| |
2411 | 2411 |
| |
2412 | 2412 |
| |
| 2413 | + | |
2413 | 2414 |
| |
2414 | 2415 |
| |
2415 | 2416 |
| |
2416 | 2417 |
| |
2417 | 2418 |
| |
2418 | 2419 |
| |
| 2420 | + | |
2419 | 2421 |
| |
2420 | 2422 |
| |
2421 | 2423 |
| |
| |||
2476 | 2478 |
| |
2477 | 2479 |
| |
2478 | 2480 |
| |
| 2481 | + | |
| 2482 | + | |
| 2483 | + | |
| 2484 | + | |
2479 | 2485 |
| |
2480 | 2486 |
| |
2481 | 2487 |
| |
2482 |
| - | |
| 2488 | + | |
2483 | 2489 |
| |
2484 | 2490 |
| |
2485 | 2491 |
| |
| 2492 | + | |
2486 | 2493 |
| |
2487 | 2494 |
| |
2488 | 2495 |
| |
2489 | 2496 |
| |
2490 |
| - | |
| 2497 | + | |
2491 | 2498 |
| |
2492 | 2499 |
| |
2493 | 2500 |
| |
2494 | 2501 |
| |
2495 | 2502 |
| |
2496 | 2503 |
| |
2497 |
| - | |
| 2504 | + | |
2498 | 2505 |
| |
2499 |
| - | |
2500 |
| - | |
| 2506 | + | |
| 2507 | + | |
| 2508 | + | |
| 2509 | + | |
| 2510 | + | |
| 2511 | + | |
| 2512 | + | |
| 2513 | + | |
| 2514 | + | |
| 2515 | + | |
| 2516 | + | |
| 2517 | + | |
| 2518 | + | |
| 2519 | + | |
2501 | 2520 |
| |
2502 | 2521 |
| |
2503 |
| - | |
2504 |
| - | |
2505 |
| - | |
| 2522 | + | |
| 2523 | + | |
| 2524 | + | |
| 2525 | + | |
| 2526 | + | |
| 2527 | + | |
| 2528 | + | |
| 2529 | + | |
| 2530 | + | |
| 2531 | + | |
| 2532 | + | |
2506 | 2533 |
| |
2507 | 2534 |
| |
2508 | 2535 |
| |
2509 |
| - | |
2510 |
| - | |
2511 |
| - | |
| 2536 | + | |
| 2537 | + | |
| 2538 | + | |
| 2539 | + | |
| 2540 | + | |
| 2541 | + | |
| 2542 | + | |
| 2543 | + | |
| 2544 | + | |
2512 | 2545 |
| |
2513 | 2546 |
| |
2514 | 2547 |
| |
|
0 commit comments
Comments
(0)