explain.log

text/x-log

Download

                                                                      QUERY PLAN                                                                      
------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=2313.13..145250.05 rows=39689 width=33) (actual time=20.841..259.154 rows=62530.00 loops=1)
   Output: t1.a
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=250992 read=453
   ->  Nested Loop  (cost=2313.13..145250.05 rows=19844 width=33) (actual time=14.816..244.557 rows=31265.00 loops=2)
         Output: t1.a
         Buffers: shared hit=250992 read=453
         Worker 0:  actual time=14.771..243.071 rows=30702.00 loops=1
           Buffers: shared hit=123237 read=451
         Worker 1:  actual time=14.860..246.043 rows=31828.00 loops=1
           Buffers: shared hit=127755 read=2
         ->  Parallel Bitmap Heap Scan on public.t t1  (cost=2312.66..3540.40 rows=31500 width=33) (actual time=14.718..21.161 rows=31265.00 loops=2)
               Output: t1.a
               Recheck Cond: (t1.a < 'a'::text)
               Buffers: shared hit=875 read=449
               Worker 0:  actual time=14.719..21.222 rows=30702.00 loops=1
                 Heap Blocks: exact=410
                 Buffers: shared hit=431 read=449
               Worker 1:  actual time=14.717..21.100 rows=31828.00 loops=1
                 Heap Blocks: exact=424
                 Buffers: shared hit=444
               ->  Bitmap Index Scan on t_a_idx  (cost=0.00..2296.91 rows=62999 width=0) (actual time=14.271..14.271 rows=62530.00 loops=1)
                     Index Cond: (t1.a < 'a'::text)
                     Index Searches: 1
                     Buffers: shared hit=1 read=449
                     Worker 0:  actual time=14.271..14.271 rows=62530.00 loops=1
                       Buffers: shared hit=1 read=449
         ->  Bitmap Heap Scan on public.t t2  (cost=0.47..4.49 rows=1 width=33) (actual time=0.006..0.006 rows=1.00 loops=62530)
               Output: t2.a
               Recheck Cond: ((t1.a = t2.a) AND (t2.a < 'a'::text))
               Buffers: shared hit=250117 read=4
               Worker 0:  actual time=0.006..0.006 rows=1.00 loops=30702
                 Buffers: shared hit=122806 read=2
               Worker 1:  actual time=0.006..0.006 rows=1.00 loops=31828
                 Buffers: shared hit=127311 read=2
               ->  Bitmap Index Scan on t_a_idx  (cost=0.00..0.47 rows=1 width=0) (actual time=0.005..0.005 rows=1.00 loops=62530)
                     Index Cond: ((t2.a = t1.a) AND (t2.a < 'a'::text))
                     Index Searches: 62530
                     Buffers: shared hit=187587 read=4
                     Worker 0:  actual time=0.005..0.005 rows=1.00 loops=30702
                       Buffers: shared hit=92104 read=2
                     Worker 1:  actual time=0.005..0.005 rows=1.00 loops=31828
                       Buffers: shared hit=95483 read=2
 Planning:
   Buffers: shared hit=13
 Planning Time: 0.304 ms
 Execution Time: 261.762 ms
(48 rows)