explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oi2C

Settings
# exclusive inclusive rows x rows loops node
1. 18.392 111.959 ↑ 1.0 5,575 1

Limit (cost=20.46..118,119.91 rows=5,577 width=212) (actual time=17.759..111.959 rows=5,575 loops=1)

  • Functions: 17
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.235 ms, Inlining 0.000 ms, Optimization 1.144 ms, Emission 15.925 ms, Total 19.304 ms
2. 2.916 93.567 ↑ 1.0 5,575 1

Nested Loop Left Join (cost=20.46..118,119.91 rows=5,577 width=212) (actual time=0.148..93.567 rows=5,575 loops=1)

3. 5.177 46.051 ↑ 1.0 5,575 1

Nested Loop (cost=0.15..4,682.95 rows=5,577 width=202) (actual time=0.085..46.051 rows=5,575 loops=1)

4. 35.299 35.299 ↑ 1.0 5,575 1

Seq Scan on stocks s (cost=0.00..3,701.01 rows=5,577 width=134) (actual time=0.061..35.299 rows=5,575 loops=1)

  • Filter: ((NOT is_deleted) AND (orientation = 'Supplier'::text))
  • Rows Removed by Filter: 289
5. 5.575 5.575 ↑ 1.0 1 5,575

Index Scan using steps_actions_pkey on steps_actions sa (cost=0.15..0.18 rows=1 width=76) (actual time=0.001..0.001 rows=1 loops=5,575)

  • Index Cond: (id = s.step_action_id)
6. 33.450 44.600 ↑ 1.0 1 5,575

Aggregate (cost=20.31..20.32 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=5,575)

7. 5.575 11.150 ↑ 10.0 1 5,575

Bitmap Heap Scan on ref_stock_statuses status (cost=9.60..20.26 rows=10 width=40) (actual time=0.002..0.002 rows=1 loops=5,575)

  • Recheck Cond: (id = ANY (s.statuses))
  • Heap Blocks: exact=3,928
8. 5.575 5.575 ↑ 10.0 1 5,575

Bitmap Index Scan on ref_stock_statuses_pkey (cost=0.00..9.60 rows=10 width=0) (actual time=0.001..0.001 rows=1 loops=5,575)

  • Index Cond: (id = ANY (s.statuses))
Execution time : 114.932 ms