explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YliT

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.269 ↑ 1.0 1 1

Aggregate (cost=493.59..493.60 rows=1 width=288) (actual time=0.269..0.269 rows=1 loops=1)

2. 0.045 0.239 ↓ 8.5 17 1

Sort (cost=493.50..493.51 rows=2 width=1,927) (actual time=0.237..0.239 rows=17 loops=1)

  • Sort Key: a.order_num
  • Sort Method: quicksort Memory: 27kB
3. 0.033 0.194 ↓ 8.5 17 1

Hash Join (cost=1.47..493.49 rows=2 width=1,927) (actual time=0.093..0.194 rows=17 loops=1)

  • Hash Cond: ((a.dep_id)::numeric = d.dep_id)
4. 0.037 0.140 ↑ 2.7 17 1

Nested Loop (cost=0.29..492.18 rows=46 width=53) (actual time=0.055..0.140 rows=17 loops=1)

5. 0.022 0.022 ↓ 9.0 9 1

Seq Scan on status s (cost=0.00..11.38 rows=1 width=8) (actual time=0.017..0.022 rows=9 loops=1)

  • Filter: ((grp_code)::text = 'active'::text)
  • Rows Removed by Filter: 6
6. 0.081 0.081 ↑ 510.0 2 9

Index Scan using cc_order_idx_status on cc_order a (cost=0.29..470.61 rows=1,020 width=85) (actual time=0.007..0.009 rows=2 loops=9)

  • Index Cond: ((status_id = s.status_id) AND (status_id = ANY ('{1,2,3,4,201,202,203,41074871023437782,204,205,41074790371427610,41074815851824421,40626382319388217,41076109836551615,41076264940078335}'::bigint[])))
  • Filter: (dep_id = '37907397910465070'::bigint)
  • Rows Removed by Filter: 1
7. 0.011 0.021 ↓ 1.1 9 1

Hash (cost=1.08..1.08 rows=8 width=11) (actual time=0.021..0.021 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.010 0.010 ↓ 1.1 9 1

Seq Scan on org_dep d (cost=0.00..1.08 rows=8 width=11) (actual time=0.009..0.010 rows=9 loops=1)