explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y5JS

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 119,078.348 ↑ 1.0 10 1

Limit (cost=1,000.45..536,770.83 rows=10 width=42) (actual time=57,189.732..119,078.348 rows=10 loops=1)

  • Output: fsa_online.id, fsa_online.fsa_uuid, fsa_online.use_version, fsa_online.last_original_version, fsa_online.is_drug, data.cert_num
2. 0.000 119,078.345 ↑ 49,112.0 10 1

Gather Merge (cost=1,000.45..26,312,755,865.50 rows=491,120 width=42) (actual time=57,189.731..119,078.345 rows=10 loops=1)

  • Output: fsa_online.id, fsa_online.fsa_uuid, fsa_online.use_version, fsa_online.last_original_version, fsa_online.is_drug, data.cert_num
  • Workers Planned: 2
  • Workers Launched: 2
3. 86,912.219 374,604.528 ↑ 29,233.3 7 3

Nested Loop (cost=0.43..26,312,698,178.04 rows=204,633 width=42) (actual time=42,010.446..124,868.176 rows=7 loops=3)

  • Output: data.cert_num, fsa_online.id, fsa_online.fsa_uuid, fsa_online.use_version, fsa_online.last_original_version, fsa_online.is_drug
  • Join Filter: (data.id = COALESCE(fsa_online.use_version, fsa_online.last_original_version))
  • Rows Removed by Join Filter: 529269659
  • Worker 0: actual time=34025.442..125977.711 rows=14 loops=1
  • Worker 1: actual time=57157.835..151890.185 rows=5 loops=1
4. 44.964 44.964 ↑ 1,472.1 588 3

Parallel Index Scan using fsa_online_data_cert_num_index on public.fsa_online_data data (cost=0.43..7,494,575.12 rows=865,605 width=17) (actual time=0.875..14.988 rows=588 loops=3)

  • Output: data.id, data.fsa_id, data.reason, data.is_original, data.is_published, data.created_by_id, data.created_at, data.unparsed_data, data.raw_id, data.status_id, data.type_id, data.reg_num, data.start_date, data.end_date, data.docs, data.docs_add, data.scheme, data.free_form, data.fio_expert, data.lab_info, data.change_info, data.applicant_info, data.manufacturer_info, data.product_info, data.standard_info, data.manufacturer_tbl_info, data.product_tbl_info, data.certification_info, data.trade_name, data.cert_num, data.man_form_txt, data.manufacturer_name, data.man_country_id, data.serial_num, data.serial_size, data.barcode, data.barcode_type_id, data.is_cert, data.original_data
  • Filter: (data.unparsed_data IS NOT NULL)
  • Rows Removed by Filter: 2575
  • Worker 0: actual time=2.124..19.043 rows=589 loops=1
  • Worker 1: actual time=0.434..20.705 rows=731 loops=1
5. 287,647.345 287,647.345 ↑ 1.0 899,608 1,765

Seq Scan on public.fsa_online (cost=0.00..19,143.06 rows=899,706 width=29) (actual time=0.002..162.973 rows=899,608 loops=1,765)

  • Output: fsa_online.id, fsa_online.fsa_uuid, fsa_online.use_version, fsa_online.last_original_version, fsa_online.is_drug
  • Filter: (fsa_online.deleted_at IS NULL)
  • Worker 0: actual time=0.002..164.007 rows=899612 loops=589
  • Worker 1: actual time=0.002..159.487 rows=899598 loops=731
Planning time : 0.589 ms