germanow

<?php

namespace App\Http\Controllers;

use App\Message;
use App\Events\MessageSent;
use Illuminate\Http\Request;
use App\Http\Requests;

class MessagesController extends Controller

germanow

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRoleTable extends Migration
{
    /**
     * Run the migrations.

germanow

WITH RECURSIVE 
r_back AS (
    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" AS fw
    WHERE fw.id = 640

    UNION ALL

    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" as fw

germanow

<?xml version="1.0"?>
<ruleset name="My first PHPMD rule set"
         xmlns="http://pmd.sf.net/ruleset/1.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://pmd.sf.net/ruleset/1.0.0
                     http://pmd.sf.net/ruleset_xml_schema.xsd"
         xsi:noNamespaceSchemaLocation="
                     http://pmd.sf.net/ruleset_xml_schema.xsd">
    <description>
        My custom rule set that checks my code...

germanow

ps -o pid,ppid,lstart,cmd <pid>

germanow

{"version":1,"resource":"file:///home/ivan/gfm/analyzer/test/services/report_service/metrics_calculator_test.exs","entries":[{"id":"pWKJ.exs","timestamp":1649672138023},{"id":"gIJ9.exs","timestamp":1649672156795},{"id":"OPH5.exs","timestamp":1649672190703}]}

germanow

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';
SELECT pg_cancel_backend(__pid__);

germanow

tar -xOzf dump.tar.gz | PGPASSWORD=secret psql --host=127.0.0.1 --username=default dbname

germanow

SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
    AND C.relkind <> 'i'
    AND nspname !~ '^pg_toast'
  ORDER BY pg_total_relation_size(C.oid) DESC
  LIMIT 10;

germanow

-- To disconnect all other users from the database, you can use this query:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity 
WHERE pg_stat_activity.datname = 'originaldb' AND pid <> pg_backend_pid();

CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;