{"push_id":2656006884,"size":12,"distinct_size":1,"ref":"refs/heads/relation_size","head":"f67a393e9ae6d348f1c6abd57ad9867d9d605aac","before":"7dfd08cc71e41887498de328761bc7767329eab2","commits":[{"sha":"beae394fcbff078990c2e4450f2d85c70accbda5","author":{"name":"Christophe Courtois","email":"50a432966ffeb4f02ea789583c1dba01105be4f9@dalibo.com"},"message":" Fix uptime failure to detect a crash-and-restart after a child process failure (10+)\n\n On PG10+, uptime is the age of the latest child process (usually checkpointer, writer...).\npg_monitor at least is needed.\nClient backends are excluded because some were met that were older although dead.\n\n The same fix on PG 9.6 and before will need to find another way.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/beae394fcbff078990c2e4450f2d85c70accbda5"},{"sha":"b7dcffc586a8167c4875dffff87f779c594ec55f","author":{"name":"anayrat","email":"76746fc7005e155379421ae108f3d9fd9694dc09@dalibo.com"},"message":"replication_slots : handle wal files and pg_replslots files for each slot.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/b7dcffc586a8167c4875dffff87f779c594ec55f"},{"sha":"6740d98a6cfc49d96d2e91c0c222f2cf90e31222","author":{"name":"Christophe Courtois","email":"50a432966ffeb4f02ea789583c1dba01105be4f9@dalibo.com"},"message":"Revert \" Fix uptime failure to detect a crash-and-restart after a child process failure (10+)\"\n\nThis reverts commit beae394fcbff078990c2e4450f2d85c70accbda5.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/6740d98a6cfc49d96d2e91c0c222f2cf90e31222"},{"sha":"b91ed6a574329ee09849e5d924186216895d88b4","author":{"name":"Christophe Courtois","email":"50a432966ffeb4f02ea789583c1dba01105be4f9@dalibo.com"},"message":"sequences_exhausted: missing comment on dbinclude/dbexclude support","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/b91ed6a574329ee09849e5d924186216895d88b4"},{"sha":"78debf53fc78eb56d47076c518a60082b6706579","author":{"name":"Julien Rouhaud","email":"a4f7e71329201382f83250e57086fe3be9c5ed2b@free.fr"},"message":"Update copyright for 2018.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/78debf53fc78eb56d47076c518a60082b6706579"},{"sha":"07754a4a0f2d2f85b3aa976b19f89f199661f0b5","author":{"name":"madtibo","email":"3a8f422eb1696d00a701ceb17f8172734611911f@tribu-ml.fr"},"message":"set correct version for wal magic number in version 10","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/07754a4a0f2d2f85b3aa976b19f89f199661f0b5"},{"sha":"78ed012b15a0cb96b7c6a5b70d1b58ae70d0bcec","author":{"name":"Thomas","email":"4da334987b748b41dae5b5c903c4e7d90c5c239f@users.noreply.github.com"},"message":"Merge pull request #190 from madtibo/archive_folder_wal_version_10\n\nSet correct version for WAL magic number (XLOG_PAGE_MAGIC) in version 10.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/78ed012b15a0cb96b7c6a5b70d1b58ae70d0bcec"},{"sha":"1eac4533366f6f36db3ca958cd03e453f04f1cc1","author":{"name":"Julien Rouhaud","email":"a4f7e71329201382f83250e57086fe3be9c5ed2b@free.fr"},"message":"Fix handling or file reading errors.","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/1eac4533366f6f36db3ca958cd03e453f04f1cc1"},{"sha":"d0294ebd26c29c34f99d709615683afa6d45de71","author":{"name":"Thomas","email":"4da334987b748b41dae5b5c903c4e7d90c5c239f@users.noreply.github.com"},"message":"Merge pull request #185 from Krysztophe/seq_exhausted_dbinexclude\n\nsequences_exhausted: missing comment on dbinclude/dbexclude support","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/d0294ebd26c29c34f99d709615683afa6d45de71"},{"sha":"602ae71f4caa0a169ea9ba2a8ba63ea6230fb4b7","author":{"name":"Thomas","email":"4da334987b748b41dae5b5c903c4e7d90c5c239f@users.noreply.github.com"},"message":"Merge pull request #176 from anayrat/logical_rep\n\nreplication_slots : handle wal files and pg_replslots files","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/602ae71f4caa0a169ea9ba2a8ba63ea6230fb4b7"},{"sha":"19b20edba5c4ae775efac669913bff2b86dd4f59","author":{"name":"Christophe Courtois","email":"50a432966ffeb4f02ea789583c1dba01105be4f9@dalibo.com"},"message":"Merge remote-tracking branch 'upstream/master'","distinct":false,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/19b20edba5c4ae775efac669913bff2b86dd4f59"},{"sha":"f67a393e9ae6d348f1c6abd57ad9867d9d605aac","author":{"name":"Christophe Courtois","email":"50a432966ffeb4f02ea789583c1dba01105be4f9@dalibo.com"},"message":"Add a relation_size service to follow the size of a few tables, including aggregated tables.\n\nBy default, it lists all tables, indexes, materialized views.\n--include 'tablename' lists one (ore more) relations and all its(their) indexes and (sub)partitions with their pg_relation_size\n--agg aggregates a table and its partitions (both partitioning modes) including indexes and toast\n--details shows vm,fsm,main,toast,idx of tables instead of just pg_relation_size (and aggregates the indexes)\n--agg --details shows vm,fsm,main,toast,idx summed up for all partitions.\n\nWarning and Critical (optional) are triggered by size (compared to each returned line).\n\nThis service is fully functional but may need more work: the main query is a bit tormented and may be simplified or tuned, the perl part is a bit naive. The main query uses dynamic filtering to reduce the load on the server. Complete query time is usually below the second on my laptop, even with thousands of tables, but may need a few seconds in degenerated cases (10'000 partitions); and much more time is spent in check_pgactivity itself without --agg (but listing thousands of tables is pointless).","distinct":true,"url":"https://api.github.com/repos/Krysztophe/check_pgactivity/commits/f67a393e9ae6d348f1c6abd57ad9867d9d605aac"}]}
{"actor":{"display_login":"Krysztophe"}}