explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KF4L : exst

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 1,529.515 ↓ 4.0 4 1

Sort (cost=226,068.46..226,068.46 rows=1 width=738) (actual time=1,529.515..1,529.515 rows=4 loops=1)

  • Sort Key: cmmparty.party_code_, cmmregdoc.frame_no_
  • Sort Method: quicksort Memory: 26kB
2. 0.028 1,529.487 ↓ 4.0 4 1

Nested Loop Semi Join (cost=1.53..226,068.45 rows=1 width=738) (actual time=889.241..1,529.487 rows=4 loops=1)

  • Join Filter: ((cmmsitemst.site_id_)::text = (mst.site_code_)::text)
3. 0.031 1,527.387 ↓ 4.0 4 1

Nested Loop (cost=0.85..225,932.94 rows=1 width=751) (actual time=888.511..1,527.387 rows=4 loops=1)

  • Join Filter: ((cmmsitemst.area_id_)::text = (cmmareamst.geography_id_)::text)
  • Rows Removed by Join Filter: 100
4. 1.625 1,527.336 ↓ 4.0 4 1

Nested Loop (cost=0.85..225,921.59 rows=1 width=271) (actual time=888.495..1,527.336 rows=4 loops=1)

  • Join Filter: ((cmmregdoc.site_id_)::text = (cmmsitemst.site_id_)::text)
  • Rows Removed by Join Filter: 14048
5. 0.017 1,524.019 ↓ 4.0 4 1

Nested Loop (cost=0.85..225,735.21 rows=1 width=229) (actual time=888.054..1,524.019 rows=4 loops=1)

6. 1.913 1,523.962 ↓ 4.0 4 1

Nested Loop (cost=0.43..225,734.62 rows=1 width=230) (actual time=888.038..1,523.962 rows=4 loops=1)

  • Join Filter: ((cmmorginfo.party_id_)::text = (cmmparty.party_id_)::text)
  • Rows Removed by Join Filter: 15844
7. 2.164 1,520.329 ↓ 4.0 4 1

Nested Loop (cost=0.43..225,571.39 rows=1 width=295) (actual time=887.522..1,520.329 rows=4 loops=1)

  • Join Filter: ((cmmregdoc.organization_id_)::text = (cmmorginfo.party_id_)::text)
  • Rows Removed by Join Filter: 15512
8. 0.039 1,516.469 ↓ 4.0 4 1

Nested Loop (cost=0.43..225,274.20 rows=1 width=243) (actual time=886.903..1,516.469 rows=4 loops=1)

9. 1,516.358 1,516.358 ↓ 4.0 4 1

Seq Scan on cmm_registration_document_dtl cmmregdocdtl (cost=0.00..225,269.74 rows=1 width=73) (actual time=886.847..1,516.358 rows=4 loops=1)

  • Filter: ((print_times_ > 1) AND ((document_type_)::text = 'C174FAKTUR'::text) AND ((status_)::text = 'C176WAITINGFORALLOCAPPROVE'::text))
  • Rows Removed by Filter: 5134978
10. 0.072 0.072 ↑ 1.0 1 4

Index Scan using cmm_registration_document_pkey on cmm_registration_document cmmregdoc (cost=0.43..4.46 rows=1 width=194) (actual time=0.017..0.018 rows=1 loops=4)

  • Index Cond: ((registration_document_id_)::text = (cmmregdocdtl.registration_document_id_)::text)
  • Filter: (((request_faktur_date_)::text >= '20190101'::text) AND ((request_faktur_date_)::text <= '20190805'::text))
11. 1.696 1.696 ↓ 1.0 3,879 4

Seq Scan on cmm_organization_info cmmorginfo (cost=0.00..248.75 rows=3,875 width=52) (actual time=0.002..0.424 rows=3,879 loops=4)

12. 1.720 1.720 ↑ 1.0 3,962 4

Seq Scan on cmm_party_info cmmparty (cost=0.00..113.66 rows=3,966 width=43) (actual time=0.002..0.430 rows=3,962 loops=4)

13. 0.040 0.040 ↑ 1.0 1 4

Index Scan using pk_product_add on cmm_product cmmpro (cost=0.42..0.58 rows=1 width=73) (actual time=0.009..0.010 rows=1 loops=4)

  • Index Cond: ((product_id_)::text = (cmmregdoc.product_id_)::text)
14. 1.692 1.692 ↑ 1.0 3,513 4

Seq Scan on cmm_site_mst cmmsitemst (cost=0.00..141.17 rows=3,617 width=42) (actual time=0.002..0.423 rows=3,513 loops=4)

15. 0.020 0.020 ↑ 2.3 26 4

Seq Scan on cmm_area_mst cmmareamst (cost=0.00..10.60 rows=60 width=614) (actual time=0.002..0.005 rows=26 loops=4)

16. 0.024 2.072 ↑ 1.0 1 4

Nested Loop (cost=0.69..68.09 rows=1 width=6) (actual time=0.518..0.518 rows=1 loops=4)

17. 0.024 0.024 ↑ 1.0 1 4

Index Scan using cmm_site_mst_idx04 on cmm_site_mst mst (cost=0.28..0.31 rows=1 width=42) (actual time=0.006..0.006 rows=1 loops=4)

  • Index Cond: ((site_code_)::text = (cmmregdoc.site_id_)::text)
18. 2.024 2.024 ↑ 1.0 1 4

Index Only Scan using cmm_party_relation_idx01 on cmm_party_relation relation (cost=0.41..67.77 rows=1 width=35) (actual time=0.506..0.506 rows=1 loops=4)

  • Index Cond: ((party_relation_type_id_ = 'C028DEALERUNITMAINDEALER'::text) AND (from_organization_id_ = (mst.organization_id_)::text))
  • Heap Fetches: 4
Planning time : 2.752 ms
Execution time : 1,529.720 ms