explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VUq8

Settings
# exclusive inclusive rows x rows loops node
1. 0.137 567.160 ↑ 14.1 31 1

Sort (cost=74,169.85..74,170.94 rows=436 width=14,101) (actual time=567.158..567.160 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=55435
2. 0.065 567.023 ↑ 14.1 31 1

Hash Left Join (cost=64,700.44..74,150.74 rows=436 width=14,101) (actual time=566.952..567.023 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=55435
3. 10.018 566.579 ↑ 14.1 31 1

Hash Right Join (cost=64,688.49..73,565.98 rows=436 width=14,047) (actual time=566.534..566.579 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=55412
4. 35.673 186.364 ↓ 1.0 107,178 1

Hash Join (cost=18,634.71..25,374.40 rows=106,675 width=2,125) (actual time=67.407..186.364 rows=107,178 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=18257
5. 39.521 150.058 ↓ 1.0 107,178 1

Hash Join (cost=18,582.47..25,041.08 rows=106,675 width=8) (actual time=66.760..150.058 rows=107,178 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=18230
6. 44.490 44.490 ↓ 1.0 107,178 1

Seq Scan on base.news_version_event news_version_event_1 (cost=0.00..6,178.58 rows=106,675 width=8) (actual time=0.028..44.490 rows=107,178 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: 218542
  • Buffers: shared hit=2101
7. 28.266 66.047 ↑ 1.0 108,980 1

Hash (cost=17,219.43..17,219.43 rows=109,043 width=8) (actual time=66.046..66.047 rows=108,980 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buckets: 131072 Batches: 1 Memory Usage: 5282kB
  • Buffers: shared hit=16129
8. 37.781 37.781 ↑ 1.0 108,980 1

Seq Scan on base.news_version news_version_2 (cost=0.00..17,219.43 rows=109,043 width=8) (actual time=0.012..37.781 rows=108,980 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buffers: shared hit=16129
9. 0.347 0.633 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.633..0.633 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.286 0.286 ↑ 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.286 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.085 370.197 ↑ 14.1 31 1

Hash (cost=46,048.32..46,048.32 rows=436 width=11,926) (actual time=370.197..370.197 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=37155
12. 0.059 370.112 ↑ 14.1 31 1

Hash Left Join (cost=45,619.95..46,048.32 rows=436 width=11,926) (actual time=369.702..370.112 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
  • Hash Cond: (news.id = news_user_1.news_id)
  • Buffers: shared hit=37155
13. 0.051 368.418 ↑ 12.8 31 1

Nested Loop Left Join (cost=45,548.21..45,969.80 rows=398 width=9,794) (actual time=368.047..368.418 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=37124
14. 0.023 368.305 ↑ 2.4 31 1

Nested Loop Left Join (cost=45,547.51..45,700.35 rows=75 width=9,640) (actual time=368.023..368.305 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=37031
15. 0.047 368.065 ↑ 1.0 31 1

Nested Loop Left Join (cost=45,546.81..45,590.61 rows=31 width=7,510) (actual time=367.981..368.065 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=36814
16. 0.062 367.987 ↑ 1.0 31 1

Hash Right Join (cost=45,546.53..45,549.46 rows=31 width=5,389) (actual time=367.961..367.987 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=36793
17. 0.046 1.073 ↑ 1.1 63 1

Hash Join (cost=52.24..54.13 rows=70 width=2,133) (actual time=1.040..1.073 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
18. 0.032 0.032 ↑ 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.023..0.032 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
19. 0.530 0.995 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.995..0.995 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
20. 0.465 0.465 ↑ 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.014..0.465 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
21. 0.057 366.852 ↑ 1.0 31 1

Hash (cost=45,493.90..45,493.90 rows=31 width=3,256) (actual time=366.852..366.852 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=36765
22. 0.044 366.795 ↑ 1.0 31 1

Merge Left Join (cost=45,493.22..45,493.90 rows=31 width=3,256) (actual time=366.759..366.795 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=36765
23. 0.032 366.751 ↑ 1.0 31 1

Sort (cost=45,488.58..45,488.66 rows=31 width=3,200) (actual time=366.745..366.751 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=36765
24. 0.055 366.719 ↑ 1.0 31 1

Hash Left Join (cost=45,483.76..45,487.81 rows=31 width=3,200) (actual time=356.281..366.719 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=36765
25. 0.013 366.386 ↑ 1.0 31 1

Limit (cost=45,369.84..45,373.46 rows=31 width=1,560) (actual time=355.963..366.386 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=36642
26. 0.000 366.373 ↑ 54.4 31 1

Gather Merge (cost=45,369.84..45,566.55 rows=1,686 width=1,560) (actual time=355.962..366.373 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=36642
27. 14.127 1,034.460 ↑ 32.4 26 3

Sort (cost=44,369.82..44,371.92 rows=843 width=1,560) (actual time=344.817..344.820 rows=26 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: 39kB
  • Worker 1: Sort Method: top-N heapsort Memory: 39kB
  • Buffers: shared hit=36642
  • Worker 0: actual time=340.981..340.987 rows=31 loops=1
  • Buffers: shared hit=8604
  • Worker 1: actual time=339.636..339.640 rows=31 loops=1
  • Buffers: shared hit=13679
28. 145.860 1,020.333 ↑ 3.5 241 3

Parallel Hash Left Join (cost=25,296.60..44,344.72 rows=843 width=1,560) (actual time=230.017..340.111 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: 82192
  • Buffers: shared hit=36626
  • Worker 0: actual time=226.165..334.202 rows=151 loops=1
  • Buffers: shared hit=8596
  • Worker 1: actual time=224.730..332.749 rows=303 loops=1
  • Buffers: shared hit=13671
29. 118.965 687.114 ↑ 1.3 36,327 3

Parallel Hash Join (cost=20,656.39..37,599.43 rows=45,435 width=1,564) (actual time=163.591..229.038 rows=36,327 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=35180
  • Worker 0: actual time=163.590..227.462 rows=22699 loops=1
  • Buffers: shared hit=8042
  • Worker 1: actual time=163.595..226.112 rows=42108 loops=1
  • Buffers: shared hit=13248
30. 81.837 81.837 ↑ 1.3 36,327 3

Parallel Seq Scan on base.news_version news_version_1 (cost=0.00..16,583.35 rows=45,435 width=1,523) (actual time=0.010..27.279 rows=36,327 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=16129
  • Worker 0: actual time=0.011..26.603 rows=22712 loops=1
  • Buffers: shared hit=3381
  • Worker 1: actual time=0.011..27.823 rows=42058 loops=1
  • Buffers: shared hit=6234
31. 97.011 486.312 ↑ 1.3 36,327 3

Parallel Hash (cost=20,088.46..20,088.46 rows=45,435 width=41) (actual time=162.104..162.104 rows=36,327 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: 8768kB
  • Buffers: shared hit=19051
  • Worker 0: actual time=163.451..163.452 rows=24207 loops=1
  • Buffers: shared hit=4661
  • Worker 1: actual time=163.283..163.283 rows=41151 loops=1
  • Buffers: shared hit=7014
32. 75.381 389.301 ↑ 1.3 36,327 3

Hash Join (cost=3,385.84..20,088.46 rows=45,435 width=41) (actual time=89.495..129.767 rows=36,327 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=19051
  • Worker 0: actual time=107.235..136.277 rows=24207 loops=1
  • Buffers: shared hit=4661
  • Worker 1: actual time=82.408..126.763 rows=41151 loops=1
  • Buffers: shared hit=7014
33. 53.946 53.946 ↑ 1.3 36,327 3

Parallel Seq Scan on base.news_version (cost=0.00..16,583.35 rows=45,435 width=8) (actual time=0.015..17.982 rows=36,327 loops=3)

  • Output: news_version.news_id, news_version.user_id
  • Buffers: shared hit=16129
  • Worker 0: actual time=0.019..13.924 rows=24207 loops=1
  • Buffers: shared hit=3687
  • Worker 1: actual time=0.011..19.839 rows=41151 loops=1
  • Buffers: shared hit=6040
34. 161.769 259.974 ↓ 1.0 107,739 3

Hash (cost=2,045.93..2,045.93 rows=107,193 width=37) (actual time=86.657..86.658 rows=107,739 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: 7441kB
  • Buffers: shared hit=2922
  • Worker 0: actual time=103.223..103.223 rows=107739 loops=1
  • Buffers: shared hit=974
  • Worker 1: actual time=79.093..79.094 rows=107739 loops=1
  • Buffers: shared hit=974
35. 98.205 98.205 ↓ 1.0 107,739 3

Seq Scan on base.news (cost=0.00..2,045.93 rows=107,193 width=37) (actual time=0.046..32.735 rows=107,739 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=2922
  • Worker 0: actual time=0.060..35.961 rows=107739 loops=1
  • Buffers: shared hit=974
  • Worker 1: actual time=0.049..27.446 rows=107739 loops=1
  • Buffers: shared hit=974
36. 130.728 187.359 ↑ 1.8 82,433 3

Parallel Hash (cost=2,817.87..2,817.87 rows=145,787 width=8) (actual time=62.453..62.453 rows=82,433 loops=3)

  • Output: news_version_author.version_id, news_version_author.user_id
  • Buckets: 262144 Batches: 1 Memory Usage: 11776kB
  • Buffers: shared hit=1360
  • Worker 0: actual time=62.243..62.243 rows=92859 loops=1
  • Buffers: shared hit=511
  • Worker 1: actual time=60.592..60.592 rows=69131 loops=1
  • Buffers: shared hit=380
37. 56.631 56.631 ↑ 1.8 82,433 3

Parallel Seq Scan on base.news_version_author (cost=0.00..2,817.87 rows=145,787 width=8) (actual time=0.024..18.877 rows=82,433 loops=3)

  • Output: news_version_author.version_id, news_version_author.user_id
  • Buffers: shared hit=1360
  • Worker 0: actual time=0.021..18.858 rows=92859 loops=1
  • Buffers: shared hit=511
  • Worker 1: actual time=0.033..17.708 rows=69131 loops=1
  • Buffers: shared hit=380
38. 0.059 0.278 ↑ 1.2 23 1

Hash (cost=113.57..113.57 rows=28 width=1,640) (actual time=0.278..0.278 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
39. 0.032 0.219 ↑ 1.2 23 1

Hash Join (cost=2.21..113.57 rows=28 width=1,640) (actual time=0.087..0.219 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
40. 0.015 0.168 ↑ 1.2 20 1

Nested Loop Left Join (cost=0.57..111.50 rows=25 width=1,231) (actual time=0.049..0.168 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
41. 0.035 0.113 ↑ 1.2 20 1

Nested Loop (cost=0.29..58.88 rows=25 width=1,157) (actual time=0.037..0.113 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
42. 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.010..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
43. 0.060 0.060 ↑ 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.003..0.003 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
44. 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
45. 0.007 0.019 ↑ 1.2 23 1

Hash (cost=1.28..1.28 rows=28 width=409) (actual time=0.018..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
46. 0.012 0.012 ↑ 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.012 rows=23 loops=1)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment
  • Buffers: shared hit=1
47. 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
48. 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)
49. 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
50. 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
51. 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
52. 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
53. 0.062 0.217 ↑ 2.0 1 31

Nested Loop (cost=0.70..3.52 rows=2 width=2,130) (actual time=0.006..0.007 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
54. 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
55. 0.062 0.062 ↑ 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.002..0.002 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
56. 0.000 0.062 ↓ 0.0 0 31

Nested Loop (cost=0.70..3.54 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
57. 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.04 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
58. 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)
59. 0.572 1.635 ↓ 1.0 617 1

Hash (cost=64.03..64.03 rows=616 width=2,132) (actual time=1.635..1.635 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
  • Buckets: 1024 Batches: 1 Memory Usage: 510kB
  • Buffers: shared hit=31
60. 0.291 1.063 ↓ 1.0 617 1

Hash Join (cost=52.24..64.03 rows=616 width=2,132) (actual time=0.659..1.063 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
61. 0.140 0.140 ↓ 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.012..0.140 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
62. 0.347 0.632 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.632..0.632 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
63. 0.285 0.285 ↑ 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.285 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
64. 0.068 0.276 ↓ 1.0 299 1

Hash (cost=8.25..8.25 rows=297 width=53) (actual time=0.276..0.276 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
65. 0.120 0.208 ↓ 1.0 299 1

Hash Join (cost=2.44..8.25 rows=297 width=53) (actual time=0.090..0.208 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
66. 0.047 0.047 ↓ 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.019..0.047 rows=299 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id
  • Buffers: shared hit=2
67. 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
68. 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
69.          

SubPlan (forHash Left Join)

70. 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
71. 0.103 0.103 ↓ 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.103..0.103 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
Planning time : 6.690 ms
Execution time : 568.307 ms