explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tSV7

Settings
# exclusive inclusive rows x rows loops node
1. 0.082 0.111 ↓ 0.0 0 1

Delete on user_service (cost=0..1.23 rows=1 width=6) (actual time=0.106..0.111 rows=0 loops=1)

  • Buffers: shared hit=3 dirtied=1
2. 0.029 0.029 ↑ 1.0 1 1

Seq Scan on user_service user_service (cost=0..1.23 rows=1 width=6) (actual time=0.024..0.029 rows=1 loops=1)

  • Filter: (user_service.id = 3,548)
  • Buffers: shared hit=1
Planning time : 0.424 ms
Execution time : 362,473.184 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_a_4950489 0.657 ms 1 0.657 ms
RI_ConstraintTrigger_a_4950504 0.709 ms 1 0.709 ms
RI_ConstraintTrigger_a_4950554 1,059.124 ms 1 1,059.124 ms
RI_ConstraintTrigger_a_4950559 0.796 ms 1 0.796 ms
RI_ConstraintTrigger_a_4950564 0.444 ms 1 0.444 ms
RI_ConstraintTrigger_a_4950569 0.690 ms 1 0.690 ms
RI_ConstraintTrigger_a_4950574 0.368 ms 1 0.368 ms
RI_ConstraintTrigger_a_4950579 0.394 ms 1 0.394 ms
RI_ConstraintTrigger_a_4950584 0.427 ms 1 0.427 ms
RI_ConstraintTrigger_a_4950599 0.465 ms 1 0.465 ms
RI_ConstraintTrigger_a_4950669 45.831 ms 1 45.831 ms
RI_ConstraintTrigger_a_4950709 8.611 ms 1 8.611 ms
RI_ConstraintTrigger_a_4950714 0.633 ms 1 0.633 ms
RI_ConstraintTrigger_a_4950739 0.622 ms 1 0.622 ms
RI_ConstraintTrigger_a_4950744 0.371 ms 1 0.371 ms
RI_ConstraintTrigger_a_4950749 1.058 ms 1 1.058 ms
RI_ConstraintTrigger_a_4950754 0.406 ms 1 0.406 ms
RI_ConstraintTrigger_a_4950759 0.427 ms 1 0.427 ms
RI_ConstraintTrigger_a_4950764 0.353 ms 1 0.353 ms
RI_ConstraintTrigger_a_4950774 0.403 ms 1 0.403 ms
RI_ConstraintTrigger_a_4950779 0.464 ms 1 0.464 ms
RI_ConstraintTrigger_a_4950784 0.367 ms 1 0.367 ms
RI_ConstraintTrigger_a_4950789 0.471 ms 1 0.471 ms
RI_ConstraintTrigger_a_4950794 0.463 ms 1 0.463 ms
RI_ConstraintTrigger_a_4950799 0.370 ms 1 0.370 ms
RI_ConstraintTrigger_a_4950804 0.463 ms 1 0.463 ms
RI_ConstraintTrigger_a_4950534 345.616 ms 2 172.808 ms
RI_ConstraintTrigger_a_4950619 15.722 ms 2 7.861 ms
RI_ConstraintTrigger_a_4950674 1.136 ms 2 0.568 ms
RI_ConstraintTrigger_a_4950684 1.402 ms 2 0.701 ms
RI_ConstraintTrigger_a_4950704 3.635 ms 2 1.817 ms
RI_ConstraintTrigger_a_4950719 80.431 ms 2 40.215 ms
RI_ConstraintTrigger_a_4950729 0.789 ms 2 0.395 ms
RI_ConstraintTrigger_a_4950544 1.320 ms 5 0.264 ms
RI_ConstraintTrigger_a_4950549 131.733 ms 5 26.347 ms
RI_ConstraintTrigger_a_4950649 2.964 ms 5 0.593 ms
RI_ConstraintTrigger_a_4950539 325,292.636 ms 11681 27.848 ms
RI_ConstraintTrigger_a_4950614 4,750.694 ms 11681 0.407 ms
RI_ConstraintTrigger_a_4950629 1,944.456 ms 11681 0.166 ms
RI_ConstraintTrigger_a_4950644 1,056.712 ms 11681 0.090 ms
RI_ConstraintTrigger_a_4950654 459.349 ms 11681 0.039 ms
RI_ConstraintTrigger_a_4950659 404.837 ms 11681 0.035 ms
RI_ConstraintTrigger_a_4950724 17,133.641 ms 11681 1.467 ms
RI_ConstraintTrigger_a_4950664 43.578 ms 355 0.123 ms
RI_ConstraintTrigger_a_4950679 48.201 ms 355 0.136 ms
RI_ConstraintTrigger_a_4950689 9.559 ms 355 0.027 ms
RI_ConstraintTrigger_a_4950699 30.492 ms 355 0.086 ms
RI_ConstraintTrigger_a_4950734 9.325 ms 355 0.026 ms
RI_ConstraintTrigger_a_4950494 0.998 ms 2 0.499 ms
RI_ConstraintTrigger_a_4950589 0.552 ms 2 0.276 ms
RI_ConstraintTrigger_a_4950594 0.513 ms 2 0.257 ms
RI_ConstraintTrigger_a_4950604 0.430 ms 2 0.215 ms
RI_ConstraintTrigger_a_4950509 0.340 ms 2 0.170 ms
RI_ConstraintTrigger_a_4950519 0.217 ms 1 0.217 ms
RI_ConstraintTrigger_a_4950529 0.336 ms 2 0.168 ms
RI_ConstraintTrigger_a_4950624 1,131.206 ms 38952 0.029 ms
RI_ConstraintTrigger_a_4950634 834.428 ms 38952 0.021 ms
RI_ConstraintTrigger_a_4950639 7,180.587 ms 38952 0.184 ms
RI_ConstraintTrigger_a_4950694 1.539 ms 30 0.051 ms