stats_100.txt

text/plain
Filename: stats_100.txt
Type: text/plain
Part: 1
Message: Re: WIP: Collecting statistics on CSV file data
postgres=# explain select * from csv_accounts where aid = 1;
                             QUERY PLAN
---------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=1 width=97)
   Filter: (aid = 1)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where aid < 1000;
                              QUERY PLAN
-----------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=943 width=97)
   Filter: (aid < 1000)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where aid > 1000;
                                QUERY PLAN
--------------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=499057 width=97)
   Filter: (aid > 1000)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where bid = 1;
                               QUERY PLAN
-------------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=98383 width=97)
   Filter: (bid = 1)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where bid = 2;
                                QUERY PLAN
--------------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=101200 width=97)
   Filter: (bid = 2)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where bid = 4;
                                QUERY PLAN
--------------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=102117 width=97)
   Filter: (bid = 4)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)

postgres=# explain select * from csv_accounts where bid = 6;
                             QUERY PLAN
---------------------------------------------------------------------
 Foreign Scan on csv_accounts  (cost=0.00..57105.00 rows=1 width=97)
   Filter: (bid = 6)
   Foreign File: /home/hanada/DB-fujita/CSV/pgbench_accounts.csv
   Foreign File Size: 47963070
(4 rows)