Why not login to Qiita and try out its useful features?

We'll deliver articles that match you.

You can read useful information later.

8
7

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

DjangoでModel経由で実行したSQLをログに出力する

Posted at

パフォーマンスチューニングって重要ですよね。

Djangoを使用していて、あれ、このAPI重いなとか負荷がかかってるな?と思ってSQLが原因かなーと、思ったのであれば、実行SQLとその実行にかかった時間をログに出してみましょう。
まずはともかく、ログに出さないことには何も調べようがないですしね:sob:

ログに出す!

特に新規実装とかは不要です!
やることは簡単、設定値を変更するだけ:muscle:

settings.py
LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'console': {
            'level': 'DEBUG',
            'class': 'logging.StreamHandler',
        },
    },
    'loggers': {
        'django.db.backends': {
            'handlers': ['console'],
            'level': 'DEBUG',
        },
    },
}

これを追加してあげるだけです!
今回の場合だと、sqlが実行される度に、handlersで設定した先に対してログが出力されます!
便利:grin:

8
7
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up

Qiita Conference 2025 will be held!: 4/23(wed) - 4/25(Fri)

Qiita Conference is the largest tech conference in Qiita!

Keynote Speaker

ymrl、Masanobu Naruse, Takeshi Kano, Junichi Ito, uhyo, Hiroshi Tokumaru, MinoDriven, Minorun, Hiroyuki Sakuraba, tenntenn, drken, konifar

View event details
8
7

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?