# Optimizing Python Excel Exports After a Production Performance Incident

DevFeed: [Optimizing Python Excel Exports After a Production Performance Incident](<https://devfeed.tech/articles/how-export-to-excel-almost-killed-our-system-33929.md>)

Original publisher: [Read original article](<https://hakibenita.com/python-django-optimizing-excel-export>)

Author: Haki Benita

Published: 2019-09-16T21:00:00Z

Content type: tutorial

Language: en

Sources: [Haki Benita](<https://devfeed.tech/sources/haki-benita.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [incident](<https://devfeed.tech/topics/incident.md>), [systems](<https://devfeed.tech/topics/systems.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [nginx](<https://devfeed.tech/topics/nginx.md>), [Processes](<https://devfeed.tech/topics/processes.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [data](<https://devfeed.tech/topics/data.md>), [export](<https://devfeed.tech/topics/export.md>)

Tags: [articles](<https://devfeed.tech/tags/articles.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [django](<https://devfeed.tech/tags/django.md>), [incident](<https://devfeed.tech/tags/incident.md>), [just](<https://devfeed.tech/tags/just.md>), [models](<https://devfeed.tech/tags/models.md>), [nginx](<https://devfeed.tech/tags/nginx.md>), [orm](<https://devfeed.tech/tags/orm.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [process](<https://devfeed.tech/tags/process.md>), [python](<https://devfeed.tech/tags/python.md>), [systems](<https://devfeed.tech/tags/systems.md>)

## AI overview

This article examines a production performance incident caused by a Python "Export to Excel" feature. It describes how the problem was identified through server metrics, process profiling, and nginx logs, then investigated by reproducing the issue and benchmarking alternative solutions.

## Source excerpt

Inspired by an actual incident we had in one of our systems caused by an "Export to Excel" functionality implemented in Python, we go through the process of identifying the problem, experimenting and benchmarking different solutions.