explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iErt : V2

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 257.551 ↑ 1.0 1 1

Sort (cost=99,078.18..99,078.19 rows=1 width=729) (actual time=257.550..257.551 rows=1 loops=1)

  • Sort Key: cmmparty.party_code_, cmmregdoc.frame_no_
  • Sort Method: quicksort Memory: 25kB
2. 0.017 257.535 ↑ 1.0 1 1

Nested Loop (cost=222.26..99,078.17 rows=1 width=729) (actual time=246.672..257.535 rows=1 loops=1)

3. 0.004 257.507 ↑ 1.0 1 1

Nested Loop (cost=222.12..99,077.99 rows=1 width=249) (actual time=246.646..257.507 rows=1 loops=1)

4. 0.003 257.484 ↑ 1.0 1 1

Nested Loop (cost=221.70..99,073.55 rows=1 width=250) (actual time=246.624..257.484 rows=1 loops=1)

5. 0.006 257.467 ↑ 1.0 1 1

Nested Loop (cost=221.42..99,073.18 rows=1 width=315) (actual time=246.608..257.467 rows=1 loops=1)

6. 0.474 257.442 ↑ 1.0 1 1

Nested Loop (cost=221.14..99,068.87 rows=1 width=263) (actual time=246.585..257.442 rows=1 loops=1)

  • Join Filter: ((mst.site_code_)::text = (cmmsitemst.site_id_)::text)
  • Rows Removed by Join Filter: 3527
7. 13.536 13.536 ↑ 1.0 3,528 1

Index Scan using cmm_site_mst_idx03 on cmm_site_mst cmmsitemst (cost=0.28..336.96 rows=3,651 width=42) (actual time=1.228..13.536 rows=3,528 loops=1)

8. 0.962 243.432 ↑ 1.0 1 3,528

Materialize (cost=220.86..98,677.14 rows=1 width=240) (actual time=0.005..0.069 rows=1 loops=3,528)

9. 0.027 242.470 ↑ 1.0 1 1

Nested Loop (cost=220.86..98,677.14 rows=1 width=240) (actual time=19.041..242.470 rows=1 loops=1)

10. 0.552 241.693 ↓ 75.0 75 1

Nested Loop (cost=220.43..98,672.67 rows=1 width=200) (actual time=18.614..241.693 rows=75 loops=1)

11. 0.722 5.365 ↓ 2.2 614 1

Hash Join (cost=188.15..538.08 rows=277 width=6) (actual time=3.093..5.365 rows=614 loops=1)

  • Hash Cond: ((relation.from_organization_id_)::text = (mst.organization_id_)::text)
12. 2.137 2.137 ↓ 1.1 614 1

Seq Scan on cmm_party_relation relation (cost=0.00..342.82 rows=579 width=36) (actual time=0.555..2.137 rows=614 loops=1)

  • Filter: ((party_relation_type_id_)::text = 'C028DEALERUNITMAINDEALER'::text)
  • Rows Removed by Filter: 6664
13. 0.943 2.506 ↑ 1.0 3,528 1

Hash (cost=142.51..142.51 rows=3,651 width=42) (actual time=2.506..2.506 rows=3,528 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 262kB
14. 1.563 1.563 ↑ 1.0 3,528 1

Seq Scan on cmm_site_mst mst (cost=0.00..142.51 rows=3,651 width=42) (actual time=0.004..1.563 rows=3,528 loops=1)

15. 196.480 235.776 ↓ 0.0 0 614

Bitmap Heap Scan on cmm_registration_document cmmregdoc (cost=32.29..354.27 rows=1 width=194) (actual time=0.361..0.384 rows=0 loops=614)

  • Recheck Cond: ((site_id_)::text = (mst.site_code_)::text)
  • Filter: (((request_faktur_date_)::text >= '20191005'::text) AND ((request_faktur_date_)::text <= '20191105'::text))
  • Rows Removed by Filter: 237
  • Heap Blocks: exact=116549
16. 39.296 39.296 ↑ 12.3 237 614

Bitmap Index Scan on cmm_registration_doc_idx02 (cost=0.00..32.29 rows=2,911 width=0) (actual time=0.064..0.064 rows=237 loops=614)

  • Index Cond: ((site_id_)::text = (mst.site_code_)::text)
17. 0.750 0.750 ↓ 0.0 0 75

Index Scan using rrr on cmm_faktur_nik_document fk (cost=0.43..4.46 rows=1 width=64) (actual time=0.010..0.010 rows=0 loops=75)

  • Index Cond: ((registration_document_id_)::text = (cmmregdoc.registration_document_id_)::text)
  • Filter: ((faktur_print_times_ > 1) AND ((status_)::text = 'C176WAITINGFORALLOCAPPROVE'::text))
  • Rows Removed by Filter: 1
18. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_cmm_organization_info on cmm_organization_info cmmorginfo (cost=0.28..4.30 rows=1 width=52) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((party_id_)::text = (cmmregdoc.organization_id_)::text)
19. 0.014 0.014 ↑ 1.0 1 1

Index Scan using cmm_party_info_pkey on cmm_party_info cmmparty (cost=0.28..0.36 rows=1 width=43) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((party_id_)::text = (cmmorginfo.party_id_)::text)
20. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_product_add on cmm_product cmmpro (cost=0.42..4.44 rows=1 width=73) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: ((product_id_)::text = (cmmregdoc.product_id_)::text)
21. 0.011 0.011 ↑ 1.0 1 1

Index Scan using cmm_area_mst_pkey on cmm_area_mst cmmareamst (cost=0.14..0.17 rows=1 width=614) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((geography_id_)::text = (cmmsitemst.area_id_)::text)
Planning time : 7.229 ms
Execution time : 257.819 ms