API tools faq
paste
Advertisement
henikseptiana15

Untitled

henikseptiana15
Feb 2nd, 2018
228
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 7.04 KB | None | 0 0
raw download clone embed print report
  1. "Sort  (cost=31520.95..31521.07 rows=49 width=218) (actual time=4121.610..4121.612 rows=26 loops=1)"
  2. "  Sort Key: a.doc_date, a.doc_no"
  3. "  Sort Method: quicksort  Memory: 31kB"
  4. "  ->  Nested Loop  (cost=21292.29..31519.58 rows=49 width=218) (actual time=303.446..4121.420 rows=26 loops=1)"
  5. "        ->  Seq Scan on m_brand c  (cost=0.00..4.49 rows=1 width=24) (actual time=0.012..0.031 rows=1 loops=1)"
  6. "              Filter: (brand_id = 100093)"
  7. "              Rows Removed by Filter: 118"
  8. "        ->  Hash Right Join  (cost=21292.29..31476.50 rows=49 width=202) (actual time=161.190..220.248 rows=26 loops=1)"
  9. "              Hash Cond: ((e.ref_id = d.in_out_exchange_id) AND (e.ref_doc_type_id = d.doc_type_id))"
  10. "              ->  Seq Scan on in_in_out_exchange e  (cost=0.00..8603.06 rows=210806 width=60) (actual time=0.002..24.174 rows=210806 loops=1)"
  11. "              ->  Hash  (cost=21291.55..21291.55 rows=49 width=158) (actual time=161.112..161.112 rows=26 loops=1)"
  12. "                    Buckets: 1024  Batches: 1  Memory Usage: 6kB"
  13. "                    ->  Hash Right Join  (cost=11638.25..21291.55 rows=49 width=158) (actual time=92.678..161.091 rows=26 loops=1)"
  14. "                          Hash Cond: ((d.req_doc_type_id = a.doc_type_id) AND (d.req_id = a.in_out_exchange_id))"
  15. "                          ->  Seq Scan on in_in_out_exchange d  (cost=0.00..9130.08 rows=69742 width=60) (actual time=0.006..60.345 rows=70355 loops=1)"
  16. "                                Filter: (req_doc_type_id = 599)"
  17. "                                Rows Removed by Filter: 140451"
  18. "                          ->  Hash  (cost=11637.52..11637.52 rows=49 width=114) (actual time=92.623..92.623 rows=26 loops=1)"
  19. "                                Buckets: 1024  Batches: 1  Memory Usage: 4kB"
  20. "                                ->  Hash Join  (cost=3376.37..11637.52 rows=49 width=114) (actual time=82.687..92.605 rows=26 loops=1)"
  21. "                                      Hash Cond: (a.partner_id = b.partner_id)"
  22. "                                      ->  Bitmap Heap Scan on in_in_out_exchange a  (cost=3227.03..11487.18 rows=136 width=88) (actual time=72.934..82.784 rows=338 loops=1)"
  23. "                                            Recheck Cond: ((tenant_id = 10) AND (ou_id = 10) AND (doc_type_id = 599))"
  24. "                                            Filter: (((doc_date)::text >= '20171201'::text) AND ((doc_date)::text <= '20171231'::text) AND (brand_id = 100093))"
  25. "                                            Rows Removed by Filter: 70036"
  26. "                                            ->  Bitmap Index Scan on idx_in_in_out_exchange_01  (cost=0.00..3226.99 rows=70606 width=0) (actual time=22.077..22.077 rows=70374 loops=1)"
  27. "                                                  Index Cond: ((tenant_id = 10) AND (ou_id = 10) AND (doc_type_id = 599))"
  28. "                                      ->  Hash  (cost=136.60..136.60 rows=1019 width=34) (actual time=9.746..9.746 rows=160 loops=1)"
  29. "                                            Buckets: 1024  Batches: 1  Memory Usage: 12kB"
  30. "                                            ->  Seq Scan on m_partner b  (cost=0.00..136.60 rows=1019 width=34) (actual time=0.032..9.588 rows=160 loops=1)"
  31. "                                                  Filter: ((upper((partner_code)::text) ~~ '%NI%'::text) OR (upper((partner_name)::text) ~~ '%NI%'::text))"
  32. "                                                  Rows Removed by Filter: 2670"
  33. "Total runtime: 4121.896 ms"
  34.  
  35. -------------------------------------------------------------------------------------------------------
  36. hilangkan function status report dari select
  37.  
  38. "Sort  (cost=31484.20..31484.32 rows=49 width=202) (actual time=184.482..184.484 rows=26 loops=1)"
  39. "  Sort Key: a.doc_date, a.doc_no"
  40. "  Sort Method: quicksort  Memory: 31kB"
  41. "  ->  Nested Loop  (cost=21292.29..31482.83 rows=49 width=202) (actual time=126.024..184.315 rows=26 loops=1)"
  42. "        ->  Seq Scan on m_brand c  (cost=0.00..4.49 rows=1 width=24) (actual time=0.019..0.033 rows=1 loops=1)"
  43. "              Filter: (brand_id = 100093)"
  44. "              Rows Removed by Filter: 118"
  45. "        ->  Hash Right Join  (cost=21292.29..31476.50 rows=49 width=186) (actual time=125.990..184.214 rows=26 loops=1)"
  46. "              Hash Cond: ((e.ref_id = d.in_out_exchange_id) AND (e.ref_doc_type_id = d.doc_type_id))"
  47. "              ->  Seq Scan on in_in_out_exchange e  (cost=0.00..8603.06 rows=210806 width=52) (actual time=0.001..23.102 rows=210806 loops=1)"
  48. "              ->  Hash  (cost=21291.55..21291.55 rows=49 width=158) (actual time=125.914..125.914 rows=26 loops=1)"
  49. "                    Buckets: 1024  Batches: 1  Memory Usage: 6kB"
  50. "                    ->  Hash Right Join  (cost=11638.25..21291.55 rows=49 width=158) (actual time=55.877..125.886 rows=26 loops=1)"
  51. "                          Hash Cond: ((d.req_doc_type_id = a.doc_type_id) AND (d.req_id = a.in_out_exchange_id))"
  52. "                          ->  Seq Scan on in_in_out_exchange d  (cost=0.00..9130.08 rows=69742 width=60) (actual time=0.007..61.400 rows=70355 loops=1)"
  53. "                                Filter: (req_doc_type_id = 599)"
  54. "                                Rows Removed by Filter: 140451"
  55. "                          ->  Hash  (cost=11637.52..11637.52 rows=49 width=114) (actual time=55.807..55.807 rows=26 loops=1)"
  56. "                                Buckets: 1024  Batches: 1  Memory Usage: 4kB"
  57. "                                ->  Hash Join  (cost=3376.37..11637.52 rows=49 width=114) (actual time=48.094..55.790 rows=26 loops=1)"
  58. "                                      Hash Cond: (a.partner_id = b.partner_id)"
  59. "                                      ->  Bitmap Heap Scan on in_in_out_exchange a  (cost=3227.03..11487.18 rows=136 width=88) (actual time=45.047..52.700 rows=338 loops=1)"
  60. "                                            Recheck Cond: ((tenant_id = 10) AND (ou_id = 10) AND (doc_type_id = 599))"
  61. "                                            Filter: (((doc_date)::text >= '20171201'::text) AND ((doc_date)::text <= '20171231'::text) AND (brand_id = 100093))"
  62. "                                            Rows Removed by Filter: 70036"
  63. "                                            ->  Bitmap Index Scan on idx_in_in_out_exchange_01  (cost=0.00..3226.99 rows=70606 width=0) (actual time=9.858..9.858 rows=70374 loops=1)"
  64. "                                                  Index Cond: ((tenant_id = 10) AND (ou_id = 10) AND (doc_type_id = 599))"
  65. "                                      ->  Hash  (cost=136.60..136.60 rows=1019 width=34) (actual time=3.035..3.035 rows=160 loops=1)"
  66. "                                            Buckets: 1024  Batches: 1  Memory Usage: 12kB"
  67. "                                            ->  Seq Scan on m_partner b  (cost=0.00..136.60 rows=1019 width=34) (actual time=0.044..3.005 rows=160 loops=1)"
  68. "                                                  Filter: ((upper((partner_code)::text) ~~ '%NI%'::text) OR (upper((partner_name)::text) ~~ '%NI%'::text))"
  69. "                                                  Rows Removed by Filter: 2670"
  70. "Total runtime: 184.802 ms"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!