query-plan-1213

Change label
Query Plan as raw text
Summary
HashAggregate (cost=979567.77..979567.79 rows=1 width=13) -> Nested Loop (cost=0.00..979409.30 rows=31695 width=13) Join Filter: (d.id_partition = p.id) -> Seq Scan on partitions p (cost=0.00..740.17 rows=1 width=17) Filter: (name ~~ 'SUDP%'::text) -> Append (cost=0.00..967231.95 rows=914974 width=2) -> Seq Scan on documents d (cost=0.00..16.40 rows=640 width=2) -> Bitmap Heap Scan on documents_a d (cost=3684.29..106818.69 rows=203240 width=2) Recheck Cond: (d.id_partition = p.id) -> Bitmap Index Scan on idx_documents_a_id_partition (cost=0.00..3633.48 rows=203240 width=0) Index Cond: (d.id_partition = p.id) -> Bitmap Heap Scan on documents_b d (cost=3729.89..120050.94 rows=209627 width=2) Recheck Cond: (d.id_partition = p.id) -> Bitmap Index Scan on idx_documents_b_id_partition (cost=0.00..3677.48 rows=209627 width=0) Index Cond: (d.id_partition = p.id) -> Index Scan using idx_documents_c_id_partition on documents_c d (cost=0.00..98987.36 rows=103056 width=2) Index Cond: (d.id_partition = p.id) -> Bitmap Heap Scan on documents_d d (cost=1738.89..173541.45 rows=100820 width=2) Recheck Cond: (d.id_partition = p.id) -> Bitmap Index Scan on idx_documents_d_id_partition (cost=0.00..1713.69 rows=100820 width=0) Index Cond: (d.id_partition = p.id) -> Index Scan using idx_documents_e_id_partition on documents_e d (cost=0.00..191219.80 rows=111160 width=2) Index Cond: (d.id_partition = p.id) -> Bitmap Heap Scan on documents_f d (cost=2771.81..231438.79 rows=150436 width=2) Recheck Cond: (d.id_partition = p.id) -> Bitmap Index Scan on idx_documents_f_id_partition (cost=0.00..2734.20 rows=150436 width=0) Index Cond: (d.id_partition = p.id) -> Index Scan using idx_documents_z_id_partition on documents_z d (cost=0.00..45158.52 rows=35995 width=2) Index Cond: (d.id_partition = p.id)