explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YhXt

Settings
# exclusive inclusive rows x rows loops node
1. 0.147 555.314 ↑ 14.1 31 1

Sort (cost=75,375.42..75,376.51 rows=436 width=14,102) (actual time=555.312..555.314 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, ((alternatives: SubPlan 1 or hashed SubPlan 2)), source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_code_1.version_id, news_version_code_1.code_id, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile, news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name, news_group_1.news_id, news_group_1.group_id, user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Sort Key: news.status_modified_at DESC, user_1.id, newsbreak_user_1.status_id, group_1.id, newsbreak_group_1.status_id, user_3.id, code_1.id, user_4.id, group_2.id
  • Sort Method: quicksort Memory: 83kB
  • Buffers: shared hit=56312
2. 0.073 555.167 ↑ 14.1 31 1

Hash Left Join (cost=65,764.47..75,356.30 rows=436 width=14,102) (actual time=555.095..555.167 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, (alternatives: SubPlan 1 or hashed SubPlan 2), source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_code_1.version_id, news_version_code_1.code_id, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile, news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name, news_group_1.news_id, news_group_1.group_id, user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Hash Cond: (news.id = news_group_1.news_id)
  • Buffers: shared hit=56312
3. 9.672 554.758 ↑ 14.1 31 1

Hash Right Join (cost=65,752.51..74,771.55 rows=436 width=14,048) (actual time=554.713..554.758 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile, news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile, user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Hash Cond: (news_version_2.news_id = news.id)
  • Buffers: shared hit=56289
4. 35.729 183.757 ↓ 1.0 108,872 1

Hash Join (cost=18,936.61..25,786.38 rows=108,248 width=2,125) (actual time=62.516..183.757 rows=108,872 loops=1)

  • Output: news_version_2.news_id, user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Inner Unique: true
  • Hash Cond: (news_version_event_1.user_id = user_5.id)
  • Buffers: shared hit=18564
5. 40.207 147.417 ↓ 1.0 108,872 1

Hash Join (cost=18,884.37..25,448.92 rows=108,248 width=8) (actual time=61.888..147.417 rows=108,872 loops=1)

  • Output: news_version_event_1.user_id, news_version_2.news_id
  • Inner Unique: true
  • Hash Cond: (news_version_event_1.version_id = news_version_2.id)
  • Buffers: shared hit=18537
6. 45.526 45.526 ↓ 1.0 108,872 1

Seq Scan on base.news_version_event news_version_event_1 (cost=0.00..6,280.39 rows=108,248 width=8) (actual time=0.030..45.526 rows=108,872 loops=1)

  • Output: news_version_event_1.version_id, news_version_event_1.user_id
  • Filter: (news_version_event_1.type_id = 8)
  • Rows Removed by Filter: 221930
  • Buffers: shared hit=2143
7. 27.156 61.684 ↑ 1.0 110,674 1

Hash (cost=17,500.83..17,500.83 rows=110,683 width=8) (actual time=61.683..61.684 rows=110,674 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buckets: 131072 Batches: 1 Memory Usage: 5348kB
  • Buffers: shared hit=16394
8. 34.528 34.528 ↑ 1.0 110,674 1

Seq Scan on base.news_version news_version_2 (cost=0.00..17,500.83 rows=110,683 width=8) (actual time=0.012..34.528 rows=110,674 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buffers: shared hit=16394
9. 0.327 0.611 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.611..0.611 rows=1,122 loops=1)

  • Output: user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=27
10. 0.284 0.284 ↑ 1.0 1,122 1

Seq Scan on base."user" user_5 (cost=0.00..38.22 rows=1,122 width=2,121) (actual time=0.011..0.284 rows=1,122 loops=1)

  • Output: user_5.created_at, user_5.id, user_5.asoi_id, user_5.asoi_mailbox_id, user_5.is_blocked, user_5.asoi_name, user_5.signature, user_5.password_hash, user_5.email, user_5.last_name, user_5.first_name, user_5.patronymic, user_5.phone, user_5.description, user_5.profile
  • Buffers: shared hit=27
11. 0.063 361.329 ↑ 14.1 31 1

Hash (cost=46,810.45..46,810.45 rows=436 width=11,927) (actual time=361.329..361.329 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile, news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
  • Buffers: shared hit=37725
12. 0.119 361.266 ↑ 14.1 31 1

Merge Left Join (cost=46,801.08..46,810.45 rows=436 width=11,927) (actual time=361.206..361.266 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile, news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Merge Cond: (news.id = news_user_1.news_id)
  • Buffers: shared hit=37725
13. 0.082 359.592 ↑ 12.8 31 1

Sort (cost=46,708.50..46,709.50 rows=398 width=9,795) (actual time=359.590..359.592 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Sort Key: news.id
  • Sort Method: quicksort Memory: 63kB
  • Buffers: shared hit=37694
14. 0.050 359.510 ↑ 12.8 31 1

Nested Loop Left Join (cost=46,266.37..46,691.32 rows=398 width=9,795) (actual time=359.189..359.510 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Buffers: shared hit=37694
15. 0.040 359.398 ↑ 2.4 31 1

Nested Loop Left Join (cost=46,265.66..46,418.42 rows=75 width=9,641) (actual time=359.171..359.398 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Buffers: shared hit=37601
16. 0.025 359.203 ↑ 1.0 31 1

Nested Loop Left Join (cost=46,264.96..46,308.76 rows=31 width=7,511) (actual time=359.139..359.203 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_id, user_2.is_blocked, user_2.asoi_name, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile
  • Inner Unique: true
  • Buffers: shared hit=37384
17. 0.045 359.147 ↑ 1.0 31 1

Hash Right Join (cost=46,264.69..46,267.61 rows=31 width=5,390) (actual time=359.122..359.147 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Hash Cond: (newsbreak_user_1.newsbreak_id = newsbreak_1.id)
  • Buffers: shared hit=37363
18. 0.045 0.727 ↑ 1.1 63 1

Hash Join (cost=52.24..54.13 rows=70 width=2,133) (actual time=0.695..0.727 rows=63 loops=1)

  • Output: newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile
  • Inner Unique: true
  • Hash Cond: (newsbreak_user_1.user_id = user_1.id)
  • Buffers: shared hit=28
19. 0.031 0.031 ↑ 1.1 63 1

Seq Scan on base.newsbreak_user newsbreak_user_1 (cost=0.00..1.70 rows=70 width=12) (actual time=0.022..0.031 rows=63 loops=1)

  • Output: newsbreak_user_1.newsbreak_id, newsbreak_user_1.user_id, newsbreak_user_1.status_id, newsbreak_user_1.is_read, newsbreak_user_1.is_forwarded_by
  • Buffers: shared hit=1
20. 0.312 0.651 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.651..0.651 rows=1,122 loops=1)

  • Output: user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=27
21. 0.339 0.339 ↑ 1.0 1,122 1

Seq Scan on base."user" user_1 (cost=0.00..38.22 rows=1,122 width=2,121) (actual time=0.021..0.339 rows=1,122 loops=1)

  • Output: user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_id, user_1.is_blocked, user_1.asoi_name, user_1.signature, user_1.password_hash, user_1.email, user_1.last_name, user_1.first_name, user_1.patronymic, user_1.phone, user_1.description, user_1.profile
  • Buffers: shared hit=27
22. 0.026 358.375 ↑ 1.0 31 1

Hash (cost=46,212.05..46,212.05 rows=31 width=3,257) (actual time=358.375..358.375 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=37335
23. 0.029 358.349 ↑ 1.0 31 1

Merge Left Join (cost=46,211.37..46,212.05 rows=31 width=3,257) (actual time=358.328..358.349 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Merge Cond: (newsbreak_1.id = newsbreak_group_1.newsbreak_id)
  • Buffers: shared hit=37335
24. 0.027 358.320 ↑ 1.0 31 1

Sort (cost=46,206.73..46,206.81 rows=31 width=3,201) (actual time=358.317..358.320 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Sort Key: newsbreak_1.id
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=37335
25. 0.045 358.293 ↑ 1.0 31 1

Hash Left Join (cost=46,201.91..46,205.96 rows=31 width=3,201) (actual time=349.889..358.293 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Hash Cond: (news.newsbreak_id = newsbreak_1.id)
  • Buffers: shared hit=37335
26. 0.013 357.979 ↑ 1.0 31 1

Limit (cost=46,087.99..46,091.61 rows=31 width=1,561) (actual time=349.589..357.979 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Buffers: shared hit=37212
27. 0.000 357.966 ↑ 54.1 31 1

Gather Merge (cost=46,087.99..46,283.77 rows=1,678 width=1,561) (actual time=349.588..357.966 rows=31 loops=1)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=37212
28. 2.166 1,025.073 ↑ 35.0 24 3

Sort (cost=45,087.97..45,090.07 rows=839 width=1,561) (actual time=341.688..341.691 rows=24 loops=3)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Sort Key: news.status_modified_at DESC
  • Sort Method: top-N heapsort Memory: 39kB
  • Worker 0: Sort Method: top-N heapsort Memory: 38kB
  • Worker 1: Sort Method: top-N heapsort Memory: 38kB
  • Buffers: shared hit=37212
  • Worker 0: actual time=338.151..338.155 rows=31 loops=1
  • Buffers: shared hit=10962
  • Worker 1: actual time=338.581..338.584 rows=31 loops=1
  • Buffers: shared hit=11867
29. 155.997 1,022.907 ↑ 3.5 241 3

Parallel Hash Left Join (cost=25,706.71..45,062.99 rows=839 width=1,561) (actual time=218.924..340.969 rows=241 loops=3)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Hash Cond: (news_version_1.id = news_version_author.version_id)
  • Filter: ((news_version_1.user_id = 1081) OR ((news_version.user_id = 1081) AND (news_version_1.status_id <> ALL ('{1,3}'::integer[]))) OR ((news_version_author.user_id = 1081) AND (news_version_1.status_id <> 1)))
  • Rows Removed by Filter: 83466
  • Buffers: shared hit=37196
  • Worker 0: actual time=215.569..337.199 rows=247 loops=1
  • Buffers: shared hit=10954
  • Worker 1: actual time=215.759..337.837 rows=219 loops=1
  • Buffers: shared hit=11859
30. 126.738 712.878 ↑ 1.3 36,891 3

Parallel Hash Join (cost=20,990.91..38,211.19 rows=46,118 width=1,565) (actual time=166.122..237.626 rows=36,891 loops=3)

  • Output: news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background, news_version.user_id
  • Hash Cond: (news_version_1.id = news.version_id)
  • Buffers: shared hit=35722
  • Worker 0: actual time=166.134..238.478 rows=33911 loops=1
  • Buffers: shared hit=10475
  • Worker 1: actual time=166.067..237.167 rows=33720 loops=1
  • Buffers: shared hit=11434
31. 93.285 93.285 ↑ 1.3 36,891 3

Parallel Seq Scan on base.news_version news_version_1 (cost=0.00..16,855.18 rows=46,118 width=1,524) (actual time=0.016..31.095 rows=36,891 loops=3)

  • Output: news_version_1.created_at, news_version_1.id, news_version_1.news_id, news_version_1.number, news_version_1.user_id, news_version_1.status_id, news_version_1.type_id, news_version_1.language_id, news_version_1.slugline, news_version_1.header, news_version_1.trashline, news_version_1.dateline, news_version_1.body, news_version_1.background
  • Buffers: shared hit=16394
  • Worker 0: actual time=0.010..29.494 rows=33865 loops=1
  • Buffers: shared hit=4997
  • Worker 1: actual time=0.010..32.647 rows=33739 loops=1
  • Buffers: shared hit=4990
32. 99.273 492.855 ↑ 1.3 36,891 3

Parallel Hash (cost=20,414.43..20,414.43 rows=46,118 width=41) (actual time=164.285..164.285 rows=36,891 loops=3)

  • Output: news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, news_version.user_id
  • Buckets: 131072 Batches: 1 Memory Usage: 8896kB
  • Buffers: shared hit=19328
  • Worker 0: actual time=165.948..165.948 rows=30125 loops=1
  • Buffers: shared hit=5478
  • Worker 1: actual time=165.965..165.966 rows=36404 loops=1
  • Buffers: shared hit=6444
33. 80.469 393.582 ↑ 1.3 36,891 3

Hash Join (cost=3,438.20..20,414.43 rows=46,118 width=41) (actual time=86.795..131.194 rows=36,891 loops=3)

  • Output: news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi, news_version.user_id
  • Inner Unique: true
  • Hash Cond: (news_version.news_id = news.id)
  • Buffers: shared hit=19328
  • Worker 0: actual time=98.289..135.958 rows=30125 loops=1
  • Buffers: shared hit=5478
  • Worker 1: actual time=87.964..132.156 rows=36404 loops=1
  • Buffers: shared hit=6444
34. 59.754 59.754 ↑ 1.3 36,891 3

Parallel Seq Scan on base.news_version (cost=0.00..16,855.18 rows=46,118 width=8) (actual time=0.020..19.918 rows=36,891 loops=3)

  • Output: news_version.news_id, news_version.user_id
  • Buffers: shared hit=16394
  • Worker 0: actual time=0.017..17.329 rows=30125 loops=1
  • Buffers: shared hit=4500
  • Worker 1: actual time=0.032..20.143 rows=36404 loops=1
  • Buffers: shared hit=5466
35. 156.609 253.359 ↓ 1.0 109,433 3

Hash (cost=2,071.42..2,071.42 rows=109,342 width=37) (actual time=84.452..84.453 rows=109,433 loops=3)

  • Output: news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Buckets: 131072 Batches: 1 Memory Usage: 7542kB
  • Buffers: shared hit=2934
  • Worker 0: actual time=95.166..95.166 rows=109433 loops=1
  • Buffers: shared hit=978
  • Worker 1: actual time=84.392..84.392 rows=109433 loops=1
  • Buffers: shared hit=978
36. 96.750 96.750 ↓ 1.0 109,433 3

Seq Scan on base.news (cost=0.00..2,071.42 rows=109,342 width=37) (actual time=0.036..32.250 rows=109,433 loops=3)

  • Output: news.created_at, news.status_modified_at, news.id, news.parent_id, news.newsbreak_id, news.version_id, news.asoi_id, news.is_from_asoi
  • Buffers: shared hit=2934
  • Worker 0: actual time=0.029..32.794 rows=109433 loops=1
  • Buffers: shared hit=978
  • Worker 1: actual time=0.059..28.568 rows=109433 loops=1
  • Buffers: shared hit=978
37. 109.533 154.032 ↑ 1.8 83,707 3

Parallel Hash (cost=2,867.02..2,867.02 rows=147,902 width=8) (actual time=51.344..51.344 rows=83,707 loops=3)

  • Output: news_version_author.version_id, news_version_author.user_id
  • Buckets: 262144 Batches: 1 Memory Usage: 11904kB
  • Buffers: shared hit=1388
  • Worker 0: actual time=48.967..48.967 rows=78432 loops=1
  • Buffers: shared hit=436
  • Worker 1: actual time=49.344..49.344 rows=69514 loops=1
  • Buffers: shared hit=382
38. 44.499 44.499 ↑ 1.8 83,707 3

Parallel Seq Scan on base.news_version_author (cost=0.00..2,867.02 rows=147,902 width=8) (actual time=0.015..14.833 rows=83,707 loops=3)

  • Output: news_version_author.version_id, news_version_author.user_id
  • Buffers: shared hit=1388
  • Worker 0: actual time=0.015..13.583 rows=78432 loops=1
  • Buffers: shared hit=436
  • Worker 1: actual time=0.017..14.455 rows=69514 loops=1
  • Buffers: shared hit=382
39. 0.038 0.269 ↑ 1.2 23 1

Hash (cost=113.57..113.57 rows=28 width=1,640) (actual time=0.269..0.269 rows=23 loops=1)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
  • Buffers: shared hit=123
40. 0.030 0.231 ↑ 1.2 23 1

Hash Join (cost=2.21..113.57 rows=28 width=1,640) (actual time=0.105..0.231 rows=23 loops=1)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Hash Cond: (lead_1.id = newsbreak_1.lead_id)
  • Buffers: shared hit=123
41. 0.021 0.182 ↑ 1.2 20 1

Nested Loop Left Join (cost=0.57..111.50 rows=25 width=1,231) (actual time=0.070..0.182 rows=20 loops=1)

  • Output: lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url, source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Inner Unique: true
  • Buffers: shared hit=122
42. 0.023 0.121 ↑ 1.2 20 1

Nested Loop (cost=0.29..58.88 rows=25 width=1,157) (actual time=0.051..0.121 rows=20 loops=1)

  • Output: lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.header, lead_1.body, lead_1.diff, source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url
  • Inner Unique: true
  • Buffers: shared hit=65
43. 0.018 0.018 ↑ 1.2 20 1

Seq Scan on base.lead lead_1 (cost=0.00..5.25 rows=25 width=1,037) (actual time=0.011..0.018 rows=20 loops=1)

  • Output: lead_1.id, lead_1.created_at, lead_1.source_id, lead_1.web_block_id, lead_1.body_hash, lead_1.url, lead_1.web_block_xpath, lead_1.body, lead_1.header, lead_1.diff
  • Buffers: shared hit=5
44. 0.080 0.080 ↑ 1.0 1 20

Index Scan using source_pkey on base.source source_1 (cost=0.29..2.14 rows=1 width=120) (actual time=0.004..0.004 rows=1 loops=20)

  • Output: source_1.modified_at, source_1.id, source_1."interval", source_1.parent_id, source_1.type_id, source_1.timeout, source_1.dynamic_waiting_time, source_1.is_deleted, source_1.uses_proxy, source_1.is_dynamic, source_1.name, source_1.user_agent, source_1.url
  • Index Cond: (source_1.id = lead_1.source_id)
  • Buffers: shared hit=60
45. 0.040 0.040 ↑ 1.0 1 20

Index Scan using source_web_block_pkey on base.source_web_block source_web_block_1 (cost=0.29..2.10 rows=1 width=74) (actual time=0.002..0.002 rows=1 loops=20)

  • Output: source_web_block_1.id, source_web_block_1.source_id, source_web_block_1.is_deleted, source_web_block_1.is_excluded, source_web_block_1.name, source_web_block_1.xpath
  • Index Cond: (source_web_block_1.id = lead_1.web_block_id)
  • Buffers: shared hit=57
46. 0.008 0.019 ↑ 1.2 23 1

Hash (cost=1.28..1.28 rows=28 width=409) (actual time=0.019..0.019 rows=23 loops=1)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
47. 0.011 0.011 ↑ 1.2 23 1

Seq Scan on base.newsbreak newsbreak_1 (cost=0.00..1.28 rows=28 width=409) (actual time=0.009..0.011 rows=23 loops=1)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment
  • Buffers: shared hit=1
48. 0.000 0.000 ↓ 0.0 0

Sort (cost=4.64..4.72 rows=32 width=56) (never executed)

  • Output: newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name
  • Sort Key: newsbreak_group_1.newsbreak_id
49. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.44..3.84 rows=32 width=56) (never executed)

  • Output: newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name
  • Inner Unique: true
  • Hash Cond: (newsbreak_group_1.group_id = group_1.id)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on base.newsbreak_group newsbreak_group_1 (cost=0.00..1.32 rows=32 width=11) (never executed)

  • Output: newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read
51. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.64..1.64 rows=64 width=45) (never executed)

  • Output: group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on base."group" group_1 (cost=0.00..1.64 rows=64 width=45) (never executed)

  • Output: group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name
53. 0.031 0.031 ↓ 0.0 0 31

Index Scan using user_pkey on base."user" user_2 (cost=0.28..1.33 rows=1 width=2,121) (actual time=0.001..0.001 rows=0 loops=31)

  • Output: user_2.created_at, user_2.id, user_2.asoi_id, user_2.is_blocked, user_2.signature, user_2.password_hash, user_2.email, user_2.last_name, user_2.first_name, user_2.patronymic, user_2.phone, user_2.description, user_2.profile, user_2.asoi_mailbox_id, user_2.asoi_name
  • Index Cond: (user_2.id = news_version_1.user_id)
  • Buffers: shared hit=21
54. 0.031 0.155 ↑ 2.0 1 31

Nested Loop (cost=0.70..3.52 rows=2 width=2,130) (actual time=0.005..0.005 rows=1 loops=31)

  • Output: news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable, user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_id, user_3.is_blocked, user_3.asoi_name, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile
  • Inner Unique: true
  • Buffers: shared hit=217
55. 0.093 0.093 ↑ 2.0 1 31

Index Scan using news_version_author_pkey on base.news_version_author news_version_author_1 (cost=0.42..2.93 rows=2 width=9) (actual time=0.003..0.003 rows=1 loops=31)

  • Output: news_version_author_1.version_id, news_version_author_1.user_id, news_version_author_1.is_removable
  • Index Cond: (news_version_1.id = news_version_author_1.version_id)
  • Buffers: shared hit=124
56. 0.031 0.031 ↑ 1.0 1 31

Index Scan using user_pkey on base."user" user_3 (cost=0.28..0.30 rows=1 width=2,121) (actual time=0.001..0.001 rows=1 loops=31)

  • Output: user_3.created_at, user_3.id, user_3.asoi_id, user_3.is_blocked, user_3.signature, user_3.password_hash, user_3.email, user_3.last_name, user_3.first_name, user_3.patronymic, user_3.phone, user_3.description, user_3.profile, user_3.asoi_mailbox_id, user_3.asoi_name
  • Index Cond: (user_3.id = news_version_author_1.user_id)
  • Buffers: shared hit=93
57. 0.000 0.062 ↓ 0.0 0 31

Nested Loop (cost=0.70..3.59 rows=5 width=154) (actual time=0.002..0.002 rows=0 loops=31)

  • Output: news_version_code_1.version_id, news_version_code_1.code_id, code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description
  • Inner Unique: true
  • Buffers: shared hit=93
58. 0.062 0.062 ↓ 0.0 0 31

Index Only Scan using news_version_code_pkey on base.news_version_code news_version_code_1 (cost=0.42..2.09 rows=5 width=8) (actual time=0.002..0.002 rows=0 loops=31)

  • Output: news_version_code_1.version_id, news_version_code_1.code_id
  • Index Cond: (news_version_code_1.version_id = news_version_1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=93
59. 0.000 0.000 ↓ 0.0 0

Index Scan using code_pkey on base.code code_1 (cost=0.28..0.30 rows=1 width=146) (never executed)

  • Output: code_1.id, code_1.is_en, code_1.is_old, code_1.path, code_1.name_ru, code_1.name_en, code_1.description
  • Index Cond: (code_1.id = news_version_code_1.code_id)
60. 0.576 1.555 ↓ 1.0 628 1

Sort (cost=92.57..94.11 rows=616 width=2,132) (actual time=1.516..1.555 rows=628 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile
  • Sort Key: news_user_1.news_id
  • Sort Method: quicksort Memory: 688kB
  • Buffers: shared hit=31
61. 0.258 0.979 ↓ 1.0 617 1

Hash Join (cost=52.24..64.03 rows=616 width=2,132) (actual time=0.632..0.979 rows=617 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile
  • Inner Unique: true
  • Hash Cond: (news_user_1.user_id = user_4.id)
  • Buffers: shared hit=31
62. 0.120 0.120 ↓ 1.0 617 1

Seq Scan on base.news_user news_user_1 (cost=0.00..10.16 rows=616 width=11) (actual time=0.013..0.120 rows=617 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_id, news_user_1.type_id, news_user_1.is_read
  • Buffers: shared hit=4
63. 0.333 0.601 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.601..0.601 rows=1,122 loops=1)

  • Output: user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=27
64. 0.268 0.268 ↑ 1.0 1,122 1

Seq Scan on base."user" user_4 (cost=0.00..38.22 rows=1,122 width=2,121) (actual time=0.008..0.268 rows=1,122 loops=1)

  • Output: user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, user_4.asoi_name, user_4.signature, user_4.password_hash, user_4.email, user_4.last_name, user_4.first_name, user_4.patronymic, user_4.phone, user_4.description, user_4.profile
  • Buffers: shared hit=27
65. 0.068 0.252 ↓ 1.0 299 1

Hash (cost=8.25..8.25 rows=297 width=53) (actual time=0.252..0.252 rows=299 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id, group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name
  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
  • Buffers: shared hit=3
66. 0.098 0.184 ↓ 1.0 299 1

Hash Join (cost=2.44..8.25 rows=297 width=53) (actual time=0.068..0.184 rows=299 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id, group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name
  • Inner Unique: true
  • Hash Cond: (news_group_1.group_id = group_2.id)
  • Buffers: shared hit=3
67. 0.045 0.045 ↓ 1.0 299 1

Seq Scan on base.news_group news_group_1 (cost=0.00..4.97 rows=297 width=8) (actual time=0.018..0.045 rows=299 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id
  • Buffers: shared hit=2
68. 0.020 0.041 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=45) (actual time=0.041..0.041 rows=64 loops=1)

  • Output: group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name
  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=1
69. 0.021 0.021 ↑ 1.0 64 1

Seq Scan on base."group" group_2 (cost=0.00..1.64 rows=64 width=45) (actual time=0.009..0.021 rows=64 loops=1)

  • Output: group_2.id, group_2.asoi_id, group_2.asoi_mailbox_id, group_2.code, group_2.name
  • Buffers: shared hit=1
70.          

SubPlan (forHash Left Join)

71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using lead_event_lead_id_user_id_type_id_key on base.lead_event (cost=0.28..1.30 rows=1 width=0) (never executed)

  • Index Cond: ((lead_event.lead_id = lead_1.id) AND (lead_event.user_id = 1081))
  • Heap Fetches: 0
72. 0.084 0.084 ↓ 0.0 0 1

Index Only Scan using lead_event_lead_id_user_id_type_id_key on base.lead_event lead_event_1 (cost=0.28..42.81 rows=1 width=16) (actual time=0.084..0.084 rows=0 loops=1)

  • Output: lead_event_1.lead_id
  • Index Cond: (lead_event_1.user_id = 1081)
  • Heap Fetches: 0
  • Buffers: shared hit=20