explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmWw

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,217.039 ↑ 20.0 1 1

Limit (cost=0.43..18,702.28 rows=20 width=98) (actual time=257.928..1,217.039 rows=1 loops=1)

  • Buffers: shared hit=1137320
2. 1,217.038 1,217.038 ↑ 113.0 1 1

Index Scan Backward using task_pkey on task t0_ (cost=0.43..105,665.91 rows=113 width=98) (actual time=257.927..1,217.038 rows=1 loops=1)

  • Filter: ((NOT deleted) AND ((order_number)::text ~~ '%1020585787%'::text) AND (deleted < true))
  • Rows Removed by Filter: 1125151
  • Buffers: shared hit=1137320
Planning time : 0.114 ms
Execution time : 1,217.070 ms