explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bokk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Group (cost=30,522.24..30,538.49 rows=1,625 width=39) (actual rows= loops=)

  • Group Key: x.barcode, x.libelle, x.category_id_from_store
2. 0.000 0.000 ↓ 0.0

Sort (cost=30,522.24..30,526.30 rows=1,625 width=39) (actual rows= loops=)

  • Sort Key: x.barcode, x.libelle, x.category_id_from_store
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,801.70..30,435.58 rows=1,625 width=39) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=19,801.15..19,813.78 rows=1,263 width=32) (actual rows= loops=)

  • Group Key: ("ANY_subquery".store_id)::text, ("ANY_subquery".barcode)::text, "ANY_subquery".date
5. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=19,453.90..19,706.44 rows=12,627 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=19,453.90..19,580.17 rows=12,627 width=32) (actual rows= loops=)

  • Group Key: productids_summaries.store_id, productids_summaries.barcode
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_productids_summaries on productids_summaries (cost=0.55..19,356.41 rows=12,999 width=32) (actual rows= loops=)

  • Index Cond: ((store_id)::text = ANY ('{82682-82069}'::text[]))
8. 0.000 0.000 ↓ 0.0

Index Scan using pk_productids_summaries on productids_summaries x (cost=0.55..8.40 rows=1 width=59) (actual rows= loops=)

  • Index Cond: (((store_id)::text = ("ANY_subquery".store_id)::text) AND ((store_id)::text = ANY ('{82682-82069}'::text[])) AND ((barcode)::text = ("ANY_subquery".barcode)::text))
  • Filter: ("ANY_subquery".date = date)