explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x9sT

Settings
# exclusive inclusive rows x rows loops node
1. 506.547 506.547 ↑ 3.0 3 1

Seq Scan on bordereau (cost=0.00..127,896.12 rows=9 width=6) (actual time=70.394..506.547 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.124 ms
Execution time : 506.568 ms