explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rlm

Settings
# exclusive inclusive rows x rows loops node
1. 99,538.260 99,538.260 ↑ 1.0 80 1

Limit (cost=0.56..10.94 rows=80 width=17) (actual time=99,538.203..99,538.260 rows=80 loops=1)

  • -> Index Scan using stock_picking_user_done_idx on stock_picking (cost=0.56..3163866.39 rows=24395238 width=17) (actual time=99538.199..99538.248 rows=80
  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND ((type)::text = 'internal'::text))
  • Rows Removed by Filter: 23937381
Planning time : 0.809 ms
Execution time : 99,538.312 ms