Skip to content

Instantly share code, notes, and snippets.

@piotrwlodarczyk

piotrwlodarczyk/update on partition key

Created December 23, 2019 12:47
Show Gist options
  • Save piotrwlodarczyk/87a457acaa6225d84410c58e20585ff2 to your computer and use it in GitHub Desktop.
Save piotrwlodarczyk/87a457acaa6225d84410c58e20585ff2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update on partition key
QUERY PLAN
---------------------------------------------------------------------------------------
Update on book (cost=0.00..2663.79 rows=587 width=58)
Update on "public.book_1-1000_1990-01-01"
Update on "public.book_1-1000_1990-04-01"
Update on "public.book_1-1000_1990-07-01"
Update on "public.book_1-1000_1990-10-01"
Update on "public.book_1-1000_1991-01-01"
Update on "public.book_1-1000_1991-04-01"
Update on "public.book_1-1000_1991-07-01"
Update on "public.book_1-1000_1991-10-01"
Update on "public.book_1-1000_1992-01-01"
Update on "public.book_1-1000_1992-04-01"
Update on "public.book_1-1000_1992-07-01"
Update on "public.book_1-1000_1992-10-01"
Update on "public.book_1-1000_1993-01-01"
Update on "public.book_1-1000_1993-04-01"
Update on "public.book_1-1000_1993-07-01"
Update on "public.book_1-1000_1993-10-01"
Update on "public.book_1-1000_1994-01-01"
Update on "public.book_1-1000_1994-04-01"
Update on "public.book_1-1000_1994-07-01"
Update on "public.book_1-1000_1994-10-01"
Update on "public.book_1-1000_1995-01-01"
Update on "public.book_1-1000_1995-04-01"
Update on "public.book_1-1000_1995-07-01"
Update on "public.book_1-1000_1995-10-01"
Update on "public.book_1-1000_1996-01-01"
Update on "public.book_1-1000_1996-04-01"
Update on "public.book_1-1000_1996-07-01"
Update on "public.book_1-1000_1996-10-01"
Update on "public.book_1-1000_1997-01-01"
Update on "public.book_1-1000_1997-04-01"
Update on "public.book_1-1000_1997-07-01"
Update on "public.book_1-1000_1997-10-01"
Update on "public.book_1-1000_1998-01-01"
Update on "public.book_1-1000_1998-04-01"
Update on "public.book_1-1000_1998-07-01"
Update on "public.book_1-1000_1998-10-01"
Update on "public.book_1-1000_1999-01-01"
Update on "public.book_1-1000_1999-04-01"
Update on "public.book_1-1000_1999-07-01"
Update on "public.book_1-1000_1999-10-01"
Update on "public.book_1-1000_2000-01-01"
Update on "public.book_1-1000_2000-04-01"
Update on "public.book_1-1000_2000-07-01"
Update on "public.book_1-1000_2000-10-01"
Update on "public.book_1-1000_2001-01-01"
Update on "public.book_1-1000_2001-04-01"
Update on "public.book_1-1000_2001-07-01"
Update on "public.book_1-1000_2001-10-01"
Update on "public.book_1-1000_2002-01-01"
Update on "public.book_1-1000_2002-04-01"
Update on "public.book_1-1000_2002-07-01"
Update on "public.book_1-1000_2002-10-01"
Update on "public.book_1-1000_2003-01-01"
Update on "public.book_1-1000_2003-04-01"
Update on "public.book_1-1000_2003-07-01"
Update on "public.book_1-1000_2003-10-01"
Update on "public.book_1-1000_2004-01-01"
Update on "public.book_1-1000_2004-04-01"
Update on "public.book_1-1000_2004-07-01"
Update on "public.book_1-1000_2004-10-01"
Update on "public.book_1-1000_2005-01-01"
Update on "public.book_1-1000_2005-04-01"
Update on "public.book_1-1000_2005-07-01"
Update on "public.book_1-1000_2005-10-01"
Update on "public.book_1-1000_2006-01-01"
Update on "public.book_1-1000_2006-04-01"
Update on "public.book_1-1000_2006-07-01"
Update on "public.book_1-1000_2006-10-01"
Update on "public.book_1-1000_2007-01-01"
Update on "public.book_1-1000_2007-04-01"
Update on "public.book_1-1000_2007-07-01"
Update on "public.book_1-1000_2007-10-01"
Update on "public.book_1-1000_2008-01-01"
Update on "public.book_1-1000_2008-04-01"
Update on "public.book_1-1000_2008-07-01"
Update on "public.book_1-1000_2008-10-01"
Update on "public.book_1-1000_2009-01-01"
Update on "public.book_1-1000_2009-04-01"
Update on "public.book_1-1000_2009-07-01"
Update on "public.book_1-1000_2009-10-01"
Update on "public.book_1-1000_2010-01-01"
Update on "public.book_1-1000_2010-04-01"
Update on "public.book_1-1000_2010-07-01"
Update on "public.book_1-1000_2010-10-01"
Update on "public.book_1-1000_2011-01-01"
Update on "public.book_1-1000_2011-04-01"
Update on "public.book_1-1000_2011-07-01"
Update on "public.book_1-1000_2011-10-01"
Update on "public.book_1-1000_2012-01-01"
Update on "public.book_1-1000_2012-04-01"
Update on "public.book_1-1000_2012-07-01"
Update on "public.book_1-1000_2012-10-01"
Update on "public.book_1-1000_2013-01-01"
Update on "public.book_1-1000_2013-04-01"
Update on "public.book_1-1000_2013-07-01"
Update on "public.book_1-1000_2013-10-01"
Update on "public.book_1-1000_2014-01-01"
Update on "public.book_1-1000_2014-04-01"
Update on "public.book_1-1000_2014-07-01"
Update on "public.book_1-1000_2014-10-01"
Update on "public.book_1-1000_2015-01-01"
Update on "public.book_1-1000_2015-04-01"
Update on "public.book_1-1000_2015-07-01"
Update on "public.book_1-1000_2015-10-01"
Update on "public.book_1-1000_2016-01-01"
Update on "public.book_1-1000_2016-04-01"
Update on "public.book_1-1000_2016-07-01"
Update on "public.book_1-1000_2016-10-01"
Update on "public.book_1-1000_2017-01-01"
Update on "public.book_1-1000_2017-04-01"
Update on "public.book_1-1000_2017-07-01"
Update on "public.book_1-1000_2017-10-01"
Update on "public.book_1-1000_2018-01-01"
Update on "public.book_1-1000_2018-04-01"
Update on "public.book_1-1000_2018-07-01"
Update on "public.book_1-1000_2018-10-01"
Update on "public.book_1-1000_2019-01-01"
Update on "public.book_1-1000_2019-04-01"
Update on "public.book_1-1000_2019-07-01"
-> Seq Scan on "public.book_1-1000_1990-01-01" (cost=0.00..1.01 rows=1 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1990-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1990-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1990-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1991-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1991-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1991-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1991-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1992-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1992-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1992-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1992-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1993-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1993-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1993-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1993-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1994-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1994-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1994-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1994-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1995-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1995-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1995-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1995-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1996-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1996-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1996-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1996-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1997-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1997-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1997-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1997-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1998-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1998-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1998-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1998-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1999-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1999-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1999-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_1999-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2000-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2000-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2000-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2000-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2001-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2001-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2001-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2001-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2002-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2002-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2002-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2002-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2003-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2003-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2003-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2003-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2004-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2004-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2004-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2004-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2005-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2005-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2005-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2005-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2006-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2006-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2006-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2006-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2007-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2007-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2007-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2007-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2008-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2008-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2008-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2008-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2009-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2009-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2009-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2009-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2010-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2010-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2010-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2010-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2011-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2011-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2011-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2011-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2012-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2012-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2012-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2012-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2013-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2013-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2013-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2013-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2014-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2014-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2014-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2014-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2015-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2015-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2015-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2015-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2016-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2016-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2016-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2016-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2017-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2017-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2017-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2017-10-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2018-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2018-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2018-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2018-10-01" (cost=0.00..1.02 rows=1 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2019-01-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2019-04-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
-> Seq Scan on "public.book_1-1000_2019-07-01" (cost=0.00..22.75 rows=5 width=58)
Filter: (id_owner = 5)
(358 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment