explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TQEb

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 130,546.360 ↓ 0.0 0 1

Sort (cost=643,866.24..643,866.90 rows=263 width=13) (actual time=130,527.955..130,546.360 rows=0 loops=1)

  • Sort Key: name DESC
  • Sort Method: quicksort Memory: 25kB
2. 27.366 130,546.301 ↓ 0.0 0 1

Gather (cost=10.00..643,855.67 rows=263 width=13) (actual time=130,527.897..130,546.301 rows=0 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
3. 130,518.935 130,518.935 ↓ 0.0 0 9 / 9

Parallel Seq Scan on sale_order (cost=0.00..643,843.04 rows=33 width=13) (actual time=130,518.935..130,518.935 rows=0 loops=9)

  • Filter: (((origin)::text ~~ '%699268090%'::text) OR ((name)::text = '699268090'::text))
  • Rows Removed by Filter: 8,621,340
Planning time : 76.691 ms
Execution time : 130,546.469 ms