Perl x Open Food Facts Hackathon: Paris, France - May 24-25 Learn more

DEPESZ / Pg-Explain-2.9 / t / 50-psql-frames.d / text-1-aligned-unicode-double-double-double.plan 

            

              
1
2
3
4
5
6
7
8
9
10
11
12

              
                                                  QUERY PLAN                                                  
══════════════════════════════════════════════════════════════════════════════════════════════════════════════
 Nested Loop  (cost=0.00..2017.80 rows=15 width=133) (actual time=0.044..2.162 rows=15 loops=1)
   ->  Seq Scan on users u  (cost=0.00..41.40 rows=1 width=129) (actual time=0.017..0.082 rows=1 loops=1)
         Filter: (username = 'depesz'::text)
         Rows Removed by Filter: 1231
   ->  Seq Scan on part_0 p  (cost=0.00..1976.25 rows=15 width=17) (actual time=0.026..2.077 rows=15 loops=1)
         Filter: (added_by = 'depesz'::text)
         Rows Removed by Filter: 13205
 Planning Time: 0.047 ms
 Execution Time: 2.172 ms
(9 rows)