explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s4Fe : v3

Settings
# exclusive inclusive rows x rows loops node
1. 10.093 770.213 ↓ 20.6 10,859 1

Nested Loop (cost=2,770.71..22,346.99 rows=526 width=337) (actual time=50.178..770.213 rows=10,859 loops=1)

2. 11.415 684.107 ↓ 20.6 10,859 1

Nested Loop Left Join (cost=2,770.15..19,930.02 rows=526 width=362) (actual time=50.155..684.107 rows=10,859 loops=1)

3. 9.684 629.256 ↓ 20.6 10,859 1

Hash Left Join (cost=2,769.73..17,892.18 rows=526 width=397) (actual time=50.128..629.256 rows=10,859 loops=1)

  • Hash Cond: ((grcity.from_geography_id_)::text = (gbpro.geography_id_)::text)
4. 10.162 616.142 ↓ 20.6 10,859 1

Hash Left Join (cost=2,437.54..17,548.81 rows=526 width=424) (actual time=46.683..616.142 rows=10,859 loops=1)

  • Hash Cond: ((gbctiy.geography_id_)::text = (grcity.to_geography_id_)::text)
5. 10.521 603.096 ↓ 20.6 10,859 1

Hash Left Join (cost=2,062.75..17,162.86 rows=526 width=424) (actual time=43.789..603.096 rows=10,859 loops=1)

  • Hash Cond: ((grdis.from_geography_id_)::text = (gbctiy.geography_id_)::text)
6. 13.712 589.597 ↓ 20.6 10,859 1

Hash Left Join (cost=1,730.56..16,819.49 rows=526 width=414) (actual time=40.802..589.597 rows=10,859 loops=1)

  • Hash Cond: ((crd.user_district_id_)::text = (grdis.to_geography_id_)::text)
7. 13.583 572.773 ↓ 20.6 10,859 1

Hash Left Join (cost=1,355.78..16,433.53 rows=526 width=410) (actual time=37.679..572.773 rows=10,859 loops=1)

  • Hash Cond: ((crd.user_district_id_)::text = (gbdis.geography_id_)::text)
8. 8.022 555.839 ↓ 20.6 10,859 1

Hash Left Join (cost=1,023.59..16,090.16 rows=526 width=400) (actual time=34.319..555.839 rows=10,859 loops=1)

  • Hash Cond: ((crd.color_id_)::text = (color.color_id_)::text)
9. 12.714 547.794 ↓ 20.6 10,859 1

Nested Loop Left Join (cost=1,021.58..16,080.92 rows=526 width=427) (actual time=34.284..547.794 rows=10,859 loops=1)

10. 13.003 502.503 ↓ 20.6 10,859 1

Nested Loop Left Join (cost=1,021.02..14,054.76 rows=526 width=446) (actual time=34.276..502.503 rows=10,859 loops=1)

11. 13.542 424.346 ↓ 20.6 10,859 1

Nested Loop (cost=1,020.46..12,028.60 rows=526 width=437) (actual time=34.260..424.346 rows=10,859 loops=1)

12. 8.172 334.791 ↓ 23.4 10,859 1

Nested Loop (cost=1,019.90..9,223.56 rows=464 width=433) (actual time=34.244..334.791 rows=10,859 loops=1)

13. 8.356 283.183 ↓ 23.4 10,859 1

Nested Loop (cost=1,019.48..7,383.92 rows=464 width=397) (actual time=34.229..283.183 rows=10,859 loops=1)

  • Join Filter: ((crd.serialized_product_id_)::text = (manifest.serialized_product_id_)::text)
14. 8.620 187.955 ↓ 23.4 10,859 1

Nested Loop (cost=1,018.92..5,591.95 rows=464 width=434) (actual time=34.211..187.955 rows=10,859 loops=1)

15. 50.115 92.463 ↓ 23.4 10,859 1

Hash Right Join (cost=1,018.35..3,461.03 rows=464 width=377) (actual time=34.191..92.463 rows=10,859 loops=1)

  • Hash Cond: ((monitoring.registration_document_id_)::text = (crd.registration_document_id_)::text)
16. 8.554 8.554 ↑ 1.0 54,479 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.554 rows=54,479 loops=1)

17. 12.184 33.794 ↓ 23.4 10,859 1

Hash (cost=1,012.55..1,012.55 rows=464 width=371) (actual time=33.794..33.794 rows=10,859 loops=1)

  • Buckets: 1024 Batches: 2 (originally 1) Memory Usage: 4097kB
18. 21.610 21.610 ↓ 23.4 10,859 1

Index Scan using cmm_registration_doc_idx02 on cmm_registration_document crd (cost=0.63..1,012.55 rows=464 width=371) (actual time=0.044..21.610 rows=10,859 loops=1)

  • Index Cond: (((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[])) AND ((request_date_)::text >= '20190601'::text) AND ((request_date_)::text <= '20190701'::text))
19. 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.007..0.008 rows=1 loops=10,859)

  • Index Cond: ((serialized_product_id_)::text = (crd.serialized_product_id_)::text)
20. 86.872 86.872 ↑ 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.008 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
21. 43.436 43.436 ↑ 1.0 1 10,859

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

  • Index Cond: ((product_id_)::text = (crd.product_id_)::text)
22. 76.013 76.013 ↑ 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.007..0.007 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
23. 65.154 65.154 ↑ 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.006..0.006 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
24. 32.577 32.577 ↑ 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.003 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
25. 0.010 0.023 ↑ 1.0 45 1

Hash (cost=1.45..1.45 rows=45 width=47) (actual time=0.023..0.023 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
26. 0.013 0.013 ↑ 1.0 45 1

Seq Scan on cmm_color_info color (cost=0.00..1.45 rows=45 width=47) (actual time=0.003..0.013 rows=45 loops=1)

27. 1.730 3.351 ↑ 1.0 7,563 1

Hash (cost=237.64..237.64 rows=7,564 width=47) (actual time=3.351..3.351 rows=7,563 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 591kB
28. 1.621 1.621 ↑ 1.0 7,563 1

Seq Scan on cmm_geography_boundary gbdis (cost=0.00..237.64 rows=7,564 width=47) (actual time=0.002..1.621 rows=7,563 loops=1)

29. 1.479 3.112 ↑ 1.0 7,517 1

Hash (cost=280.46..280.46 rows=7,546 width=74) (actual time=3.112..3.112 rows=7,517 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 779kB
30. 1.633 1.633 ↑ 1.0 7,517 1

Seq Scan on cmm_geography_rollup grdis (cost=0.00..280.46 rows=7,546 width=74) (actual time=0.004..1.633 rows=7,517 loops=1)

31. 1.663 2.978 ↑ 1.0 7,563 1

Hash (cost=237.64..237.64 rows=7,564 width=47) (actual time=2.978..2.978 rows=7,563 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 591kB
32. 1.315 1.315 ↑ 1.0 7,563 1

Seq Scan on cmm_geography_boundary gbctiy (cost=0.00..237.64 rows=7,564 width=47) (actual time=0.002..1.315 rows=7,563 loops=1)

33. 1.633 2.884 ↑ 1.0 7,517 1

Hash (cost=280.46..280.46 rows=7,546 width=74) (actual time=2.884..2.884 rows=7,517 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 779kB
34. 1.251 1.251 ↑ 1.0 7,517 1

Seq Scan on cmm_geography_rollup grcity (cost=0.00..280.46 rows=7,546 width=74) (actual time=0.002..1.251 rows=7,517 loops=1)

35. 2.182 3.430 ↑ 1.0 7,563 1

Hash (cost=237.64..237.64 rows=7,564 width=47) (actual time=3.430..3.430 rows=7,563 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 591kB
36. 1.248 1.248 ↑ 1.0 7,563 1

Seq Scan on cmm_geography_boundary gbpro (cost=0.00..237.64 rows=7,564 width=47) (actual time=0.002..1.248 rows=7,563 loops=1)

37. 43.436 43.436 ↑ 1.0 1 10,859

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

  • Index Cond: ((product_id_)::text = (crd.product_id_)::text)
  • Filter: ((product_feature_category_id_)::text = 'GOODSDISPLACEMENT'::text)
  • Rows Removed by Filter: 1
38. 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 : 6.662 ms
Execution time : 771.550 ms