explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x47V

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

Limit (cost=0.56..18.58 rows=80 width=9) (actual time=0.172..0.780 rows=80 loops=1)

  • -> Index Scan using stock_picking_state_user_done_idx on stock_picking (cost=0.56..3451795.80 rows=15326601 width=9) (actual time=0.170..0.770 rows=80 lo
  • 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: 136
Planning time : 0.612 ms
Execution time : 0.818 ms