(An Untitled Masterwork)
ActivePublic
Actions

Authored by Pawka on Sep 15 2015, 5:40 AM.

Tags

None

Referenced Files

	F810595:
	Sep 15 2015, 5:40 AM

Subscribers

None

	>>> [2] <connect> phabricator_worker
	<<< [2] <connect> 1,770 us
	>>> [3] <query> SELECT * FROM `worker_activetask` WHERE id IN ('35523384')
	<<< [3] <query> 383 us
	>>> [4] <query> SELECT * FROM `worker_archivetask` WHERE (id in (35523384)) ORDER BY id DESC
	<<< [4] <query> 403 us
	>>> [5] <connect> phabricator_worker
	<<< [5] <connect> 849 us
	>>> [6] <query> UPDATE `worker_activetask` SET `failureTime` = NULL, `taskClass` = 'PhabricatorApplicationTransactionPublishWorker', `leaseOwner` = NULL, `leaseExpires` = '1442295566', `failureCount` = '0', `dataID` = '41437476', `priority` = '1000', `objectPHID` = 'PHID-PROJ-vi7rjrmnk3lcc5aztlqu', `id` = '35523384' WHERE `id` = '35523384'
	<<< [6] <query> 912 us
	>>> [7] <query> SELECT * FROM `worker_taskdata` WHERE id = 41437476
	<<< [7] <query> 1,280 us
	>>> [8] <connect> phabricator_project
	<<< [8] <connect> 929 us
	>>> [9] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' WHERE (phid IN ('PHID-PROJ-vi7rjrmnk3lcc5aztlqu')) ORDER BY `p`.`name` ASC
	<<< [9] <query> 375 us
	>>> [10] <connect> phabricator_file
	<<< [10] <connect> 757 us
	>>> [11] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
	<<< [11] <query> 380 us
	>>> [12] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-bqwrgpmcqb4zxvkyvvop')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
	<<< [12] <query> 356 us
	>>> [13] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-bqwrgpmcqb4zxvkyvvop')
	<<< [13] <query> 305 us
	>>> [14] <query> SELECT * FROM `project_transaction` x WHERE (phid IN ('PHID-XACT-PROJ-uoucbnrl7x3xpjl')) ORDER BY `id` DESC
	<<< [14] <query> 5,872 us
	>>> [15] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' WHERE (phid IN ('PHID-PROJ-vi7rjrmnk3lcc5aztlqu')) ORDER BY `p`.`name` ASC
	<<< [15] <query> 453 us
	>>> [16] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
	<<< [16] <query> 502 us
	>>> [17] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-bqwrgpmcqb4zxvkyvvop')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
	<<< [17] <query> 365 us
	>>> [18] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-bqwrgpmcqb4zxvkyvvop')
	<<< [18] <query> 285 us
	>>> [19] <connect> phabricator_user
	<<< [19] <connect> 889 us
	>>> [20] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [20] <query> 18,286 us
	>>> [21] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-PROJ-vi7rjrmnk3lcc5aztlqu')) AND (edge.type IN ('13')) ORDER BY edge.dateCreated DESC, edge.seq DESC
	<<< [21] <query> 5,223 us
	>>> [22] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [22] <query> 17,308 us
	>>> [23] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [23] <query> 18,568 us
	>>> [24] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [24] <query> 17,947 us
	>>> [25] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [25] <query> 18,309 us
	>>> [26] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [26] <query> 18,189 us
	>>> [27] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [27] <query> 17,752 us
	>>> [28] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [28] <query> 18,296 us
	>>> [29] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [29] <query> 18,545 us
	>>> [30] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [30] <query> 18,136 us
	>>> [31] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [31] <query> 17,755 us
	>>> [32] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [32] <query> 17,500 us
	>>> [33] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-7szdg4elqqaowpzjrkbi', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [33] <query> 17,254 us
	>>> [34] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-nsnnowxztidyfw62namu', 'PHID-USER-pgi5dylkzf4n74u5trn5', 'PHID-USER-eh6b6mexpadgyyhhkhfr', 'PHID-USER-6ttizi6pnrvjkaauwb75', 'PHID-USER-tjtwj2rb7fqmmueb5a7y', 'PHID-USER-5u56tb25556444mzttkt', 'PHID-USER-3cejn6pkq3bq57exb47x', 'PHID-USER-s7bddq2pftya2f42hhz7', 'PHID-USER-kl7ny3624sacvljz7vro', 'PHID-USER-wkvfomumsrirvvvi4dwf', 'PHID-USER-ql2jquohn3edcva5hthg', 'PHID-USER-titnhof3hoido3vprk76', 'PHID-USER-eqyy6msvuxgsvjwnaxvv', 'PHID-USER-brs2
	<<< [34] <query> 17,652 us

Event Timeline

Pawka edited the content of this paste. (Show Details)Sep 15 2015, 5:40 AM

Pawka updated the paste's language from autodetect to autodetect.

Pawka mentioned this in T9415: PhabricatorApplicationTransactionPublishWorker requires unreasonable amount of memory for large numbers of mail recipients?.

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions