Skip to content

Instantly share code, notes, and snippets.

@piotrwlodarczyk

piotrwlodarczyk/6000 explain

Created August 12, 2019 12:15
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/277687b21201340377116a18a3dd8be8 to your computer and use it in GitHub Desktop.
Save piotrwlodarczyk/277687b21201340377116a18a3dd8be8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
6000 explain
"Append (cost=0.00..3723.51 rows=952 width=20) (actual time=49.597..49.597 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.908..0.908 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.479..0.479 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.482..0.482 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.517..0.518 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.507..0.507 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.411..0.411 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.401..0.402 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.466..0.466 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.456..0.456 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.489..0.489 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.494..0.494 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.445..0.445 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.457..0.457 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.395..0.395 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.401..0.401 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.391..0.391 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.392..0.392 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.390..0.391 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.391..0.392 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.392..0.392 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.390..0.390 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.390..0.390 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.401..0.401 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.389..0.389 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.392..0.392 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.393..0.393 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.389..0.389 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.389..0.390 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.397..0.397 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.396..0.397 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.389..0.389 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.387..0.388 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.495..0.495 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.445..0.445 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.462..0.463 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.431..0.431 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.513..0.513 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.451..0.451 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.519..0.519 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.494..0.494 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.505..0.505 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.487..0.487 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.464..0.464 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.468..0.468 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.533..0.533 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.411..0.411 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.415..0.415 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.394..0.395 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.394..0.394 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.395..0.395 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.388..0.388 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.393..0.393 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.397..0.397 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.387..0.388 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.400..0.400 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.391..0.392 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.393..0.393 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.391..0.391 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.387..0.387 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.393..0.393 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.393..0.393 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.390..0.390 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.397..0.397 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.391..0.391 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.390..0.390 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.388..0.388 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.391..0.391 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.395..0.395 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.393..0.393 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.391..0.391 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.389..0.390 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.387..0.387 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.390..0.391 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.392..0.393 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.388..0.388 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.386..0.387 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.389..0.389 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.387..0.387 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.393..0.393 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.395..0.395 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.470..0.470 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.464..0.464 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.408..0.408 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.394..0.394 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.402..0.402 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.402..0.402 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.396..0.396 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.398..0.398 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.399..0.399 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.393..0.393 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.390..0.390 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.389..0.389 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.392..0.392 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.387..0.387 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.390..0.390 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.390..0.390 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.391..0.391 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.388..0.388 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.384..0.384 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.389..0.389 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.391..0.391 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.389..0.389 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.434..0.434 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.410..0.410 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.397..0.397 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.391..0.391 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.392..0.392 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.392..0.392 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.389..0.389 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.393..0.393 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.393..0.393 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.392..0.392 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.390..0.390 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.389..0.389 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.391..0.392 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.402..0.402 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.387..0.387 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.391..0.391 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.385..0.385 rows=0 loops=1)"
" Filter: (id_owner = 4)"
"Planning Time: 2530.179 ms"
"Execution Time: 50.647 ms"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment