Skip to content

Instantly share code, notes, and snippets.

@piotrwlodarczyk

piotrwlodarczyk/6000 explain on partitioned

Created August 12, 2019 12:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save piotrwlodarczyk/c157cc9321b6e1a1d0f900310f14f1cc to your computer and use it in GitHub Desktop.
Save piotrwlodarczyk/c157cc9321b6e1a1d0f900310f14f1cc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
6000 explain on partitioned
"Append (cost=0.00..3723.51 rows=952 width=20) (actual time=0.859..0.859 rows=0 loops=1)"
" -> Seq Scan on "public.book_1-1000_1990-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.011..0.011 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1990-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1990-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1990-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1991-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1991-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1991-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1991-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1992-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1992-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1992-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1992-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1993-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1993-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1993-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1993-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1994-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1994-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1994-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1994-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.003..0.003 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1995-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1995-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1995-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1995-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1996-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1996-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1996-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1996-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1997-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1997-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1997-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1997-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1998-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1998-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1998-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1998-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1999-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1999-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1999-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_1999-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2000-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2000-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2000-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2000-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2001-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2001-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2001-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2001-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2002-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2002-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2002-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2002-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2003-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2003-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2003-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2003-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2004-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2004-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2004-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2004-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2005-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.008..0.008 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2005-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2005-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2005-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2006-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.008..0.008 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2006-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2006-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2006-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2007-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2007-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2007-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2007-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2008-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2008-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.072..0.072 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2008-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2008-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2009-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.019..0.019 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2009-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2009-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2009-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2010-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2010-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2010-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.018..0.018 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2010-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2011-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.006..0.006 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2011-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2011-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.009..0.009 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2011-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2012-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.013..0.013 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2012-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.008..0.008 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2012-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.008..0.008 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2012-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.009..0.009 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2013-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.009..0.009 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2013-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.009..0.009 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2013-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.008 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2013-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.010..0.010 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2014-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2014-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2014-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.025..0.025 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2014-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2015-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2015-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2015-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2015-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.038..0.038 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2016-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2016-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2016-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.015..0.015 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2016-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.030..0.030 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2017-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2017-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2017-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2017-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2018-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2018-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2018-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2018-10-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.007..0.007 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2019-01-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2019-04-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.005..0.005 rows=0 loops=1)"
" Filter: (id_owner = 4)"
" -> Seq Scan on "public.book_1-1000_2019-07-01" (cost=0.00..31.25 rows=8 width=20) (actual time=0.004..0.004 rows=0 loops=1)"
" Filter: (id_owner = 4)"
"Planning Time: 60.555 ms"
"Execution Time: 1.368 ms"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment