explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sPWs

Settings
# exclusive inclusive rows x rows loops node
1. 0.152 406.143 ↑ 39.8 31 1

Sort (cost=122,896.54..122,899.63 rows=1,235 width=14,110) (actual time=406.140..406.143 rows=31 loops=1)

  • Output: _news_version.created_at, news_version_1.id, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.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 3 or hashed SubPlan 4)), 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, _news.status_modified_at
  • 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: 68kB
  • Buffers: shared hit=43937, temp read=535 written=903
2.          

CTE user_versions

3. 27.646 27.646 ↑ 1.0 289 1

Seq Scan on base.news_version (cost=0.00..17,788.38 rows=289 width=8) (actual time=0.007..27.646 rows=289 loops=1)

  • Output: news_version.id, news_version.news_id
  • Filter: (news_version.user_id = 1081)
  • Rows Removed by Filter: 110462
  • Buffers: shared hit=16404
4.          

CTE user_author_versions

5. 0.491 6.944 ↑ 1.5 466 1

Nested Loop (cost=0.71..3,888.33 rows=711 width=4) (actual time=0.108..6.944 rows=466 loops=1)

  • Output: news_version_3.id
  • Inner Unique: true
  • Buffers: shared hit=2971
6. 5.015 5.015 ↓ 1.0 719 1

Index Only Scan using news_version_author_pkey on base.news_version_author (cost=0.42..2,658.89 rows=715 width=4) (actual time=0.036..5.015 rows=719 loops=1)

  • Output: news_version_author.version_id, news_version_author.user_id
  • Index Cond: (news_version_author.user_id = 1081)
  • Heap Fetches: 398
  • Buffers: shared hit=812
7. 1.438 1.438 ↑ 1.0 1 719

Index Scan using news_version_pkey on base.news_version news_version_3 (cost=0.29..1.72 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=719)

  • Output: news_version_3.id
  • Index Cond: (news_version_3.id = news_version_author.version_id)
  • Filter: (news_version_3.status_id <> 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2159
8. 0.177 405.991 ↑ 39.8 31 1

Hash Left Join (cost=62,561.41..96,892.42 rows=1,235 width=14,110) (actual time=387.256..405.991 rows=31 loops=1)

  • Output: _news_version.created_at, news_version_1.id, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.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 3 or hashed SubPlan 4), 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, _news.status_modified_at
  • Hash Cond: (news.id = news_user_1.news_id)
  • Buffers: shared hit=43937, temp read=535 written=903
9. 0.143 402.395 ↑ 36.9 31 1

Hash Left Join (cost=62,489.68..95,195.70 rows=1,143 width=11,977) (actual time=383.723..402.395 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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, 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, 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, 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, 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
  • Hash Cond: (news.id = news_group_1.news_id)
  • Buffers: shared hit=43886, temp read=535 written=903
10. 18.518 401.731 ↑ 36.9 31 1

Hash Left Join (cost=62,477.72..95,168.02 rows=1,143 width=11,924) (actual time=383.113..401.731 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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, 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, 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, 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_version_2.news_id)
  • Buffers: shared hit=43883, temp read=535 written=903
11. 0.069 100.831 ↑ 36.9 31 1

Hash Left Join (cost=6,856.06..8,305.20 rows=1,143 width=9,803) (actual time=99.795..100.831 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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, 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, 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
  • Hash Cond: (newsbreak_1.id = newsbreak_group_1.newsbreak_id)
  • Buffers: shared hit=25307
12. 0.058 100.596 ↑ 32.3 31 1

Nested Loop Left Join (cost=6,851.82..8,284.52 rows=1,000 width=9,747) (actual time=99.606..100.596 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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, 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
  • Buffers: shared hit=25305
13. 0.063 100.445 ↑ 6.1 31 1

Nested Loop Left Join (cost=6,851.12..7,600.46 rows=188 width=9,593) (actual time=99.583..100.445 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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, 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
  • Buffers: shared hit=25212
14. 0.058 100.134 ↑ 2.5 31 1

Nested Loop Left Join (cost=6,850.42..7,324.55 rows=78 width=7,463) (actual time=99.550..100.134 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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=24994
15. 0.076 100.045 ↑ 2.5 31 1

Nested Loop Left Join (cost=6,850.14..7,301.51 rows=78 width=5,342) (actual time=99.510..100.045 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, 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=24979
16. 0.046 99.969 ↑ 2.5 31 1

Nested Loop Left Join (cost=6,849.85..7,137.32 rows=78 width=5,268) (actual time=99.473..99.969 rows=31 loops=1)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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, news_version_1.id, news.status_modified_at, news.id, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background
  • Buffers: shared hit=24979
17. 0.028 99.861 ↑ 1.0 31 1

Nested Loop (cost=6,848.87..6,989.89 rows=31 width=1,569) (actual time=99.454..99.861 rows=31 loops=1)

  • Output: news_version_1.id, news.status_modified_at, news.id, _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background
  • Inner Unique: true
  • Buffers: shared hit=24979
18. 0.085 99.709 ↑ 1.0 31 1

Nested Loop (cost=6,848.58..6,919.28 rows=31 width=49) (actual time=99.431..99.709 rows=31 loops=1)

  • Output: news_version_1.id, news.status_modified_at, news.id, _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at
  • Inner Unique: true
  • Buffers: shared hit=24886
19. 0.018 99.407 ↑ 1.0 31 1

Limit (cost=6,848.29..6,848.36 rows=31 width=16) (actual time=99.376..99.407 rows=31 loops=1)

  • Output: news_version_1.id, news.id, news.status_modified_at
  • Buffers: shared hit=24793
20. 0.099 99.389 ↑ 41.2 31 1

Sort (cost=6,848.29..6,851.48 rows=1,277 width=16) (actual time=99.374..99.389 rows=31 loops=1)

  • Output: news_version_1.id, news.id, news.status_modified_at
  • Sort Key: news.status_modified_at DESC
  • Sort Method: top-N heapsort Memory: 27kB
  • Buffers: shared hit=24793
21. 0.464 99.290 ↑ 5.0 257 1

HashAggregate (cost=6,797.50..6,810.27 rows=1,277 width=16) (actual time=99.195..99.290 rows=257 loops=1)

  • Output: news_version_1.id, news.id, news.status_modified_at
  • Group Key: news_version_1.id, news.id, news.status_modified_at
  • Buffers: shared hit=24793
22. 0.075 98.826 ↑ 2.6 494 1

Append (cost=370.98..6,787.92 rows=1,277 width=16) (actual time=28.893..98.826 rows=494 loops=1)

  • Buffers: shared hit=24793
23. 9.763 55.372 ↑ 6.4 45 1

Hash Join (cost=370.98..2,859.65 rows=286 width=16) (actual time=28.892..55.372 rows=45 loops=1)

  • Output: news_version_1.id, news.id, news.status_modified_at
  • Hash Cond: (news.version_id = news_version_1.id)
  • Buffers: shared hit=18044
24. 16.741 16.741 ↑ 1.0 109,510 1

Seq Scan on base.news (cost=0.00..2,074.86 rows=109,586 width=16) (actual time=0.013..16.741 rows=109,510 loops=1)

  • Output: news.id, news.status_modified_at, news.version_id
  • Buffers: shared hit=979
25. 0.122 28.868 ↑ 1.0 289 1

Hash (cost=367.37..367.37 rows=289 width=8) (actual time=28.867..28.868 rows=289 loops=1)

  • Output: news_version_1.id, u1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=17065
26. 0.381 28.746 ↑ 1.0 289 1

Nested Loop (cost=0.29..367.37 rows=289 width=8) (actual time=0.028..28.746 rows=289 loops=1)

  • Output: news_version_1.id, u1.id
  • Inner Unique: true
  • Buffers: shared hit=17065
27. 27.787 27.787 ↑ 1.0 289 1

CTE Scan on user_versions u1 (cost=0.00..5.78 rows=289 width=4) (actual time=0.010..27.787 rows=289 loops=1)

  • Output: u1.id, u1.news_id
  • Buffers: shared hit=16404
28. 0.578 0.578 ↑ 1.0 1 289

Index Only Scan using news_version_pkey on base.news_version news_version_1 (cost=0.29..1.25 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=289)

  • Output: news_version_1.id
  • Index Cond: (news_version_1.id = u1.id)
  • Heap Fetches: 82
  • Buffers: shared hit=661
29. 0.000 1.798 ↑ 1.2 239 1

Nested Loop (cost=0.58..685.75 rows=287 width=16) (actual time=0.163..1.798 rows=239 loops=1)

  • Output: news_version_1_1.id, news_1.id, news_1.status_modified_at
  • Inner Unique: true
  • Buffers: shared hit=1735
30. 0.292 0.939 ↑ 1.0 289 1

Nested Loop (cost=0.29..551.37 rows=289 width=16) (actual time=0.034..0.939 rows=289 loops=1)

  • Output: news_1.id, news_1.status_modified_at, news_1.version_id
  • Inner Unique: true
  • Buffers: shared hit=867
31. 0.069 0.069 ↑ 1.0 289 1

CTE Scan on user_versions u2 (cost=0.00..5.78 rows=289 width=4) (actual time=0.003..0.069 rows=289 loops=1)

  • Output: u2.id, u2.news_id
32. 0.578 0.578 ↑ 1.0 1 289

Index Scan using news_pkey on base.news news_1 (cost=0.29..1.89 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=289)

  • Output: news_1.id, news_1.status_modified_at, news_1.version_id
  • Index Cond: (news_1.id = u2.news_id)
  • Buffers: shared hit=867
33. 0.867 0.867 ↑ 1.0 1 289

Index Scan using news_version_pkey on base.news_version news_version_1_1 (cost=0.29..0.46 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=289)

  • Output: news_version_1_1.id
  • Index Cond: (news_version_1_1.id = news_1.version_id)
  • Filter: (news_version_1_1.status_id <> ALL ('{1,3}'::integer[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=868
34. 12.583 41.581 ↑ 3.4 210 1

Hash Join (cost=730.52..3,223.37 rows=704 width=16) (actual time=8.442..41.581 rows=210 loops=1)

  • Output: news_version_1_2.id, news_2.id, news_2.status_modified_at
  • Hash Cond: (news_2.version_id = news_version_1_2.id)
  • Buffers: shared hit=5014
35. 20.679 20.679 ↑ 1.0 109,510 1

Seq Scan on base.news news_2 (cost=0.00..2,074.86 rows=109,586 width=16) (actual time=0.014..20.679 rows=109,510 loops=1)

  • Output: news_2.id, news_2.status_modified_at, news_2.version_id
  • Buffers: shared hit=979
36. 0.153 8.319 ↑ 1.5 466 1

Hash (cost=721.63..721.63 rows=711 width=8) (actual time=8.319..8.319 rows=466 loops=1)

  • Output: news_version_1_2.id, u3.id
  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
  • Buffers: shared hit=4035
37. 0.093 8.166 ↑ 1.5 466 1

Nested Loop (cost=0.29..721.63 rows=711 width=8) (actual time=0.117..8.166 rows=466 loops=1)

  • Output: news_version_1_2.id, u3.id
  • Inner Unique: true
  • Buffers: shared hit=4035
38. 7.141 7.141 ↑ 1.5 466 1

CTE Scan on user_author_versions u3 (cost=0.00..14.22 rows=711 width=4) (actual time=0.110..7.141 rows=466 loops=1)

  • Output: u3.id
  • Buffers: shared hit=2971
39. 0.932 0.932 ↑ 1.0 1 466

Index Only Scan using news_version_pkey on base.news_version news_version_1_2 (cost=0.29..0.99 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=466)

  • Output: news_version_1_2.id
  • Index Cond: (news_version_1_2.id = u3.id)
  • Heap Fetches: 130
  • Buffers: shared hit=1064
40. 0.217 0.217 ↑ 1.0 1 31

Index Scan using news_pkey on base.news _news (cost=0.29..2.28 rows=1 width=37) (actual time=0.007..0.007 rows=1 loops=31)

  • Output: _news.created_at, _news.parent_id, _news.newsbreak_id, _news.version_id, _news.asoi_id, _news.is_from_asoi, _news.status_modified_at, _news.id
  • Index Cond: (_news.id = news.id)
  • Buffers: shared hit=93
41. 0.124 0.124 ↑ 1.0 1 31

Index Scan using news_version_pkey on base.news_version _news_version (cost=0.29..2.28 rows=1 width=1,524) (actual time=0.004..0.004 rows=1 loops=31)

  • Output: _news_version.created_at, _news_version.news_id, _news_version.number, _news_version.user_id, _news_version.status_id, _news_version.type_id, _news_version.language_id, _news_version.slugline, _news_version.header, _news_version.trashline, _news_version.dateline, _news_version.body, _news_version.background, _news_version.id
  • Index Cond: (_news_version.id = news_version_1.id)
  • Buffers: shared hit=93
42. 0.031 0.062 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.98..4.74 rows=2 width=3,699) (actual time=0.002..0.002 rows=0 loops=31)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment, 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
43. 0.000 0.031 ↓ 0.0 0 31

Nested Loop (cost=0.56..2.73 rows=1 width=1,566) (actual time=0.001..0.001 rows=0 loops=31)

  • 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
  • Inner Unique: true
44. 0.031 0.031 ↓ 0.0 0 31

Nested Loop (cost=0.28..0.58 rows=1 width=1,446) (actual time=0.001..0.001 rows=0 loops=31)

  • 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
  • Inner Unique: true
45. 0.000 0.000 ↓ 0.0 0 31

Index Scan using newsbreak_pkey on base.newsbreak newsbreak_1 (cost=0.14..0.16 rows=1 width=409) (actual time=0.000..0.000 rows=0 loops=31)

  • Output: newsbreak_1.lead_id, newsbreak_1.created_at, newsbreak_1.id, newsbreak_1.fragment
  • Index Cond: (newsbreak_1.id = _news.newsbreak_id)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using lead_pkey on base.lead lead_1 (cost=0.14..0.40 rows=1 width=1,037) (never executed)

  • 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
  • Index Cond: (lead_1.id = newsbreak_1.lead_id)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using source_pkey on base.source source_1 (cost=0.29..2.14 rows=1 width=120) (never executed)

  • 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)
48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..1.99 rows=2 width=2,133) (never executed)

  • 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
49. 0.000 0.000 ↓ 0.0 0

Index Scan using newsbreak_user_pkey on base.newsbreak_user newsbreak_user_1 (cost=0.14..0.28 rows=2 width=12) (never executed)

  • 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
  • Index Cond: (newsbreak_1.id = newsbreak_user_1.newsbreak_id)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using user_pkey on base."user" user_1 (cost=0.28..0.85 rows=1 width=2,121) (never executed)

  • Output: user_1.created_at, user_1.id, user_1.asoi_id, user_1.is_blocked, 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, user_1.asoi_mailbox_id, user_1.asoi_name
  • Index Cond: (user_1.id = newsbreak_user_1.user_id)
51. 0.000 0.000 ↓ 0.0 0 31

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.000..0.000 rows=0 loops=31)

  • 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)
52. 0.031 0.031 ↓ 0.0 0 31

Index Scan using user_pkey on base."user" user_2 (cost=0.28..0.30 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.user_id)
  • Buffers: shared hit=15
53. 0.031 0.248 ↑ 2.0 1 31

Nested Loop (cost=0.70..3.52 rows=2 width=2,130) (actual time=0.007..0.008 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=218
54. 0.155 0.155 ↑ 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.005 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_author_1.version_id = news_version_1.id)
  • Buffers: shared hit=125
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.093 ↓ 0.0 0 31

Nested Loop (cost=0.70..3.59 rows=5 width=154) (actual time=0.003..0.003 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.093 0.093 ↓ 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.003..0.003 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.014 0.166 ↑ 1.4 23 1

Hash (cost=3.84..3.84 rows=32 width=56) (actual time=0.166..0.166 rows=23 loops=1)

  • 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
  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
60. 0.049 0.152 ↑ 1.4 23 1

Hash Join (cost=2.44..3.84 rows=32 width=56) (actual time=0.135..0.152 rows=23 loops=1)

  • 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)
  • Buffers: shared hit=2
61. 0.023 0.023 ↑ 1.4 23 1

Seq Scan on base.newsbreak_group newsbreak_group_1 (cost=0.00..1.32 rows=32 width=11) (actual time=0.017..0.023 rows=23 loops=1)

  • Output: newsbreak_group_1.newsbreak_id, newsbreak_group_1.group_id, newsbreak_group_1.status_id, newsbreak_group_1.is_read
  • Buffers: shared hit=1
62. 0.045 0.080 ↑ 1.0 64 1

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

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

Seq Scan on base."group" group_1 (cost=0.00..1.64 rows=64 width=45) (actual time=0.013..0.035 rows=64 loops=1)

  • Output: group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name
  • Buffers: shared hit=1
64. 64.507 282.382 ↓ 1.0 108,949 1

Hash (cost=25,804.29..25,804.29 rows=108,349 width=2,125) (actual time=282.382..282.382 rows=108,949 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
  • Buckets: 8192 Batches: 32 Memory Usage: 335kB
  • Buffers: shared hit=18576, temp written=854
65. 39.092 217.875 ↓ 1.0 108,949 1

Hash Join (cost=18,948.12..25,804.29 rows=108,349 width=2,125) (actual time=83.499..217.875 rows=108,949 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=18576
66. 43.896 177.590 ↓ 1.0 108,949 1

Hash Join (cost=18,895.88..25,466.55 rows=108,349 width=8) (actual time=82.295..177.590 rows=108,949 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=18549
67. 51.654 51.654 ↓ 1.0 108,949 1

Seq Scan on base.news_version_event news_version_event_1 (cost=0.00..6,286.25 rows=108,349 width=8) (actual time=0.044..51.654 rows=108,949 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: 222084
  • Buffers: shared hit=2145
68. 33.899 82.040 ↓ 1.0 110,751 1

Hash (cost=17,511.50..17,511.50 rows=110,750 width=8) (actual time=82.040..82.040 rows=110,751 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buckets: 131072 Batches: 1 Memory Usage: 5351kB
  • Buffers: shared hit=16404
69. 48.141 48.141 ↓ 1.0 110,751 1

Seq Scan on base.news_version news_version_2 (cost=0.00..17,511.50 rows=110,750 width=8) (actual time=0.013..48.141 rows=110,751 loops=1)

  • Output: news_version_2.id, news_version_2.news_id
  • Buffers: shared hit=16404
70. 0.592 1.193 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=1.193..1.193 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
71. 0.601 0.601 ↑ 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.016..0.601 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
72. 0.149 0.521 ↓ 1.0 299 1

Hash (cost=8.25..8.25 rows=297 width=53) (actual time=0.521..0.521 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
73. 0.214 0.372 ↓ 1.0 299 1

Hash Join (cost=2.44..8.25 rows=297 width=53) (actual time=0.238..0.372 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
74. 0.058 0.058 ↓ 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.015..0.058 rows=299 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id
  • Buffers: shared hit=2
75. 0.074 0.100 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=45) (actual time=0.100..0.100 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
76. 0.026 0.026 ↑ 1.0 64 1

Seq Scan on base."group" group_2 (cost=0.00..1.64 rows=64 width=45) (actual time=0.012..0.026 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
77. 1.695 3.308 ↓ 1.0 617 1

Hash (cost=64.03..64.03 rows=616 width=2,132) (actual time=3.308..3.308 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
78. 0.448 1.613 ↓ 1.0 617 1

Hash Join (cost=52.24..64.03 rows=616 width=2,132) (actual time=1.060..1.613 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
79. 0.204 0.204 ↓ 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.011..0.204 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
80. 0.616 0.961 ↑ 1.0 1,122 1

Hash (cost=38.22..38.22 rows=1,122 width=2,121) (actual time=0.961..0.961 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
81. 0.345 0.345 ↑ 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.010..0.345 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
82.          

SubPlan (forHash Left Join)

83. 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
84. 0.111 0.111 ↓ 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.111..0.111 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