query-plan-1214

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
57079.848 100.00% 
 HashAggregate (cost=979567.77..979567.79 rows=1 width=13) (actual time=57079.825..57079.848 rows=15 loops=1)
55253.775 96.80% 
   -> Nested Loop (cost=0.0..979409.3 rows=31695 width=13) (actual time=50.154..55253.775 rows=1226890 loops=1)
         Join Filter: (d.id_partition = p.id)
3.314 0.01% 
         -> Seq Scan on partitions p (cost=0.0..740.17 rows=1 width=17) (actual time=0.080..3.314 rows=15 loops=1)
               Filter: (name ~~ 'SUDP%'::text)
52470.915 91.93% 
         -> Append (cost=0.0..967231.95 rows=914974 width=2) (actual time=27.053..3498.061 rows=81793 loops=15)
0.030 0.00% 
               -> Seq Scan on documents d (cost=0.0..16.4 rows=640 width=2) (actual time=0.002..0.002 rows=0 loops=15)
15.180 0.03% 
               -> Bitmap Heap Scan on documents_a d (cost=3684.29..106818.69 rows=203240 width=2) (actual time=1.012..1.012 rows=0 loops=15)
                     Recheck Cond: (d.id_partition = p.id)
15.135 0.03% 
                     -> Bitmap Index Scan on idx_documents_a_id_partition (cost=0.0..3633.48 rows=203240 width=0) (actual time=1.009..1.009 rows=0 loops=15)
                           Index Cond: (d.id_partition = p.id)
0.405 0.00% 
               -> Bitmap Heap Scan on documents_b d (cost=3729.89..120050.94 rows=209627 width=2) (actual time=0.027..0.027 rows=0 loops=15)
                     Recheck Cond: (d.id_partition = p.id)
0.360 0.00% 
                     -> Bitmap Index Scan on idx_documents_b_id_partition (cost=0.0..3677.48 rows=209627 width=0) (actual time=0.024..0.024 rows=0 loops=15)
                           Index Cond: (d.id_partition = p.id)
87.330 0.15% 
               -> Index Scan using idx_documents_c_id_partition on documents_c d (cost=0.0..98987.36 rows=103056 width=2) (actual time=5.822..5.822 rows=0 loops=15)
                     Index Cond: (d.id_partition = p.id)
43.395 0.08% 
               -> Bitmap Heap Scan on documents_d d (cost=1738.89..173541.45 rows=100820 width=2) (actual time=2.893..2.893 rows=0 loops=15)
                     Recheck Cond: (d.id_partition = p.id)
43.350 0.08% 
                     -> Bitmap Index Scan on idx_documents_d_id_partition (cost=0.0..1713.69 rows=100820 width=0) (actual time=2.890..2.890 rows=0 loops=15)
                           Index Cond: (d.id_partition = p.id)
49608.255 86.91% 
               -> Index Scan using idx_documents_e_id_partition on documents_e d (cost=0.0..191219.8 rows=111160 width=2) (actual time=17.290..3307.217 rows=81793 loops=15)
                     Index Cond: (d.id_partition = p.id)
58.425 0.10% 
               -> Bitmap Heap Scan on documents_f d (cost=2771.81..231438.79 rows=150436 width=2) (actual time=3.895..3.895 rows=0 loops=15)
                     Recheck Cond: (d.id_partition = p.id)
58.350 0.10% 
                     -> Bitmap Index Scan on idx_documents_f_id_partition (cost=0.0..2734.2 rows=150436 width=0) (actual time=3.890..3.890 rows=0 loops=15)
                           Index Cond: (d.id_partition = p.id)
142.170 0.25% 
               -> Index Scan using idx_documents_z_id_partition on documents_z d (cost=0.0..45158.52 rows=35995 width=2) (actual time=9.478..9.478 rows=0 loops=15)
                     Index Cond: (d.id_partition = p.id)
Run-time
57.080031 seconds (57080.031 ms)