Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In

Have an account? Sign In Now

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

StackOverflow Point

StackOverflow Point Navigation

  • Web Stories
  • Badges
  • Tags
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Web Stories
  • Badges
  • Tags
Home/ Questions/Q 3783
Alex Hales
  • 0
Alex HalesTeacher
Asked: June 3, 20222022-06-03T02:15:27+00:00 2022-06-03T02:15:27+00:00

database – pgloader mysql to postgres

  • 0

[ad_1]

2022-06-03T01:47:41.714000Z NOTICE CREATE TABLE dbname.watch
(
wid bigserial not null,
uid bigint not null default ‘0’,
type varchar(64) not null default ”,
message text not null,
variables bytea not null,
severity smallint not null default ‘0’,
link text,
location text not null,
referer text,
hostname varchar(128) not null default ”,
timestamp bigint not null default ‘0’
);

2022-06-03T01:47:41.914000Z NOTICE COPY dbname.watch
2022-06-03T01:47:41.921000Z NOTICE SET search_path TO username;
2022-06-03T01:47:41.921000Z NOTICE CREATE UNIQUE INDEX idx_1352804_primary ON dbname.watch (wid);
2022-06-03T01:47:41.921000Z NOTICE CREATE INDEX idx_1352804_uid ON dbname.watch (uid);
2022-06-03T01:47:41.921000Z NOTICE CREATE INDEX idx_1352804_severity ON dbname.watch (severity);
2022-06-03T01:47:41.921000Z NOTICE CREATE INDEX idx_1352804_type ON dbname.watch (type);
2022-06-03T01:47:41.921000Z NOTICE Complete PostgreSQL database.

2022-06-03T01:47:41.921000Z NOTICE CREATE INDEX idx_1352804_severity ON dbname.watch (severity);
2022-06-03T01:47:41.921000Z NOTICE CREATE INDEX idx_1352804_type ON dbname.watch (type);
2022-06-03T01:47:41.921000Z NOTICE Complete PostgreSQL database.
2022-06-03T01:47:41.921000Z NOTICE Reset sequences
2022-06-03T01:47:41.921000Z NOTICE ALTER TABLE dbname.watch ADD PRIMARY KEY USING INDEX idx_1352804_primary;
2022-06-03T01:47:41.921000Z NOTICE comment on table watch is $SJXCK_VBMAW$Table that contains logs of all system events.$SJXCK_VBMAW$
2022-06-03T01:47:41.921000Z NOTICE comment on column watch.wid is $SJXCK_VBMAW$Primary Key: Unique watchdog event ID.$SJXCK_VBMAW$
2022-06-03T01:47:41.921000Z NOTICE comment on column watch.uid is $SJXCK_VBMAW$The “users”.uid of the user who triggered the event.$SJXCK_VBMAW$
2022-06-03T01:47:41.921000Z NOTICE comment on column watch.type is $SJXCK_VBMAW$Type of log message, for example “user” or “page not found.”$SJXCK_VBMAW$
2022-06-03T01:47:41.921000Z NOTICE comment on column watch.message is $SJXCK_VBMAW$Text of log message to be passed into the t() function.$SJXCK_VBMAW$
2022-06-03T01:47:41.921000Z NOTICE comment on column watch.variables is $SJXCK_VBMAW$Serialized array of variables that match the message string and that is passed into the t() function.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.severity is $SJXCK_VBMAW$The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.link is $SJXCK_VBMAW$Link to view the result of the event.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.location is $SJXCK_VBMAW$URL of the origin of the event.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.referer is $SJXCK_VBMAW$URL of referring page.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.hostname is $SJXCK_VBMAW$Hostname of the user who triggered the event.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z NOTICE comment on column watch.timestamp is $SJXCK_VBMAW$Unix timestamp of when event occurred.$SJXCK_VBMAW$
2022-06-03T01:47:41.922000Z LOG report summary reset
table name read imported errors total time read write


        before load          2          2          0          0.013s
    fetch meta data          5          5          0          0.347s
     Create Schemas          0          0          0          0.005s
   Create SQL Types          0          0          0          0.010s
      Create tables          2          2          0          0.037s
     Set Table OIDs          1          1          0          0.006s

dbname.watch 0 0 0 0.027s 0.027s


COPY Threads Completion 8 8 0 0.028s
Index Build Completion 4 4 0 0.038s
Create Indexes 4 4 0 0.052s
Reset Sequences 1 1 0 0.043s
Primary Keys 1 1 0 0.003s
Create Foreign Keys 0 0 0 0.000s
Create Triggers 0 0 0 0.000s
Install Comments 12 12 0 0.013s


Total import time          0          0          0          0.929s     0.027s    0.000s

[ad_2]

  • 0 0 Answers
  • 17 Views
  • 0 Followers
  • 0
Share
  • Facebook
  • Report
Leave an answer

Leave an answer
Cancel reply

Browse

Sidebar

Ask A Question

Related Questions

  • xcode - Can you build dynamic libraries for iOS and ...

    • 0 Answers
  • bash - How to check if a process id (PID) ...

    • 8038 Answers
  • database - Oracle: Changing VARCHAR2 column to CLOB

    • 1840 Answers
  • What's the difference between HEAD, working tree and index, in ...

    • 1919 Answers
  • Amazon EC2 Free tier - how many instances can I ...

    • 0 Answers

Stats

  • Questions : 43k

Subscribe

Login

Forgot Password?

Footer

Follow

© 2022 Stackoverflow Point. All Rights Reserved.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.