explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RXjK : V1

Settings
# exclusive inclusive rows x rows loops node
1. 20.807 2,552.181 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=69.88..2,581.65 rows=1 width=2,067) (actual time=137.761..2,552.181 rows=10,859 loops=1)

2.          

CTE codeinfo

3. 0.447 0.447 ↓ 1.1 66 1

Seq Scan on cmm_mst_code_info (cost=0.00..51.33 rows=61 width=31) (actual time=0.069..0.447 rows=66 loops=1)

  • Filter: ((code_id_)::text = ANY ('{C017,C180,C093,C171,C030,C172,C181,C182,C170}'::text[]))
  • Rows Removed by Filter: 1084
4. 14.952 2,455.361 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.99..2,525.72 rows=1 width=2,092) (actual time=137.737..2,455.361 rows=10,859 loops=1)

5. 82.099 2,396.973 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,521.27 rows=1 width=2,127) (actual time=137.721..2,396.973 rows=10,859 loops=1)

  • Join Filter: ((expending.code_dbid_)::text = (crd.user_expending_range_)::text)
  • Rows Removed by Join Filter: 705835
6. 81.225 2,238.861 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,519.29 rows=1 width=2,050) (actual time=137.715..2,238.861 rows=10,859 loops=1)

  • Join Filter: ((education.code_dbid_)::text = (crd.user_education_)::text)
  • Rows Removed by Join Filter: 705835
7. 73.651 2,081.623 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,517.31 rows=1 width=1,960) (actual time=137.700..2,081.623 rows=10,859 loops=1)

  • Join Filter: ((term.code_dbid_)::text = (crd.tenor_range_)::text)
  • Rows Removed by Join Filter: 709965
8. 76.290 1,931.959 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,515.33 rows=1 width=1,868) (actual time=137.684..1,931.959 rows=10,859 loops=1)

  • Join Filter: ((down.code_dbid_)::text = (crd.down_payment_range_)::text)
  • Rows Removed by Join Filter: 709971
9. 77.141 1,779.656 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,513.34 rows=1 width=1,776) (actual time=137.663..1,779.656 rows=10,859 loops=1)

  • Join Filter: ((payment.code_dbid_)::text = (crd.payment_method_type_)::text)
  • Rows Removed by Join Filter: 705835
10. 80.479 1,626.502 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,511.36 rows=1 width=1,260) (actual time=137.658..1,626.502 rows=10,859 loops=1)

  • Join Filter: ((job.code_dbid_)::text = (crd.user_occupation_)::text)
  • Rows Removed by Join Filter: 705835
11. 77.227 1,470.010 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,509.38 rows=1 width=1,175) (actual time=137.646..1,470.010 rows=10,859 loops=1)

  • Join Filter: ((gender.code_dbid_)::text = (crd.user_gender_type_id_)::text)
  • Rows Removed by Join Filter: 705843
12. 75.127 1,316.770 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,507.40 rows=1 width=1,086) (actual time=137.640..1,316.770 rows=10,859 loops=1)

  • Join Filter: ((instansi.code_dbid_)::text = (crd.sales_order_type_id_)::text)
  • Rows Removed by Join Filter: 708751
13. 83.490 1,165.630 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,505.41 rows=1 width=1,006) (actual time=137.616..1,165.630 rows=10,859 loops=1)

  • Join Filter: ((leasing.code_dbid_)::text = (crd.credit_agent_)::text)
  • Rows Removed by Join Filter: 709968
14. 10.396 1,006.127 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.57..2,503.43 rows=1 width=498) (actual time=137.126..1,006.127 rows=10,859 loops=1)

15. 12.177 974.013 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.29..2,499.91 rows=1 width=525) (actual time=137.116..974.013 rows=10,859 loops=1)

16. 11.314 940.118 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=17.01..2,496.38 rows=1 width=525) (actual time=137.106..940.118 rows=10,859 loops=1)

17. 10.870 907.086 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=16.72..2,492.85 rows=1 width=515) (actual time=137.091..907.086 rows=10,859 loops=1)

18. 12.690 863.639 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=16.44..2,488.54 rows=1 width=511) (actual time=137.079..863.639 rows=10,859 loops=1)

19. 74.189 818.372 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=16.16..2,484.23 rows=1 width=501) (actual time=137.066..818.372 rows=10,859 loops=1)

  • Join Filter: ((color.color_id_)::text = (crd.color_id_)::text)
  • Rows Removed by Join Filter: 477796
20. 12.937 700.747 ↓ 10,859.0 10,859 1

Nested Loop (cost=16.16..2,482.22 rows=1 width=528) (actual time=137.045..700.747 rows=10,859 loops=1)

21. 5.579 644.374 ↓ 10,859.0 10,859 1

Nested Loop (cost=15.74..2,477.77 rows=1 width=492) (actual time=137.030..644.374 rows=10,859 loops=1)

  • Join Filter: ((crd.serialized_product_id_)::text = (manifest.serialized_product_id_)::text)
22. 3.933 541.064 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=15.18..2,473.91 rows=1 width=529) (actual time=137.009..541.064 rows=10,859 loops=1)

23. 8.970 493.695 ↓ 10,859.0 10,859 1

Nested Loop Left Join (cost=14.62..2,470.06 rows=1 width=548) (actual time=136.998..493.695 rows=10,859 loops=1)

24. 12.473 408.712 ↓ 10,859.0 10,859 1

Nested Loop (cost=14.06..2,466.21 rows=1 width=539) (actual time=136.976..408.712 rows=10,859 loops=1)

25. 6.863 309.367 ↓ 10,859.0 10,859 1

Nested Loop (cost=13.50..2,461.62 rows=1 width=482) (actual time=136.959..309.367 rows=10,859 loops=1)

26. 59.955 204.773 ↓ 10,859.0 10,859 1

Hash Right Join (cost=12.94..2,455.56 rows=1 width=478) (actual time=136.927..204.773 rows=10,859 loops=1)

  • Hash Cond: ((monitoring.registration_document_id_)::text = (crd.registration_document_id_)::text)
27. 8.442 8.442 ↑ 1.0 54,478 1

Seq Scan on cmm_registration_document_monitoring monitoring (cost=0.00..2,234.63 rows=55,463 width=42) (actual time=0.003..8.442 rows=54,478 loops=1)

28. 17.559 136.376 ↓ 10,859.0 10,859 1

Hash (cost=12.92..12.92 rows=1 width=472) (actual time=136.376..136.376 rows=10,859 loops=1)

  • Buckets: 1024 Batches: 2 (originally 1) Memory Usage: 4097kB
29. 118.817 118.817 ↓ 10,859.0 10,859 1

Index Scan using cmm_registration_doc_idx04 on cmm_registration_document crd (cost=0.43..12.92 rows=1 width=472) (actual time=0.158..118.817 rows=10,859 loops=1)

  • Index Cond: (((stu_date_)::text >= '20190601'::text) AND ((stu_date_)::text <= '20190701'::text))
  • Filter: ((site_id_)::text = ANY ('{VA23002,24029,VQ00001,VB23103,V500001,VG00001,VA23004,VA00008,VA23001,VA23007,VA23009,VA23008,VA23006,VB23003,VB23002,VF00001,VC23001,VA23005,9V0001,V100001,V100002,V123002,V123004,VA00001,VA00002,VA00003,VA00004,VA00005,VA00006,VA00007,VA00009,VA00010,VA00011,VA00012,VAVA001,VAVA002,VC23002,VE00001,VF00002,VH23001,VI23001,VI23002,VJ23001,VK23001,VL23001,VM23001,VM23002,VM23003,VM23004,VP23002,VB23005,924114,VB23101,VM00001,VL23002,VD23001,9VM001,VG23001,V123003,VAVA003,VP23001,VP00001,VA23003}'::text[]))
  • Rows Removed by Filter: 54389
30. 97.731 97.731 ↑ 1.0 1 10,859

Index Scan using cmm_registration_document_dtl_idx01 on cmm_registration_document_dtl crdd (cost=0.56..6.04 rows=1 width=60) (actual time=0.008..0.009 rows=1 loops=10,859)

  • Index Cond: ((registration_document_id_)::text = (crd.registration_document_id_)::text)
  • Filter: ((document_type_)::text = 'C174FAKTUR'::text)
  • Rows Removed by Filter: 1
31. 86.872 86.872 ↑ 1.0 1 10,859

Index Scan using serialized_product_identifier_idx01 on cmm_serialized_product_identifier identifier (cost=0.56..4.58 rows=1 width=57) (actual time=0.008..0.008 rows=1 loops=10,859)

  • Index Cond: ((serialized_product_id_)::text = (crd.serialized_product_id_)::text)
32. 76.013 76.013 ↑ 1.0 1 10,859

Index Only Scan using cmm_registration_doc_role_idx01 on cmm_registration_document_role crdr (cost=0.56..3.84 rows=1 width=42) (actual time=0.007..0.007 rows=1 loops=10,859)

  • Index Cond: ((registration_document_detail_id_ = (crdd.registration_document_detail_id_)::text) AND (registration_document_role_type_ = 'C173APPROVE'::text))
  • Heap Fetches: 7069
33. 43.436 43.436 ↑ 1.0 1 10,859

Index Only Scan using cmm_registration_doc_role_idx01 on cmm_registration_document_role crdra (cost=0.56..3.84 rows=1 width=42) (actual time=0.003..0.004 rows=1 loops=10,859)

  • Index Cond: ((registration_document_detail_id_ = (crdd.registration_document_detail_id_)::text) AND (registration_document_role_type_ = 'C173PRINT'::text))
  • Heap Fetches: 10808
34. 97.731 97.731 ↑ 1.0 1 10,859

Index Scan using serialized_product_manifest_info_idx01 on cmm_serialized_product_manifest_info manifest (cost=0.56..3.85 rows=1 width=41) (actual time=0.008..0.009 rows=1 loops=10,859)

  • Index Cond: ((serialized_product_id_)::text = (identifier.serialized_product_id_)::text)
  • Filter: ((manifest_type_)::text = 'C186MANUFACTUREMANIFEST'::text)
  • Rows Removed by Filter: 0
35. 43.436 43.436 ↑ 1.0 1 10,859

Index Scan using pk_product on cmm_product pro (cost=0.42..4.44 rows=1 width=73) (actual time=0.004..0.004 rows=1 loops=10,859)

  • Index Cond: ((product_id_)::text = (crd.product_id_)::text)
36. 43.436 43.436 ↑ 1.0 45 10,859

Seq Scan on cmm_color_info color (cost=0.00..1.45 rows=45 width=47) (actual time=0.001..0.004 rows=45 loops=10,859)

37. 32.577 32.577 ↑ 1.0 1 10,859

Index Scan using pk_geography_boundary on cmm_geography_boundary gbdis (cost=0.28..4.30 rows=1 width=47) (actual time=0.003..0.003 rows=1 loops=10,859)

  • Index Cond: ((geography_id_)::text = (crd.user_district_id_)::text)
38. 32.577 32.577 ↑ 1.0 1 10,859

Index Scan using cmm_geography_rollup_idx_12 on cmm_geography_rollup grdis (cost=0.28..4.30 rows=1 width=74) (actual time=0.003..0.003 rows=1 loops=10,859)

  • Index Cond: ((to_geography_id_)::text = (crd.user_district_id_)::text)
39. 21.718 21.718 ↑ 1.0 1 10,859

Index Scan using pk_geography_boundary on cmm_geography_boundary gbctiy (cost=0.28..3.51 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=10,859)

  • Index Cond: ((geography_id_)::text = (grdis.from_geography_id_)::text)
40. 21.718 21.718 ↑ 1.0 1 10,859

Index Scan using cmm_geography_rollup_idx_12 on cmm_geography_rollup grcity (cost=0.28..3.52 rows=1 width=74) (actual time=0.002..0.002 rows=1 loops=10,859)

  • Index Cond: ((to_geography_id_)::text = (gbctiy.geography_id_)::text)
41. 21.718 21.718 ↑ 1.0 1 10,859

Index Scan using pk_geography_boundary on cmm_geography_boundary gbpro (cost=0.28..3.51 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=10,859)

  • Index Cond: ((geography_id_)::text = (grcity.from_geography_id_)::text)
42. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo leasing (cost=0.00..1.22 rows=61 width=614) (actual time=0.000..0.007 rows=66 loops=10,859)

43. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo instansi (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

44. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo gender (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

45. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo job (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

46. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo payment (cost=0.00..1.22 rows=61 width=614) (actual time=0.000..0.007 rows=66 loops=10,859)

47. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo down (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

48. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo term (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

49. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo education (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

50. 76.013 76.013 ↓ 1.1 66 10,859

CTE Scan on codeinfo expending (cost=0.00..1.22 rows=61 width=196) (actual time=0.000..0.007 rows=66 loops=10,859)

51. 43.436 43.436 ↑ 1.0 1 10,859

Index Scan using cmm_product_feature_idx_11 on cmm_product_feature profeature (cost=0.42..4.44 rows=1 width=39) (actual time=0.004..0.004 rows=1 loops=10,859)

  • Index Cond: (((product_id_)::text = (crd.product_id_)::text) AND ((product_feature_category_id_)::text = 'GOODSDISPLACEMENT'::text))
52. 76.013 76.013 ↑ 1.0 1 10,859

Index Scan using pk_consumer_info on cmm_consumer_info consumer (cost=0.56..4.58 rows=1 width=29) (actual time=0.007..0.007 rows=1 loops=10,859)

  • Index Cond: ((consumer_id_)::text = (crd.user_consumer_id_)::text)
Planning time : 9.966 ms
Execution time : 2,553.908 ms