POE Paste with lovely alien head...

No paste!

from "Bmagic" at 168.25.130.30
The reporter query that made https://explain.depesz.com/s/hScG

format options below
SELECT * FROM (SELECT       "bdd43e1440a00047b1e66cb9619865c0"."name" AS "Owning Library",
                "df8d81aecbe6b10702cbd762ac04cac9"."title" AS "Title",
                "df8d81aecbe6b10702cbd762ac04cac9"."author" AS "Author",
                "7d74f3b92b19da5e606d737d339a9679"."barcode" AS "Barcode",
                "286d7899ae25bee8bdd7dcde49f9e0b7"."label" AS "Call Number Label",
                "c17ecc44e3cd2de457e5c9f1e6e0a26f"."name" AS "Shelving Location",
                date("7d74f3b92b19da5e606d737d339a9679"."create_date") AS "Creation Date/Time",
                "9547fadabf916ce4fd3eb232e0902c9c"."name" AS "Status",
                date("5dfd2825f06afb4288414554924373d3"."last_circ") AS "Last Circulation Date",
                "61e399649f46fcc0bd6386f90bfa79a2"."circ_count" AS "Total Circulation Count"
          FROM  asset.copy AS "7d74f3b92b19da5e606d737d339a9679"
                LEFT OUTER JOIN extend_reporter.full_circ_count AS "61e399649f46fcc0bd6386f90bfa79a2" ON ("7d74f3b92b19da5e606d737d339a9679"."id" = "61e399649f46fcc0bd6386f90bfa79a2"."id")
                LEFT OUTER JOIN (
                    SELECT
                        ac.id,
                        MAX(actac.xact_start) AS last_circ
                    FROM asset.copy ac
                         LEFT JOIN action.all_circulation actac ON ac.id = actac.target_copy
                         where ac.location in(368)
                    GROUP BY ac.id

                        ) AS "5dfd2825f06afb4288414554924373d3" ON ("7d74f3b92b19da5e606d737d339a9679"."id" = "5dfd2825f06afb4288414554924373d3"."id")
                INNER JOIN asset.copy_location AS "c17ecc44e3cd2de457e5c9f1e6e0a26f" ON ("7d74f3b92b19da5e606d737d339a9679"."location" = "c17ecc44e3cd2de457e5c9f1e6e0a26f"."id")
                LEFT OUTER JOIN asset.call_number AS "286d7899ae25bee8bdd7dcde49f9e0b7" ON ("7d74f3b92b19da5e606d737d339a9679"."call_number" = "286d7899ae25bee8bdd7dcde49f9e0b7"."id")
                INNER JOIN actor.org_unit AS "bdd43e1440a00047b1e66cb9619865c0" ON ("286d7899ae25bee8bdd7dcde49f9e0b7"."owning_lib" = "bdd43e1440a00047b1e66cb9619865c0"."id")
                LEFT OUTER JOIN biblio.record_entry AS "7f0e2da56d7bdf7c7434e87c5abaab5c" ON ("286d7899ae25bee8bdd7dcde49f9e0b7"."record" = "7f0e2da56d7bdf7c7434e87c5abaab5c"."id")
                LEFT OUTER JOIN reporter.materialized_simple_record AS "df8d81aecbe6b10702cbd762ac04cac9" ON ("7f0e2da56d7bdf7c7434e87c5abaab5c"."id" = "df8d81aecbe6b10702cbd762ac04cac9"."id")
                INNER JOIN config.copy_status AS "9547fadabf916ce4fd3eb232e0902c9c" ON ("7d74f3b92b19da5e606d737d339a9679"."status" = "9547fadabf916ce4fd3eb232e0902c9c"."id")
          WHERE AGE(NOW(),"7d74f3b92b19da5e606d737d339a9679"."create_date") >= $_6177$1days$_6177$
                AND "7d74f3b92b19da5e606d737d339a9679"."deleted" = $_6177$f$_6177$
                AND (("bdd43e1440a00047b1e66cb9619865c0"."id") IS NULL OR "bdd43e1440a00047b1e66cb9619865c0"."id" IN ($_6177$117$_6177$))
                AND ((date("5dfd2825f06afb4288414554924373d3"."last_circ")) IS NULL OR date("5dfd2825f06afb4288414554924373d3"."last_circ") < $_6177$2019-05-20$_6177$)
                AND "c17ecc44e3cd2de457e5c9f1e6e0a26f"."id" IN ($_6177$368$_6177$)
          GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
          ORDER BY "bdd43e1440a00047b1e66cb9619865c0"."name" ASC, "df8d81aecbe6b10702cbd762ac04cac9"."title" ASC, "df8d81aecbe6b10702cbd762ac04cac9"."author" ASC, "7d74f3b92b19da5e606d737d339a9679"."barcode" ASC, "286d7899ae25bee8bdd7dcde49f9e0b7"."label" ASC, "c17ecc44e3cd2de457e5c9f1e6e0a26f"."name" ASC, date("7d74f3b92b19da5e606d737d339a9679"."create_date") ASC, "9547fadabf916ce4fd3eb232e0902c9c"."name" ASC, date("5dfd2825f06afb4288414554924373d3"."last_circ") ASC, "61e399649f46fcc0bd6386f90bfa79a2"."circ_count" ASC
        ) limited_to_1048575_hits LIMIT 1048575





perl stuff: (might be helpful for others but not perfect)



Valid HTML 4.01!

Pastebot is powered by POE.