explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BQTW

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 275,267.382 ↑ 1.0 101 1

Limit (cost=0.43..398.27 rows=101 width=246) (actual time=63,191.524..275,267.382 rows=101 loops=1)

2. 275,267.326 275,267.326 ↑ 1,146.6 101 1

Index Scan Backward using logistics_deliverymanifestfile_3017d911 on logistics_deliverymanifestfile (cost=0.43..456,160.24 rows=115,805 width=246) (actual time=63,191.522..275,267.326 rows=101 loops=1)

  • Filter: ((NOT api_fetch) AND (customer_id = 21))
  • Rows Removed by Filter: 2993324
Planning time : 190.447 ms
Execution time : 275,267.591 ms