explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dynv

Settings
# exclusive inclusive rows x rows loops node
1. 0.121 11.315 ↑ 23.2 31 1

Sort (cost=10,824.65..10,826.45 rows=718 width=11,352) (actual time=11.313..11.315 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_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, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_user_1.is_forwarded_by, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_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_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_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, news_author_1.version_id, news_author_1.user_id, news_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_code_1.version_id, news_code_1.code_id, 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, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, 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.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.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_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment
  • Sort Key: newsbreak.created_at DESC, task_1.id, user_1.id, task_user_1.status_id, group_1.id, task_group_1.status_id, news_1.id, user_3.id, code_1.id, user_4.id, group_2.id
  • Sort Method: quicksort Memory: 47kB
  • Buffers: shared hit=918
2.          

CTE _rawdata

3. 0.354 0.354 ↑ 31.4 293 1

Index Scan using newsbreak_source_id_created_at_idx on base.newsbreak t (cost=0.56..9,231.38 rows=9,202 width=243) (actual time=0.025..0.354 rows=293 loops=1)

  • Output: t.id, t.created_at, t.source_id, t.web_block_id, t.body_hash, t.url, t.web_block_xpath, t.body
  • Index Cond: ((t.source_id = ANY ('{1056,4897,15960,17379,17380,17381,17383,17384,17385,17386,17387,17388,17389,17390,17392}'::integer[])) AND (t.created_at <= '2019-01-07 05:14:26.079041+03'::timestamp with time zone))
  • Buffers: shared hit=353
4. 0.053 11.194 ↑ 23.2 31 1

Hash Left Join (cost=1,385.09..1,559.21 rows=718 width=11,352) (actual time=11.141..11.194 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, user_1.created_at, user_1.id, user_1.asoi_id, user_1.asoi_mailbox_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, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_user_1.is_forwarded_by, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_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_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_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, news_author_1.version_id, news_author_1.user_id, news_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_code_1.version_id, news_code_1.code_id, 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, user_4.created_at, user_4.id, user_4.asoi_id, user_4.asoi_mailbox_id, user_4.is_blocked, 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.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.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_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment
  • Hash Cond: (news_1.id = news_group_1.news_id)
  • Buffers: shared hit=909
5. 0.059 10.519 ↑ 23.2 31 1

Hash Right Join (cost=1,358.69..1,524.07 rows=718 width=11,299) (actual time=10.486..10.519 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_user_1.news_id, news_user_1.user_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.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_code_1.version_id, news_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_author_1.version_id, news_author_1.user_id, news_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.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.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.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_1.id)
  • Buffers: shared hit=904
6. 0.009 0.497 ↑ 1.0 11 1

Nested Loop (cost=0.56..165.82 rows=11 width=1,606) (actual time=0.038..0.497 rows=11 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.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
  • Buffers: shared hit=139
7. 0.004 0.466 ↑ 1.0 11 1

Nested Loop (cost=0.28..148.57 rows=11 width=8) (actual time=0.025..0.466 rows=11 loops=1)

  • Output: news_event_1.user_id, news_version_2.news_id
  • Inner Unique: true
  • Buffers: shared hit=106
8. 0.429 0.429 ↑ 1.0 11 1

Seq Scan on base.news_event news_event_1 (cost=0.00..129.32 rows=11 width=8) (actual time=0.011..0.429 rows=11 loops=1)

  • Output: news_event_1.version_id, news_event_1.user_id
  • Filter: (news_event_1.type_id = 8)
  • Rows Removed by Filter: 4500
  • Buffers: shared hit=73
9. 0.033 0.033 ↑ 1.0 1 11

Index Scan using news_version_pkey on base.news_version news_version_2 (cost=0.28..1.75 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=11)

  • Output: news_version_2.id, news_version_2.news_id
  • Index Cond: (news_version_2.id = news_event_1.version_id)
  • Buffers: shared hit=33
10. 0.022 0.022 ↑ 1.0 1 11

Index Scan using user_pkey on base."user" user_5 (cost=0.28..1.57 rows=1 width=1,602) (actual time=0.002..0.002 rows=1 loops=11)

  • Output: user_5.created_at, user_5.id, user_5.asoi_id, user_5.is_blocked, 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, user_5.asoi_mailbox_id
  • Index Cond: (user_5.id = news_event_1.user_id)
  • Buffers: shared hit=33
11. 0.047 9.963 ↑ 23.2 31 1

Hash (cost=1,349.16..1,349.16 rows=718 width=9,697) (actual time=9.963..9.963 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_user_1.news_id, news_user_1.user_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.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_code_1.version_id, news_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_author_1.version_id, news_author_1.user_id, news_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.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.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: 27kB
  • Buffers: shared hit=765
12. 0.042 9.916 ↑ 23.2 31 1

Hash Left Join (cost=1,282.66..1,349.16 rows=718 width=9,697) (actual time=9.838..9.916 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_user_1.news_id, news_user_1.user_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.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_code_1.version_id, news_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_author_1.version_id, news_author_1.user_id, news_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.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.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
  • Hash Cond: (news_version_1.user_id = user_2.id)
  • Buffers: shared hit=765
13. 0.040 9.299 ↑ 23.2 31 1

Hash Left Join (cost=1,239.55..1,304.16 rows=718 width=8,095) (actual time=9.241..9.299 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_user_1.news_id, news_user_1.user_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.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_code_1.version_id, news_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_author_1.version_id, news_author_1.user_id, news_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.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
  • Hash Cond: (news_version_1.id = news_code_1.version_id)
  • Buffers: shared hit=747
14. 0.042 6.881 ↑ 23.2 31 1

Hash Left Join (cost=1,045.25..1,098.64 rows=718 width=7,941) (actual time=6.839..6.881 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_user_1.news_id, news_user_1.user_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.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_author_1.version_id, news_author_1.user_id, news_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.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
  • Hash Cond: (news_1.id = news_user_1.news_id)
  • Buffers: shared hit=662
15. 0.163 5.258 ↑ 23.2 31 1

Hash Right Join (cost=982.05..1,026.04 rows=718 width=6,330) (actual time=5.233..5.258 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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_author_1.version_id, news_author_1.user_id, news_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.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
  • Hash Cond: (news_author_1.version_id = news_version_1.id)
  • Buffers: shared hit=640
16. 0.529 1.277 ↓ 1.0 1,438 1

Hash Join (cost=43.11..75.54 rows=1,380 width=1,611) (actual time=0.635..1.277 rows=1,438 loops=1)

  • Output: news_author_1.version_id, news_author_1.user_id, news_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.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
  • Hash Cond: (news_author_1.user_id = user_3.id)
  • Buffers: shared hit=33
17. 0.145 0.145 ↓ 1.0 1,438 1

Seq Scan on base.news_author news_author_1 (cost=0.00..28.80 rows=1,380 width=9) (actual time=0.011..0.145 rows=1,438 loops=1)

  • Output: news_author_1.version_id, news_author_1.user_id, news_author_1.is_removable
  • Buffers: shared hit=15
18. 0.349 0.603 ↑ 1.0 1,116 1

Hash (cost=29.16..29.16 rows=1,116 width=1,602) (actual time=0.603..0.603 rows=1,116 loops=1)

  • Output: user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_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
  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
  • Buffers: shared hit=18
19. 0.254 0.254 ↑ 1.0 1,116 1

Seq Scan on base."user" user_3 (cost=0.00..29.16 rows=1,116 width=1,602) (actual time=0.006..0.254 rows=1,116 loops=1)

  • Output: user_3.created_at, user_3.id, user_3.asoi_id, user_3.asoi_mailbox_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
  • Buffers: shared hit=18
20. 0.041 3.818 ↑ 23.2 31 1

Hash (cost=929.97..929.97 rows=718 width=4,719) (actual time=3.818..3.818 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=607
21. 0.094 3.777 ↑ 23.2 31 1

Hash Right Join (cost=905.50..929.97 rows=718 width=4,719) (actual time=3.757..3.777 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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
  • Hash Cond: (news_1.task_id = task_1.id)
  • Buffers: shared hit=607
22. 0.342 1.608 ↓ 1.0 937 1

Hash Join (cost=69.94..90.77 rows=936 width=1,144) (actual time=1.107..1.608 rows=937 loops=1)

  • Output: news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id, 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
  • Inner Unique: true
  • Hash Cond: (news_1.version_id = news_version_1.id)
  • Buffers: shared hit=44
23. 0.190 0.190 ↓ 1.0 937 1

Seq Scan on base.news news_1 (cost=0.00..18.36 rows=936 width=36) (actual time=0.009..0.190 rows=937 loops=1)

  • Output: news_1.created_at, news_1.status_modified_at, news_1.id, news_1.parent_id, news_1.task_id, news_1.version_id, news_1.asoi_id
  • Buffers: shared hit=9
24. 0.605 1.076 ↑ 1.1 1,432 1

Hash (cost=50.53..50.53 rows=1,553 width=1,108) (actual time=1.076..1.076 rows=1,432 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
  • Buckets: 2048 Batches: 1 Memory Usage: 233kB
  • Buffers: shared hit=35
25. 0.471 0.471 ↑ 1.1 1,432 1

Seq Scan on base.news_version news_version_1 (cost=0.00..50.53 rows=1,553 width=1,108) (actual time=0.005..0.471 rows=1,432 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
  • Buffers: shared hit=35
26. 0.047 2.075 ↑ 23.2 31 1

Hash (cost=826.58..826.58 rows=718 width=3,575) (actual time=2.075..2.075 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=563
27. 0.060 2.028 ↑ 23.2 31 1

Hash Right Join (cost=775.07..826.58 rows=718 width=3,575) (actual time=2.008..2.028 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read, group_1.id, group_1.asoi_id, group_1.asoi_mailbox_id, group_1.code, group_1.name, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Hash Cond: (task_group_1.task_id = task_1.id)
  • Buffers: shared hit=563
28. 0.026 0.081 ↑ 418.0 5 1

Hash Join (cost=2.44..38.94 rows=2,090 width=56) (actual time=0.078..0.081 rows=5 loops=1)

  • Output: task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_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: (task_group_1.group_id = group_1.id)
  • Buffers: shared hit=2
29. 0.007 0.007 ↑ 418.0 5 1

Seq Scan on base.task_group task_group_1 (cost=0.00..30.90 rows=2,090 width=11) (actual time=0.007..0.007 rows=5 loops=1)

  • Output: task_group_1.task_id, task_group_1.group_id, task_group_1.status_id, task_group_1.is_read
  • Buffers: shared hit=1
30. 0.031 0.048 ↑ 1.0 64 1

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

Seq Scan on base."group" group_1 (cost=0.00..1.64 rows=64 width=45) (actual time=0.006..0.017 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
32. 0.039 1.887 ↑ 10.2 31 1

Hash (cost=768.68..768.68 rows=316 width=3,519) (actual time=1.887..1.887 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=561
33. 0.041 1.848 ↑ 10.2 31 1

Hash Right Join (cost=722.08..768.68 rows=316 width=3,519) (actual time=1.830..1.848 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment, task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Hash Cond: (task_user_1.task_id = task_1.id)
  • Buffers: shared hit=561
34. 0.026 0.645 ↑ 145.7 14 1

Hash Join (cost=43.11..78.89 rows=2,040 width=1,614) (actual time=0.638..0.645 rows=14 loops=1)

  • Output: task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_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.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: (task_user_1.user_id = user_1.id)
  • Buffers: shared hit=19
35. 0.009 0.009 ↑ 145.7 14 1

Seq Scan on base.task_user task_user_1 (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.006..0.009 rows=14 loops=1)

  • Output: task_user_1.task_id, task_user_1.user_id, task_user_1.status_id, task_user_1.is_read, task_user_1.is_forwarded_by
  • Buffers: shared hit=1
36. 0.321 0.610 ↑ 1.0 1,116 1

Hash (cost=29.16..29.16 rows=1,116 width=1,602) (actual time=0.610..0.610 rows=1,116 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.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: 106kB
  • Buffers: shared hit=18
37. 0.289 0.289 ↑ 1.0 1,116 1

Seq Scan on base."user" user_1 (cost=0.00..29.16 rows=1,116 width=1,602) (actual time=0.010..0.289 rows=1,116 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.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=18
38. 0.036 1.162 ↑ 4.6 31 1

Hash (cost=677.18..677.18 rows=143 width=1,905) (actual time=1.162..1.162 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=542
39. 0.051 1.126 ↑ 4.6 31 1

Hash Right Join (cost=653.10..677.18 rows=143 width=1,905) (actual time=1.110..1.126 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath, task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment
  • Hash Cond: (task_1.newsbreak_id = newsbreak.id)
  • Buffers: shared hit=542
40. 0.006 0.006 ↑ 184.0 5 1

Seq Scan on base.task task_1 (cost=0.00..19.20 rows=920 width=60) (actual time=0.005..0.006 rows=5 loops=1)

  • Output: task_1.newsbreak_id, task_1.created_at, task_1.id, task_1.fragment
  • Buffers: shared hit=1
41. 0.048 1.069 ↑ 1.0 31 1

Hash (cost=652.72..652.72 rows=31 width=1,845) (actual time=1.069..1.069 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=541
42. 0.017 1.021 ↑ 1.0 31 1

Nested Loop Left Join (cost=458.57..652.72 rows=31 width=1,845) (actual time=0.864..1.021 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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, web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Inner Unique: true
  • Buffers: shared hit=541
43. 0.027 0.942 ↑ 1.0 31 1

Nested Loop (cost=458.28..589.26 rows=31 width=1,763) (actual time=0.849..0.942 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body, 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=448
44. 0.006 0.853 ↑ 1.0 31 1

Limit (cost=457.99..525.50 rows=31 width=1,129) (actual time=0.830..0.853 rows=31 loops=1)

  • Output: ((alternatives: SubPlan 2 or hashed SubPlan 3)), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body
  • Buffers: shared hit=355
45. 0.033 0.847 ↑ 296.8 31 1

Result (cost=457.99..20,495.35 rows=9,202 width=1,129) (actual time=0.829..0.847 rows=31 loops=1)

  • Output: (alternatives: SubPlan 2 or hashed SubPlan 3), newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body
  • Buffers: shared hit=355
46. 0.113 0.784 ↑ 296.8 31 1

Sort (cost=457.99..481.00 rows=9,202 width=1,128) (actual time=0.780..0.784 rows=31 loops=1)

  • Output: newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body
  • Sort Key: newsbreak.created_at DESC
  • Sort Method: top-N heapsort Memory: 50kB
  • Buffers: shared hit=353
47. 0.671 0.671 ↑ 31.4 293 1

CTE Scan on _rawdata newsbreak (cost=0.00..184.04 rows=9,202 width=1,128) (actual time=0.027..0.671 rows=293 loops=1)

  • Output: newsbreak.id, newsbreak.created_at, newsbreak.source_id, newsbreak.web_block_id, newsbreak.body_hash, newsbreak.url, newsbreak.web_block_xpath, newsbreak.body
  • Buffers: shared hit=353
48.          

SubPlan (forResult)

49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using newsbreak_event_newsbreak_id_user_id_type_id_key on base.newsbreak_event (cost=0.14..2.16 rows=1 width=0) (never executed)

  • Index Cond: ((newsbreak_event.newsbreak_id = newsbreak.id) AND (newsbreak_event.user_id = 1057))
  • Heap Fetches: 0
50. 0.030 0.030 ↓ 1.2 7 1

Seq Scan on base.newsbreak_event newsbreak_event_1 (cost=0.00..4.58 rows=6 width=16) (actual time=0.024..0.030 rows=7 loops=1)

  • Output: newsbreak_event_1.newsbreak_id
  • Filter: ((newsbreak_event_1.type_id = 1) AND (newsbreak_event_1.user_id = 1057))
  • Rows Removed by Filter: 181
  • Buffers: shared hit=2
51. 0.062 0.062 ↑ 1.0 1 31

Index Scan using source_pkey on base.source source_1 (cost=0.29..2.05 rows=1 width=634) (actual time=0.002..0.002 rows=1 loops=31)

  • 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 = newsbreak.source_id)
  • Buffers: shared hit=93
52. 0.062 0.062 ↑ 1.0 1 31

Index Scan using web_source_block_pkey on base.web_source_block web_source_block_1 (cost=0.29..2.05 rows=1 width=82) (actual time=0.002..0.002 rows=1 loops=31)

  • Output: web_source_block_1.id, web_source_block_1.source_id, web_source_block_1.is_deleted, web_source_block_1.is_excluded, web_source_block_1.name, web_source_block_1.xpath
  • Index Cond: (web_source_block_1.id = newsbreak.web_block_id)
  • Buffers: shared hit=93
53. 0.517 1.581 ↑ 1.0 640 1

Hash (cost=55.20..55.20 rows=640 width=1,611) (actual time=1.581..1.581 rows=640 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_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.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: 301kB
  • Buffers: shared hit=22
54. 0.328 1.064 ↑ 1.0 640 1

Hash Join (cost=43.11..55.20 rows=640 width=1,611) (actual time=0.632..1.064 rows=640 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_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.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=22
55. 0.131 0.131 ↑ 1.0 640 1

Seq Scan on base.news_user news_user_1 (cost=0.00..10.40 rows=640 width=9) (actual time=0.007..0.131 rows=640 loops=1)

  • Output: news_user_1.news_id, news_user_1.user_id, news_user_1.is_read
  • Buffers: shared hit=4
56. 0.340 0.605 ↑ 1.0 1,116 1

Hash (cost=29.16..29.16 rows=1,116 width=1,602) (actual time=0.605..0.605 rows=1,116 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.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: 106kB
  • Buffers: shared hit=18
57. 0.265 0.265 ↑ 1.0 1,116 1

Seq Scan on base."user" user_4 (cost=0.00..29.16 rows=1,116 width=1,602) (actual time=0.008..0.265 rows=1,116 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.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=18
58. 0.165 2.378 ↓ 1.0 504 1

Hash (cost=188.22..188.22 rows=486 width=154) (actual time=2.378..2.378 rows=504 loops=1)

  • Output: news_code_1.version_id, news_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
  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
  • Buffers: shared hit=85
59. 0.196 2.213 ↓ 1.0 504 1

Hash Join (cost=178.09..188.22 rows=486 width=154) (actual time=2.021..2.213 rows=504 loops=1)

  • Output: news_code_1.version_id, news_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
  • Hash Cond: (news_code_1.code_id = code_1.id)
  • Buffers: shared hit=85
60. 0.053 0.053 ↓ 1.0 504 1

Seq Scan on base.news_code news_code_1 (cost=0.00..8.86 rows=486 width=8) (actual time=0.008..0.053 rows=504 loops=1)

  • Output: news_code_1.version_id, news_code_1.code_id
  • Buffers: shared hit=4
61. 1.366 1.964 ↑ 1.0 4,315 1

Hash (cost=124.15..124.15 rows=4,315 width=146) (actual time=1.964..1.964 rows=4,315 loops=1)

  • 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
  • Buckets: 8192 Batches: 1 Memory Usage: 703kB
  • Buffers: shared hit=81
62. 0.598 0.598 ↑ 1.0 4,315 1

Seq Scan on base.code code_1 (cost=0.00..124.15 rows=4,315 width=146) (actual time=0.005..0.598 rows=4,315 loops=1)

  • 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
  • Buffers: shared hit=81
63. 0.334 0.575 ↑ 1.0 1,116 1

Hash (cost=29.16..29.16 rows=1,116 width=1,602) (actual time=0.575..0.575 rows=1,116 loops=1)

  • Output: user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_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
  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
  • Buffers: shared hit=18
64. 0.241 0.241 ↑ 1.0 1,116 1

Seq Scan on base."user" user_2 (cost=0.00..29.16 rows=1,116 width=1,602) (actual time=0.006..0.241 rows=1,116 loops=1)

  • Output: user_2.created_at, user_2.id, user_2.asoi_id, user_2.asoi_mailbox_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
  • Buffers: shared hit=18
65. 0.222 0.622 ↓ 1.0 790 1

Hash (cost=16.53..16.53 rows=789 width=53) (actual time=0.622..0.622 rows=790 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: 81kB
  • Buffers: shared hit=5
66. 0.273 0.400 ↓ 1.0 790 1

Hash Join (cost=2.44..16.53 rows=789 width=53) (actual time=0.065..0.400 rows=790 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=5
67. 0.089 0.089 ↓ 1.0 790 1

Seq Scan on base.news_group news_group_1 (cost=0.00..11.89 rows=789 width=8) (actual time=0.007..0.089 rows=790 loops=1)

  • Output: news_group_1.news_id, news_group_1.group_id
  • Buffers: shared hit=4
68. 0.023 0.038 ↑ 1.0 64 1

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

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

Seq Scan on base."group" group_2 (cost=0.00..1.64 rows=64 width=45) (actual time=0.005..0.015 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