Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Delete on t_status (cost=36411011.32..475180456.37 rows=0 width=0) (actual time=175474.541..175474.561 rows=0 loops=1) Delete on t_status_137000000_138000000 t_status_1 Delete on t_status_138000000_139000000 t_status_2 Delete on t_status_139000000_140000000 t_status_3 Delete on t_status_140000000_141000000 t_status_4 Delete on t_status_141000000_142000000 t_status_5 Delete on t_status_142000000_143000000 t_status_6 Delete on t_status_143000000_144000000 t_status_7 Delete on t_status_144000000_145000000 t_status_8 Delete on t_status_145000000_146000000 t_status_9 Delete on t_status_146000000_147000000 t_status_10 Delete on t_status_147000000_148000000 t_status_11 Delete on t_status_148000000_149000000 t_status_12 Delete on t_status_149000000_150000000 t_status_13 Delete on t_status_150000000_151000000 t_status_14 Delete on t_status_151000000_152000000 t_status_15 Delete on t_status_152000000_153000000 t_status_16 Delete on t_status_153000000_154000000 t_status_17 Delete on t_status_154000000_155000000 t_status_18 Delete on t_status_155000000_156000000 t_status_19 Delete on t_status_156000000_157000000 t_status_20 Delete on t_status_157000000_158000000 t_status_21 Delete on t_status_158000000_159000000 t_status_22 Delete on t_status_159000000_160000000 t_status_23 Delete on t_status_160000000_161000000 t_status_24 Delete on t_status_161000000_162000000 t_status_25 Delete on t_status_162000000_163000000 t_status_26 Delete on t_status_163000000_164000000 t_status_27 Delete on t_status_164000000_165000000 t_status_28 Delete on t_status_165000000_166000000 t_status_29 Delete on t_status_166000000_167000000 t_status_30 Delete on t_status_167000000_168000000 t_status_31 Delete on t_status_168000000_169000000 t_status_32 Delete on t_status_169000000_170000000 t_status_33 Delete on t_status_170000000_171000000 t_status_34 Delete on t_status_171000000_172000000 t_status_35 Delete on t_status_172000000_173000000 t_status_36 Delete on t_status_173000000_174000000 t_status_37 Delete on t_status_174000000_175000000 t_status_38 Delete on t_status_175000000_176000000 t_status_39 Delete on t_status_176000000_177000000 t_status_40 Delete on t_status_177000000_178000000 t_status_41 Delete on t_status_178000000_179000000 t_status_42 -> Merge Join (cost=36411011.32..475180456.37 rows=29224764823 width=16) (actual time=170830.898..175474.475 rows=21 loops=1) Merge Cond: (t_temp_streams_to_delete.id = t_status.stream_id) -> Sort (cost=3315.66..3407.50 rows=36734 width=10) (actual time=12.605..15.634 rows=36734 loops=1) Sort Key: t_temp_streams_to_delete.id Sort Method: quicksort Memory: 3088kB -> Seq Scan on t_temp_streams_to_delete (cost=0.00..530.34 rows=36734 width=10) (actual time=0.014..3.567 rows=36734 loops=1) -> Materialize (cost=36407695.65..37203273.72 rows=159115614 width=14) (actual time=166366.079..172827.777 rows=30713968 loops=1) -> Sort (cost=36407695.65..36805484.69 rows=159115614 width=14) (actual time=166366.066..169462.240 rows=30713968 loops=1) Sort Key: t_status.stream_id Sort Method: external merge Disk: 721408kB -> Append (cost=0.00..6573987.21 rows=159115614 width=14) (actual time=0.446..150394.589 rows=30717345 loops=1) -> Seq Scan on t_status_137000000_138000000 t_status_1 (cost=0.00..153344.22 rows=4222522 width=14) (actual time=0.445..3911.033 rows=828766 loops=1) -> Seq Scan on t_status_138000000_139000000 t_status_2 (cost=0.00..162076.86 rows=4462986 width=14) (actual time=0.386..4488.473 rows=874563 loops=1) -> Seq Scan on t_status_139000000_140000000 t_status_3 (cost=0.00..145344.36 rows=4002236 width=14) (actual time=0.399..4431.747 rows=786878 loops=1) -> Seq Scan on t_status_140000000_141000000 t_status_4 (cost=0.00..160963.20 rows=4432320 width=14) (actual time=0.395..4044.489 rows=869081 loops=1) -> Seq Scan on t_status_141000000_142000000 t_status_5 (cost=0.00..150012.90 rows=4130790 width=14) (actual time=0.534..3802.118 rows=806881 loops=1) -> Seq Scan on t_status_142000000_143000000 t_status_6 (cost=0.00..150977.52 rows=4157352 width=14) (actual time=0.412..3791.785 rows=812991 loops=1) -> Seq Scan on t_status_143000000_144000000 t_status_7 (cost=0.00..36938.46 rows=1017146 width=14) (actual time=0.415..1007.511 rows=200012 loops=1) -> Seq Scan on t_status_144000000_145000000 t_status_8 (cost=0.00..141593.52 rows=3898952 width=14) (actual time=0.383..3566.573 rows=763428 loops=1) -> Seq Scan on t_status_145000000_146000000 t_status_9 (cost=0.00..173173.44 rows=4768544 width=14) (actual time=0.458..4393.027 rows=919283 loops=1) -> Seq Scan on t_status_146000000_147000000 t_status_10 (cost=0.00..158419.86 rows=4362286 width=14) (actual time=0.433..3983.332 rows=842595 loops=1) -> Seq Scan on t_status_147000000_148000000 t_status_11 (cost=0.00..161745.66 rows=4453866 width=14) (actual time=0.479..4224.112 rows=858278 loops=1) -> Seq Scan on t_status_148000000_149000000 t_status_12 (cost=0.00..173228.64 rows=4770064 width=14) (actual time=0.487..4455.011 rows=915680 loops=1) -> Seq Scan on t_status_149000000_150000000 t_status_13 (cost=0.00..165529.62 rows=4558062 width=14) (actual time=0.781..4302.402 rows=877401 loops=1) -> Seq Scan on t_status_150000000_151000000 t_status_14 (cost=0.00..170890.92 rows=4705692 width=14) (actual time=0.393..4283.870 rows=904116 loops=1) -> Seq Scan on t_status_151000000_152000000 t_status_15 (cost=0.00..187023.12 rows=5149912 width=14) (actual time=0.441..4702.708 rows=952655 loops=1) -> Seq Scan on t_status_152000000_153000000 t_status_16 (cost=0.00..158411.58 rows=4362058 width=14) (actual time=0.415..3988.261 rows=832990 loops=1) -> Seq Scan on t_status_153000000_154000000 t_status_17 (cost=0.00..159503.16 rows=4392116 width=14) (actual time=0.355..4013.669 rows=852015 loops=1) -> Seq Scan on t_status_154000000_155000000 t_status_18 (cost=0.00..166513.56 rows=4585156 width=14) (actual time=0.524..4152.952 rows=888373 loops=1) -> Seq Scan on t_status_155000000_156000000 t_status_19 (cost=0.00..159977.88 rows=4405188 width=14) (actual time=0.472..3933.522 rows=849352 loops=1) -> Seq Scan on t_status_156000000_157000000 t_status_20 (cost=0.00..172110.84 rows=4739284 width=14) (actual time=0.368..4337.375 rows=913365 loops=1) -> Seq Scan on t_status_157000000_158000000 t_status_21 (cost=0.00..162220.38 rows=4466938 width=14) (actual time=0.573..4169.453 rows=861256 loops=1) -> Seq Scan on t_status_158000000_159000000 t_status_22 (cost=0.00..149908.02 rows=4127902 width=14) (actual time=1.012..3770.852 rows=796728 loops=1) -> Seq Scan on t_status_159000000_160000000 t_status_23 (cost=0.00..176540.64 rows=4861264 width=14) (actual time=0.541..4476.350 rows=935719 loops=1) -> Seq Scan on t_status_160000000_161000000 t_status_24 (cost=0.00..161433.78 rows=4445278 width=14) (actual time=0.564..4014.534 rows=856581 loops=1) -> Seq Scan on t_status_161000000_162000000 t_status_25 (cost=0.00..171291.12 rows=4716712 width=14) (actual time=0.454..4320.139 rows=911636 loops=1) -> Seq Scan on t_status_162000000_163000000 t_status_26 (cost=0.00..179492.46 rows=4942546 width=14) (actual time=3.646..4507.235 rows=955360 loops=1) -> Seq Scan on t_status_163000000_164000000 t_status_27 (cost=0.00..166156.14 rows=4575314 width=14) (actual time=0.424..4206.948 rows=884629 loops=1) -> Seq Scan on t_status_164000000_165000000 t_status_28 (cost=0.00..177840.60 rows=4897060 width=14) (actual time=0.493..4619.488 rows=947678 loops=1) -> Seq Scan on t_status_165000000_166000000 t_status_29 (cost=0.00..170519.70 rows=4695470 width=14) (actual time=0.449..4394.152 rows=907229 loops=1) -> Seq Scan on t_status_166000000_167000000 t_status_30 (cost=0.00..163162.92 rows=4492892 width=14) (actual time=0.452..4172.523 rows=865990 loops=1) -> Seq Scan on t_status_167000000_168000000 t_status_31 (cost=0.00..175613.28 rows=4835728 width=14) (actual time=0.634..4509.154 rows=929668 loops=1) -> Seq Scan on t_status_168000000_169000000 t_status_32 (cost=0.00..160589.22 rows=4422022 width=14) (actual time=0.466..4163.242 rows=849375 loops=1) -> Seq Scan on t_status_169000000_170000000 t_status_33 (cost=0.00..162721.32 rows=4480732 width=14) (actual time=0.430..4054.348 rows=859919 loops=1) -> Seq Scan on t_status_170000000_171000000 t_status_34 (cost=0.00..176314.32 rows=4855032 width=14) (actual time=0.532..4591.528 rows=931535 loops=1) -> Seq Scan on t_status_171000000_172000000 t_status_35 (cost=0.00..164733.36 rows=4536136 width=14) (actual time=0.412..4204.107 rows=870067 loops=1) -> Seq Scan on t_status_172000000_173000000 t_status_36 (cost=0.00..152009.76 rows=4185776 width=14) (actual time=0.914..3842.057 rows=805272 loops=1) -> Seq Scan on t_status_173000000_174000000 t_status_37 (cost=0.00..13.80 rows=380 width=14) (actual time=0.005..0.005 rows=0 loops=1) -> Seq Scan on t_status_174000000_175000000 t_status_38 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.003 rows=0 loops=1) -> Seq Scan on t_status_175000000_176000000 t_status_39 (cost=0.00..13.80 rows=380 width=14) (actual time=0.009..0.010 rows=0 loops=1) -> Seq Scan on t_status_176000000_177000000 t_status_40 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1) -> Seq Scan on t_status_177000000_178000000 t_status_41 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1) -> Seq Scan on t_status_178000000_179000000 t_status_42 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1) Planning Time: 147.098 ms Execution Time: 175568.936 ms (98 rows)
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
F-Formula
2 hours ago | 1.23 KB
SEEING GOD IN THE MATH
2 hours ago | 0.12 KB
Untitled
17 hours ago | 1.88 KB
Untitled
17 hours ago | 0.67 KB
Untitled
17 hours ago | 3.33 KB
Untitled
18 hours ago | 1.00 KB
Untitled
18 hours ago | 0.33 KB
Untitled
18 hours ago | 1.55 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!