explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BY3F

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.276 ↓ 2.0 2 1

WindowAgg (cost=12.65..12.67 rows=1 width=189) (actual time=0.272..0.276 rows=2 loops=1)

2. 0.045 0.255 ↓ 2.0 2 1

Sort (cost=12.65..12.65 rows=1 width=189) (actual time=0.255..0.255 rows=2 loops=1)

  • Sort Key: ig.group_code
  • Sort Method: quicksort Memory: 25kB
3. 0.017 0.210 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.51..12.64 rows=1 width=189) (actual time=0.123..0.210 rows=2 loops=1)

  • Join Filter: (isgtd.item_subgroup_id = isg.item_subgroup_id)
  • Rows Removed by Join Filter: 44
4. 0.008 0.183 ↓ 2.0 2 1

Nested Loop (cost=1.51..11.30 rows=1 width=149) (actual time=0.109..0.183 rows=2 loops=1)

5. 0.042 0.106 ↓ 23.0 23 1

Hash Join (cost=1.22..2.98 rows=1 width=149) (actual time=0.065..0.106 rows=23 loops=1)

  • Hash Cond: (ig.item_group_id = isg.item_group_id)
6. 0.035 0.035 ↑ 1.0 46 1

Seq Scan on item_groups ig (cost=0.00..1.58 rows=46 width=15) (actual time=0.012..0.035 rows=46 loops=1)

  • Filter: ((status)::text = 'A'::text)
7. 0.013 0.029 ↓ 23.0 23 1

Hash (cost=1.21..1.21 rows=1 width=138) (actual time=0.029..0.029 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
8. 0.016 0.016 ↓ 23.0 23 1

Seq Scan on item_sub_groups isg (cost=0.00..1.21 rows=1 width=138) (actual time=0.006..0.016 rows=23 loops=1)

  • Filter: ((status)::text = 'A'::text)
9. 0.069 0.069 ↓ 0.0 0 23

Index Only Scan using store_item_sub_groups_pkey on store_item_sub_groups sisg (cost=0.29..8.31 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=23)

  • Index Cond: ((medicine_id = 3941) AND (item_subgroup_id = isg.item_subgroup_id))
  • Heap Fetches: 2
10. 0.010 0.010 ↓ 1.5 23 2

Seq Scan on item_sub_groups_tax_details isgtd (cost=0.00..1.15 rows=15 width=44) (actual time=0.002..0.005 rows=23 loops=2)

Total runtime : 0.511 ms