explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uIcC

Settings
# exclusive inclusive rows x rows loops node
1. 17.613 104.414 ↑ 1.0 5,802 1

Limit (cost=20.46..122,736.92 rows=5,802 width=212) (actual time=17.092..104.414 rows=5,802 loops=1)

  • Functions: 17
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.164 ms, Inlining 0.000 ms, Optimization 0.718 ms, Emission 15.667 ms, Total 18.550 ms
2. 2.741 86.801 ↑ 1.0 5,802 1

Nested Loop Left Join (cost=20.46..122,736.92 rows=5,802 width=212) (actual time=0.205..86.801 rows=5,802 loops=1)

3. 4.223 43.446 ↑ 1.0 5,802 1

Nested Loop (cost=0.15..4,723.43 rows=5,802 width=202) (actual time=0.115..43.446 rows=5,802 loops=1)

4. 33.421 33.421 ↑ 1.0 5,802 1

Seq Scan on stocks s (cost=0.00..3,703.82 rows=5,802 width=134) (actual time=0.078..33.421 rows=5,802 loops=1)

  • Filter: (orientation = 'Supplier'::text)
  • Rows Removed by Filter: 62
5. 5.802 5.802 ↑ 1.0 1 5,802

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,802)

  • Index Cond: (id = s.step_action_id)
6. 29.010 40.614 ↑ 1.0 1 5,802

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

7. 5.802 11.604 ↑ 10.0 1 5,802

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,802)

  • Recheck Cond: (id = ANY (s.statuses))
  • Heap Blocks: exact=4,132
8. 5.802 5.802 ↑ 10.0 1 5,802

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,802)

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