explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t8Bt : 1

Settings
# exclusive inclusive rows x rows loops node
1. 3.069 225.322 ↓ 6,705.0 6,705 1

Hash Right Join (cost=234.45..235.81 rows=1 width=5,830) (actual time=222.268..225.322 rows=6,705 loops=1)

  • Hash Cond: ((expending.code_dbid_)::text = (main.user_expending_range_)::text)
2.          

CTE main

3. 2.705 101.636 ↓ 6,705.0 6,705 1

Nested Loop (cost=2.04..167.85 rows=1 width=559) (actual time=0.066..101.636 rows=6,705 loops=1)

4. 4.609 78.816 ↓ 6,705.0 6,705 1

Nested Loop (cost=1.62..163.41 rows=1 width=523) (actual time=0.056..78.816 rows=6,705 loops=1)

5. 8.364 52.820 ↓ 7,129.0 7,129 1

Nested Loop (cost=1.06..158.81 rows=1 width=419) (actual time=0.043..52.820 rows=7,129 loops=1)

6. 8.786 8.786 ↓ 7,134.0 7,134 1

Index Scan using cmm_registration_doc_idx02 on cmm_registration_document crd (cost=0.51..153.52 rows=1 width=391) (actual time=0.019..8.786 rows=7,134 loops=1)

  • Index Cond: (((site_id_)::text = ANY ('{VA00008,VAVA003,VA23009,VA23005,VF00002,VF00001,VP00001,VP23002,V100002,VAVA001,VJ23001,VB23002,V123003,VQ00001,VA23001,VA00005,9V0001,VC23002,VAVA002,VA00010,VI23002,VM23003,VG00001,VL230 (...)
7. 35.670 35.670 ↑ 1.0 1 7,134

Index Scan using cmm_registration_document_dtl_idx01 on cmm_registration_document_dtl crdd (cost=0.56..5.28 rows=1 width=52) (actual time=0.005..0.005 rows=1 loops=7,134)

  • Index Cond: ((registration_document_id_)::text = (crd.registration_document_id_)::text)
  • Filter: ((print_times_ >= 1) AND ((document_type_)::text = 'C174FAKTUR'::text))
  • Rows Removed by Filter: 1
8. 21.387 21.387 ↑ 1.0 1 7,129

Index Scan using serialized_product_identifier_idx01 on cmm_serialized_product_identifier identifier (cost=0.56..4.58 rows=1 width=153) (actual time=0.003..0.003 rows=1 loops=7,129)

  • Index Cond: ((serialized_product_id_)::text = (crd.serialized_product_id_)::text)
9. 20.115 20.115 ↑ 1.0 1 6,705

Index Scan using pk_product on cmm_product pro (cost=0.41..4.44 rows=1 width=73) (actual time=0.002..0.003 rows=1 loops=6,705)

  • Index Cond: ((product_id_)::text = (crd.product_id_)::text)
10.          

CTE codeinfo

11. 0.416 0.416 ↓ 1.1 61 1

Seq Scan on cmm_mst_code_info (cost=0.00..46.80 rows=57 width=31) (actual time=0.081..0.416 rows=61 loops=1)

  • Filter: ((code_id_)::text = ANY ('{C017,C180,C093,C171,C030,C172,C181,C182,C170}'::text[]))
  • Rows Removed by Filter: 1012
12. 0.010 0.010 ↓ 1.1 61 1

CTE Scan on codeinfo expending (cost=0.00..1.14 rows=57 width=196) (actual time=0.000..0.010 rows=61 loops=1)

13. 6.086 222.243 ↓ 6,705.0 6,705 1

Hash (cost=19.78..19.78 rows=1 width=5,732) (actual time=222.243..222.243 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3021kB
14. 2.951 216.157 ↓ 6,705.0 6,705 1

Hash Right Join (cost=18.42..19.78 rows=1 width=5,732) (actual time=213.230..216.157 rows=6,705 loops=1)

  • Hash Cond: ((education.code_dbid_)::text = (main.user_education_)::text)
15. 0.005 0.005 ↓ 1.1 61 1

CTE Scan on codeinfo education (cost=0.00..1.14 rows=57 width=196) (actual time=0.001..0.005 rows=61 loops=1)

16. 6.158 213.201 ↓ 6,705.0 6,705 1

Hash (cost=18.40..18.40 rows=1 width=5,634) (actual time=213.201..213.201 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3021kB
17. 2.895 207.043 ↓ 6,705.0 6,705 1

Hash Right Join (cost=17.04..18.40 rows=1 width=5,634) (actual time=204.178..207.043 rows=6,705 loops=1)

  • Hash Cond: ((term.code_dbid_)::text = (main.tenor_range_)::text)
18. 0.008 0.008 ↓ 1.1 61 1

CTE Scan on codeinfo term (cost=0.00..1.14 rows=57 width=196) (actual time=0.001..0.008 rows=61 loops=1)

19. 6.347 204.140 ↓ 6,705.0 6,705 1

Hash (cost=17.03..17.03 rows=1 width=5,536) (actual time=204.140..204.140 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3021kB
20. 3.107 197.793 ↓ 6,705.0 6,705 1

Hash Right Join (cost=15.66..17.03 rows=1 width=5,536) (actual time=194.709..197.793 rows=6,705 loops=1)

  • Hash Cond: ((down.code_dbid_)::text = (main.down_payment_range_)::text)
21. 0.008 0.008 ↓ 1.1 61 1

CTE Scan on codeinfo down (cost=0.00..1.14 rows=57 width=196) (actual time=0.001..0.008 rows=61 loops=1)

22. 6.263 194.678 ↓ 6,705.0 6,705 1

Hash (cost=15.65..15.65 rows=1 width=5,438) (actual time=194.678..194.678 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3021kB
23. 3.598 188.415 ↓ 6,705.0 6,705 1

Hash Right Join (cost=14.29..15.65 rows=1 width=5,438) (actual time=184.825..188.415 rows=6,705 loops=1)

  • Hash Cond: ((payment.code_dbid_)::text = (main.payment_method_type_)::text)
24. 0.011 0.011 ↓ 1.1 61 1

CTE Scan on codeinfo payment (cost=0.00..1.14 rows=57 width=614) (actual time=0.001..0.011 rows=61 loops=1)

25. 7.338 184.806 ↓ 6,705.0 6,705 1

Hash (cost=14.27..14.27 rows=1 width=4,922) (actual time=184.806..184.806 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2981kB
26. 1.046 177.468 ↓ 6,705.0 6,705 1

Nested Loop Left Join (cost=4.85..14.27 rows=1 width=4,922) (actual time=146.021..177.468 rows=6,705 loops=1)

27. 6.807 156.307 ↓ 6,705.0 6,705 1

Nested Loop Left Join (cost=4.30..9.70 rows=1 width=4,922) (actual time=146.001..156.307 rows=6,705 loops=1)

  • -> Index Only Scan using cmm_registration_document_monitoring_idx01 on cmm_registration_document_monitoring monitoring (cost=0.14..4.16 rows=1 width=98) (actual time=0.001..0.001 rows=0 (...)
28. 3.535 149.500 ↓ 6,705.0 6,705 1

Hash Right Join (cost=4.16..5.53 rows=1 width=4,922) (actual time=145.980..149.500 rows=6,705 loops=1)

  • Hash Cond: ((job.code_dbid_)::text = (main.user_occupation_)::text)
  • Index Cond: (registration_document_id_ = (main.registration_document_id_)::text)
  • Heap Fetches: 5
29. 0.011 0.011 ↓ 1.1 61 1

CTE Scan on codeinfo job (cost=0.00..1.14 rows=57 width=196) (actual time=0.001..0.011 rows=61 loops=1)

30. 6.060 145.954 ↓ 6,705.0 6,705 1

Hash (cost=4.15..4.15 rows=1 width=4,824) (actual time=145.954..145.954 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2981kB
31. 2.771 139.894 ↓ 6,705.0 6,705 1

Hash Right Join (cost=2.79..4.15 rows=1 width=4,824) (actual time=137.137..139.894 rows=6,705 loops=1)

  • Hash Cond: ((gender.code_dbid_)::text = (main.user_gender_type_id_)::text)
32. 0.004 0.004 ↓ 1.1 61 1

CTE Scan on codeinfo gender (cost=0.00..1.14 rows=57 width=196) (actual time=0.000..0.004 rows=61 loops=1)

33. 5.929 137.119 ↓ 6,705.0 6,705 1

Hash (cost=2.77..2.77 rows=1 width=4,726) (actual time=137.119..137.119 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2981kB
34. 3.451 131.190 ↓ 6,705.0 6,705 1

Hash Right Join (cost=1.41..2.77 rows=1 width=4,726) (actual time=127.748..131.190 rows=6,705 loops=1)

  • Hash Cond: ((instansi.code_dbid_)::text = (main.sales_order_type_id_)::text)
35. 0.011 0.011 ↓ 1.1 61 1

CTE Scan on codeinfo instansi (cost=0.00..1.14 rows=57 width=196) (actual time=0.001..0.011 rows=61 loops=1)

36. 6.124 127.728 ↓ 6,705.0 6,705 1

Hash (cost=1.40..1.40 rows=1 width=4,628) (actual time=127.728..127.728 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2968kB
37. 3.088 121.604 ↓ 6,705.0 6,705 1

Hash Right Join (cost=0.03..1.40 rows=1 width=4,628) (actual time=118.537..121.604 rows=6,705 loops=1)

  • Hash Cond: ((leasing.code_dbid_)::text = (main.credit_agent_)::text)
38. 0.445 0.445 ↓ 1.1 61 1

CTE Scan on codeinfo leasing (cost=0.00..1.14 rows=57 width=614) (actual time=0.083..0.445 rows=61 loops=1)

39. 3.397 118.071 ↓ 6,705.0 6,705 1

Hash (cost=0.02..0.02 rows=1 width=4,112) (actual time=118.071..118.071 rows=6,705 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2968kB
40. 114.674 114.674 ↓ 6,705.0 6,705 1

CTE Scan on main (cost=0.00..0.02 rows=1 width=4,112) (actual time=0.076..114.674 rows=6,705 loops=1)

41. 20.115 20.115 ↓ 0.0 0 6,705

Index Only Scan using cmm_registration_doc_role_idx01 on cmm_registration_document_role crdr (cost=0.55..4.57 rows=1 width=37) (actual time=0.003..0.003 rows=0 loops=6,705)

  • Index Cond: ((registration_document_detail_id_ = (main.registration_document_detail_id_)::text) AND (registration_document_role_type_ = 'C173APPROVE'::text))
  • Heap Fetches: 5
Planning time : 2.666 ms
Execution time : 226.411 ms