Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- --проверить планы запросов на источнике:
- --в плане должно работать по индексу year, month
- CREATE TABLE ebanalyticsm.pd_by_led_for_pafo_stage_2019_01 AS
- SELECT guid
- FROM ebanalyticsm.eb_payment_documents_pafo_v
- WHERE year = 2019
- AND month = 01;
- --в плане должно работать по индексу year, month ИЛИ если led свежий, то по led
- CREATE TABLE ebanalyticsm.pd_by_led_for_pafo_stage_2019_01 AS
- SELECT guid
- FROM ebanalyticsm.eb_payment_documents_pafo_v
- WHERE year = 2019
- AND month = 01
- AND last_editing_date >= '2019-02-01 01:01:00'::timestamp;
- --в плане должно работать по индексу по v.payment_document_guid
- SELECT
- v.guid::uuid,
- payment_document_guid::uuid,
- period_year,
- period_month
- FROM ebanalyticsm.eb_payment_document_charges_pafo_v v
- JOIN ebanalyticsm.pd_by_led_for_pafo_stage_2019_01 t ON t.guid = v.payment_document_guid';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement