explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tAAC

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.159 ↓ 2.0 2 1

GroupAggregate (cost=30.34..30.36 rows=1 width=12) (actual time=0.159..0.159 rows=2 loops=1)

  • Group Key: poc.id
2. 0.005 0.156 ↓ 2.0 2 1

Sort (cost=30.34..30.34 rows=1 width=8) (actual time=0.156..0.156 rows=2 loops=1)

  • Sort Key: poc.id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.151 ↓ 2.0 2 1

Nested Loop Semi Join (cost=10.36..30.33 rows=1 width=8) (actual time=0.113..0.151 rows=2 loops=1)

  • Join Filter: (poc.id = poc_delivery_type.poc_id)
4. 0.005 0.136 ↓ 2.0 2 1

Nested Loop (cost=9.94..22.43 rows=1 width=12) (actual time=0.104..0.136 rows=2 loops=1)

5. 0.038 0.103 ↓ 7.0 7 1

Bitmap Heap Scan on poc (cost=9.53..13.79 rows=1 width=4) (actual time=0.076..0.103 rows=7 loops=1)

  • Recheck Cond: ((coverage_area ~ '0101000000484E266E155847C00D897B2C7D9837C0'::geometry) AND (status = 'OPERATIONAL'::poc_status))
  • Filter: (is_open AND _st_contains(coverage_area, '0101000000484E266E155847C00D897B2C7D9837C0'::geometry))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=7
6. 0.003 0.065 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.065..0.065 rows=0 loops=1)

7. 0.031 0.031 ↓ 6.3 19 1

Bitmap Index Scan on idx_poc_coverage_area (cost=0.00..4.17 rows=3 width=0) (actual time=0.031..0.031 rows=19 loops=1)

  • Index Cond: (coverage_area ~ '0101000000484E266E155847C00D897B2C7D9837C0'::geometry)
8. 0.031 0.031 ↓ 1.1 125 1

Bitmap Index Scan on ix_poc_status (cost=0.00..5.11 rows=110 width=0) (actual time=0.031..0.031 rows=125 loops=1)

  • Index Cond: (status = 'OPERATIONAL'::poc_status)
9. 0.028 0.028 ↓ 0.0 0 7

Index Scan using poc_product_variant on inventory_item (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=7)

  • Index Cond: ((poc_id = poc.id) AND (product_variant_id = 8502))
  • Filter: ((available_date IS NOT NULL) AND (price > '0'::double precision))
  • Rows Removed by Filter: 1
10. 0.002 0.014 ↑ 1.0 1 2

Nested Loop (cost=0.41..7.88 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=2)

11. 0.008 0.008 ↑ 1.0 1 2

Index Scan using poc_delivery_type_poc_id_index on poc_delivery_type (cost=0.28..7.69 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (poc_id = inventory_item.poc_id)
  • Filter: active
12. 0.004 0.004 ↑ 1.0 1 2

Index Scan using delivery_type_pkey on delivery_type (cost=0.13..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=2)

  • Index Cond: (id = poc_delivery_type.delivery_type_id)
  • Filter: (type = 'RECEIVE'::deliverytypeenum)
Planning time : 0.721 ms
Execution time : 0.209 ms