explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xyiy

Settings
# exclusive inclusive rows x rows loops node
1. 0.355 10,815.114 ↑ 5.0 1 1

Nested Loop (cost=144,803.54..340,734.96 rows=5 width=1,810) (actual time=5,504.855..10,815.114 rows=1 loops=1)

  • Output: partyrelat0_.id, partyrelat3_.id, party4_.id, partyrelat5_.id, partyrelat6_.id, partyrelat7_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, ((upper((party4_1_.surname)::text) || upper((party4_1_.name)::text)) || upper((party4_1_.patr_name)::text)), COALESCE(party4_2_.short_name, party4_2_.full_name), (SubPlan 1), CASE WHEN (party4_1_.id IS NOT NULL) THEN 1 WHEN (party4_2_.id IS NOT NULL) THEN 2 WHEN (party4_.id IS NOT NULL) THEN 0 ELSE NULL::integer END, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, CASE WHEN (partyrelat6_1_.id IS NOT NULL) THEN 1 WHEN (partyrelat6_.id IS NOT NULL) THEN 0 ELSE NULL::integer END, partyrelat7_.name
  • Buffers: shared hit=26759 read=152208 dirtied=4745
  • I/O Timings: read=4819.338
2. 0.016 10,814.668 ↑ 5.0 1 1

Nested Loop (cost=144,803.12..340,683.22 rows=5 width=1,814) (actual time=5,504.411..10,814.668 rows=1 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id, party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, party4_2_.id, partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id, partyrelat7_.id, partyrelat7_.name, partyrelat1_.rel_id
  • Buffers: shared hit=26754 read=152208 dirtied=4745
  • I/O Timings: read=4819.338
3. 0.043 0.043 ↑ 1.0 1 1

Seq Scan on public.pim_party_relation_category partyrelat7_ (cost=0.00..1.01 rows=1 width=38) (actual time=0.032..0.043 rows=1 loops=1)

  • Output: partyrelat7_.id, partyrelat7_.name, partyrelat7_.aud_who, partyrelat7_.aud_when, partyrelat7_.aud_source, partyrelat7_.aud_who_create, partyrelat7_.aud_when_create, partyrelat7_.aud_source_create, partyrelat7_.code, partyrelat7_.e_code
  • Filter: (partyrelat7_.id = 1)
  • Buffers: shared hit=1
4. 45.965 10,814.609 ↑ 5.0 1 1

Hash Join (cost=144,803.12..340,682.16 rows=5 width=1,776) (actual time=5,504.367..10,814.609 rows=1 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id, party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, party4_2_.id, partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id, partyrelat1_.rel_id
  • Hash Cond: (partyrelat0_.rel_id = partyrelat1_.rel_id)
  • Buffers: shared hit=26753 read=152208 dirtied=4745
  • I/O Timings: read=4819.338
5. 230.898 10,767.827 ↓ 1.0 380,598 1

Hash Left Join (cost=144,790.70..338,766.70 rows=380,596 width=1,772) (actual time=4,401.215..10,767.827 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id, party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, party4_2_.id, partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Hash Cond: (party4_.id = party4_2_.id)
  • Buffers: shared hit=26747 read=152207 dirtied=4745
  • I/O Timings: read=4818.594
6. 357.717 10,402.519 ↓ 1.0 380,598 1

Hash Join (cost=138,914.58..331,339.04 rows=380,596 width=1,019) (actual time=4,265.762..10,402.519 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id, partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Hash Cond: (partyrelat0_.rel_id = partyrelat3_.id)
  • Buffers: shared hit=23224 read=152207 dirtied=4745
  • I/O Timings: read=4818.594
7. 147.199 9,671.225 ↓ 1.0 380,598 1

Hash Join (cost=131,639.51..318,830.78 rows=380,596 width=958) (actual time=3,889.943..9,671.225 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id, partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Hash Cond: (partyrelat0_.side_id = partyrelat5_.id)
  • Buffers: shared hit=23053 read=149214 dirtied=4407
  • I/O Timings: read=4676.141
8. 1,568.893 9,523.912 ↓ 1.0 380,598 1

Hash Right Join (cost=131,620.58..313,578.66 rows=380,596 width=909) (actual time=3,889.781..9,523.912 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, party4_.id, party4_.note, party4_.type_id, party4_.version, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.gender_id, party4_1_.has_citizenship, party4_1_.list_identity_doc, party4_1_.list_job_org, party4_1_.list_main_contact, party4_1_.list_oms_doc, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_when, party4_1_.name, party4_1_.nationality_id, party4_1_.patr_name, party4_1_.surname, party4_1_.id
  • Hash Cond: (party4_1_.id = party4_.id)
  • Buffers: shared hit=23051 read=149214 dirtied=4407
  • I/O Timings: read=4676.141
9. 4,066.587 4,066.587 ↑ 1.0 3,092,007 1

Seq Scan on public.pim_individual party4_1_ (cost=0.00..166,580.12 rows=3,113,812 width=360) (actual time=0.009..4,066.587 rows=3,092,007 loops=1)

  • Output: party4_1_.id, party4_1_.birth_dt, party4_1_.death_dt, party4_1_.has_citizenship, party4_1_.name, party4_1_.patr_name, party4_1_.surname, party4_1_.gender_id, party4_1_.nationality_id, party4_1_.list_identity_doc, party4_1_.list_oms_doc, party4_1_.list_job_org, party4_1_.list_reg_name, party4_1_.list_snils, party4_1_.list_uid, party4_1_.aud_who, party4_1_.aud_when, party4_1_.aud_source, party4_1_.aud_who_create, party4_1_.aud_when_create, party4_1_.aud_source_create, party4_1_.birth_place, party4_1_.age_year, party4_1_.age_month, party4_1_.age_day, party4_1_.list_main_contact
  • Buffers: shared hit=20525 read=114917
  • I/O Timings: read=3479.632
10. 159.772 3,888.432 ↓ 1.0 380,598 1

Hash (cost=126,863.13..126,863.13 rows=380,596 width=549) (actual time=3,888.432..3,888.432 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, party4_.id, party4_.note, party4_.type_id, party4_.version
  • Buckets: 524288 Batches: 1 Memory Usage: 31351kB
  • Buffers: shared hit=2526 read=34297 dirtied=4407
  • I/O Timings: read=1196.509
11. 309.860 3,728.660 ↓ 1.0 380,598 1

Hash Join (cost=111,840.49..126,863.13 rows=380,596 width=549) (actual time=2,973.753..3,728.660 rows=380,598 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.note, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, party4_.id, party4_.note, party4_.type_id, party4_.version
  • Hash Cond: (partyrelat0_.party_id = party4_.id)
  • Buffers: shared hit=2526 read=34297 dirtied=4407
  • I/O Timings: read=1196.509
12. 451.775 451.775 ↓ 1.0 380,599 1

Seq Scan on public.pim_party_relation_party partyrelat0_ (cost=0.00..8,837.96 rows=380,596 width=532) (actual time=0.008..451.775 rows=380,599 loops=1)

  • Output: partyrelat0_.id, partyrelat0_.party_id, partyrelat0_.rel_id, partyrelat0_.side_id, partyrelat0_.note, partyrelat0_.aud_who, partyrelat0_.aud_when, partyrelat0_.aud_source, partyrelat0_.aud_who_create, partyrelat0_.aud_when_create, partyrelat0_.aud_source_create
  • Buffers: shared hit=121 read=4911
  • I/O Timings: read=395.864
13. 1,085.524 2,967.025 ↑ 1.0 3,196,625 1

Hash (cost=71,815.75..71,815.75 rows=3,201,979 width=17) (actual time=2,967.025..2,967.025 rows=3,196,625 loops=1)

  • Output: party4_.id, party4_.note, party4_.type_id, party4_.version
  • Buckets: 4194304 Batches: 1 Memory Usage: 195620kB
  • Buffers: shared hit=2405 read=29386 dirtied=4407
  • I/O Timings: read=800.645
14. 1,881.501 1,881.501 ↑ 1.0 3,196,625 1

Seq Scan on public.pim_party party4_ (cost=0.00..71,815.75 rows=3,201,979 width=17) (actual time=0.057..1,881.501 rows=3,196,625 loops=1)

  • Output: party4_.id, party4_.note, party4_.type_id, party4_.version
  • Filter: (party4_.id <> 713973)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2405 read=29386 dirtied=4407
  • I/O Timings: read=800.645
15. 0.009 0.114 ↑ 1.0 9 1

Hash (cost=18.82..18.82 rows=9 width=49) (actual time=0.114..0.114 rows=9 loops=1)

  • Output: partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
16. 0.024 0.105 ↑ 1.0 9 1

Hash Join (cost=2.33..18.82 rows=9 width=49) (actual time=0.097..0.105 rows=9 loops=1)

  • Output: partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative, partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Hash Cond: (partyrelat6_.id = partyrelat5_.rel_type_id)
  • Buffers: shared hit=2
17. 0.037 0.062 ↑ 1.0 5 1

Hash Right Join (cost=1.12..17.50 rows=5 width=21) (actual time=0.059..0.062 rows=5 loops=1)

  • Output: partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.id
  • Hash Cond: (partyrelat6_1_.id = partyrelat6_.id)
  • Buffers: shared hit=1
18. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on public.pim_party_relation_type_rule partyrelat6_1_ (cost=0.00..14.60 rows=460 width=5) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: partyrelat6_1_.id, partyrelat6_1_.is_diff_gender_available, partyrelat6_1_.aud_who, partyrelat6_1_.aud_when, partyrelat6_1_.aud_source, partyrelat6_1_.aud_who_create, partyrelat6_1_.aud_when_create, partyrelat6_1_.aud_source_create
19. 0.007 0.025 ↑ 1.0 5 1

Hash (cost=1.06..1.06 rows=5 width=16) (actual time=0.025..0.025 rows=5 loops=1)

  • Output: partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
20. 0.018 0.018 ↑ 1.0 5 1

Seq Scan on public.pim_party_relation_type partyrelat6_ (cost=0.00..1.06 rows=5 width=16) (actual time=0.015..0.018 rows=5 loops=1)

  • Output: partyrelat6_.id, partyrelat6_.from_dt, partyrelat6_.category_id, partyrelat6_.to_dt
  • Filter: (partyrelat6_.category_id = 1)
  • Buffers: shared hit=1
21. 0.010 0.019 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=28) (actual time=0.019..0.019 rows=9 loops=1)

  • Output: partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
22. 0.009 0.009 ↑ 1.0 9 1

Seq Scan on public.pim_party_relation_type_side partyrelat5_ (cost=0.00..1.09 rows=9 width=28) (actual time=0.006..0.009 rows=9 loops=1)

  • Output: partyrelat5_.id, partyrelat5_.name, partyrelat5_.rel_type_id, partyrelat5_.is_scope_relative
  • Buffers: shared hit=1
23. 68.672 373.577 ↓ 1.0 182,871 1

Hash (cost=4,991.14..4,991.14 rows=182,714 width=61) (actual time=373.577..373.577 rows=182,871 loops=1)

  • Output: partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt
  • Buckets: 262144 Batches: 1 Memory Usage: 17093kB
  • Buffers: shared hit=171 read=2993 dirtied=338
  • I/O Timings: read=142.453
24. 304.905 304.905 ↓ 1.0 182,871 1

Seq Scan on public.pim_party_relation partyrelat3_ (cost=0.00..4,991.14 rows=182,714 width=61) (actual time=0.006..304.905 rows=182,871 loops=1)

  • Output: partyrelat3_.id, partyrelat3_.is_active, partyrelat3_.from_dt, partyrelat3_.note, partyrelat3_.rel_type_id, partyrelat3_.to_dt
  • Buffers: shared hit=171 read=2993 dirtied=338
  • I/O Timings: read=142.453
25. 67.087 134.410 ↓ 1.0 104,608 1

Hash (cost=4,568.83..4,568.83 rows=104,583 width=753) (actual time=134.410..134.410 rows=104,608 loops=1)

  • Output: party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, party4_2_.id
  • Buckets: 131072 Batches: 1 Memory Usage: 23858kB
  • Buffers: shared hit=3523
26. 67.323 67.323 ↓ 1.0 104,608 1

Seq Scan on public.pim_organization party4_2_ (cost=0.00..4,568.83 rows=104,583 width=753) (actual time=0.011..67.323 rows=104,608 loops=1)

  • Output: party4_2_.close_dt, party4_2_.code, party4_2_.country_jurisdiction_id, party4_2_.full_name, party4_2_.latitude, party4_2_.legal_form_id, party4_2_.longitude, party4_2_.own_form_id, party4_2_.parent_id, party4_2_.reg_dt, party4_2_.scope_id, party4_2_.short_name, party4_2_.sphere_id, party4_2_.unit_id, party4_2_.work_territory_id, party4_2_.id
  • Buffers: shared hit=3523
27. 0.008 0.817 ↑ 2.0 1 1

Hash (cost=12.40..12.40 rows=2 width=4) (actual time=0.817..0.817 rows=1 loops=1)

  • Output: partyrelat1_.rel_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=0.744
28. 0.809 0.809 ↑ 2.0 1 1

Index Scan using pim_party_rel_party_party_ix on public.pim_party_relation_party partyrelat1_ (cost=0.42..12.40 rows=2 width=4) (actual time=0.808..0.809 rows=1 loops=1)

  • Output: partyrelat1_.rel_id
  • Index Cond: (partyrelat1_.party_id = 713973)
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=0.744
29. 0.044 0.044 ↑ 1.0 1 1

Index Scan using pim_party_relation_pk on public.pim_party_relation partyrelat2_ (cost=0.42..0.48 rows=1 width=4) (actual time=0.042..0.044 rows=1 loops=1)

  • Output: partyrelat2_.id, partyrelat2_.rel_type_id, partyrelat2_.from_dt, partyrelat2_.to_dt, partyrelat2_.is_active, partyrelat2_.note, partyrelat2_.aud_who, partyrelat2_.aud_when, partyrelat2_.aud_source, partyrelat2_.aud_who_create, partyrelat2_.aud_when_create, partyrelat2_.aud_source_create
  • Index Cond: (partyrelat2_.id = partyrelat0_.rel_id)
  • Filter: partyrelat2_.is_active
  • Buffers: shared hit=4
30.          

SubPlan (for Nested Loop)

31. 0.011 0.047 ↑ 1.0 1 1

Aggregate (cost=9.84..9.85 rows=1 width=11) (actual time=0.046..0.047 rows=1 loops=1)

  • Output: max((poc.code)::text)
  • Buffers: shared hit=1
32. 0.004 0.036 ↓ 0.0 0 1

Nested Loop (cost=0.29..9.84 rows=1 width=11) (actual time=0.036..0.036 rows=0 loops=1)

  • Output: poc.code
  • Join Filter: (poc.type_id = pct.id)
  • Buffers: shared hit=1
33. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on public.pim_code_type pct (cost=0.00..1.44 rows=1 width=4) (actual time=0.025..0.031 rows=1 loops=1)

  • Output: pct.id, pct.code, pct.format, pct.from_dt, pct.is_unique, pct.message_pattern, pct.name, pct.note, pct.occurrence, pct.to_dt, pct.party_type_id, pct.e_code, pct.aud_who, pct.aud_when, pct.aud_source, pct.aud_who_create, pct.aud_when_create, pct.aud_source_create
  • Filter: ((pct.code)::text = 'INN_ORGANIZATION'::text)
  • Rows Removed by Filter: 34
  • Buffers: shared hit=1
34. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pim_org_code_org_id_idx on public.pim_org_code poc (cost=0.29..8.37 rows=2 width=15) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: poc.id, poc.code, poc.issue_dt, poc.type_id, poc.org_id, poc.aud_who, poc.aud_when, poc.aud_source, poc.aud_who_create, poc.aud_when_create, poc.aud_source_create
  • Index Cond: (poc.org_id = party4_2_.id)
Planning time : 3.014 ms
Execution time : 10,819.333 ms