Skip to content

Instantly share code, notes, and snippets.

@piotrwlodarczyk

piotrwlodarczyk/pruning on

Created December 23, 2019 15:19
Show Gist options
  • Save piotrwlodarczyk/74eef9caced9b0fc516c5c6bdb9689ee to your computer and use it in GitHub Desktop.
Save piotrwlodarczyk/74eef9caced9b0fc516c5c6bdb9689ee to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pruning on
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Append (cost=0.00..2666.72 rows=587 width=52) (actual time=0.011..0.227 rows=1 loops=1)
-> Seq Scan on "public.book_1-1000_1990-01-01" (cost=0.00..1.01 rows=1 width=52) (actual time=0.009..0.010 rows=1 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1990-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1990-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1990-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1991-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1991-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1991-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1991-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1992-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1992-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1992-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1992-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1993-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1993-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1993-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1993-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1994-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1994-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1994-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1994-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1995-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1995-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1995-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1995-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1996-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1996-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1996-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1996-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1997-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1997-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1997-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1997-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1998-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1998-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1998-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1998-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1999-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1999-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1999-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_1999-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2000-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2000-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2000-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2000-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2001-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2001-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2001-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2001-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2002-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2002-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2002-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2002-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2003-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.005..0.005 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2003-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2003-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2003-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2004-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2004-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2004-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2004-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2005-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2005-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2005-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2005-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2006-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2006-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2006-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2006-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2007-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2007-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2007-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2007-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2008-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2008-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.005..0.005 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2008-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2008-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2009-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2009-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2009-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2009-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2010-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2010-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2010-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2010-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2011-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2011-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2011-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2011-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2012-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2012-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2012-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2012-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2013-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2013-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2013-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2013-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2014-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2014-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2014-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2014-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2015-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2015-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2015-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2015-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2016-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2016-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2016-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2016-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2017-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2017-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2017-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2017-10-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.002..0.002 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2018-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2018-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2018-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2018-10-01" (cost=0.00..1.02 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=1)
Filter: (id_owner = 4)
Rows Removed by Filter: 2
-> Seq Scan on "public.book_1-1000_2019-01-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2019-04-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
-> Seq Scan on "public.book_1-1000_2019-07-01" (cost=0.00..22.75 rows=5 width=52) (actual time=0.001..0.001 rows=0 loops=1)
Filter: (id_owner = 4)
Planning Time: 4.160 ms
Execution Time: 0.600 ms
(242 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment