explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rev9

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 452.184 ↑ 9.0 1 1

Group (cost=127,896.26..127,896.31 rows=9 width=6) (actual time=452.182..452.184 rows=1 loops=1)

  • Group Key: num_bordereau
2. 0.018 452.182 ↑ 3.0 3 1

Sort (cost=127,896.26..127,896.29 rows=9 width=6) (actual time=452.180..452.182 rows=3 loops=1)

  • Sort Key: num_bordereau
  • Sort Method: quicksort Memory: 25kB
3. 452.164 452.164 ↑ 3.0 3 1

Seq Scan on bordereau (cost=0.00..127,896.12 rows=9 width=6) (actual time=63.598..452.164 rows=3 loops=1)

  • Filter: (((num_bordereau)::text ~~ '%06686%'::text) AND ((distributeur)::text = '01957'::text))
  • Rows Removed by Filter: 2,764,874
Planning time : 0.141 ms
Execution time : 452.205 ms