explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EQ1V : no short

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.795 ↑ 1.0 80 1

Limit (cost=0.56..17.84 rows=80 width=9) (actual time=0.217..0.795 rows=80 loops=1)

2. 0.787 0.787 ↑ 191,811.9 80 1

Index Scan using stock_picking_state_index on stock_picking (cost=0.56..3,313,883.38 rows=15,344,953 width=9) (actual time=0.215..0.787 rows=80 loops=1)

  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND ((type)::text = 'internal'::text) AND (((name)::text = '9'::text) OR ((origin)::text ~~ '%9%'
  • Rows Removed by Filter: 104
Planning time : 0.596 ms
Execution time : 0.830 ms