explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xtQC

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

Group (cost=1,324.72..1,325.16 rows=44 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=1,324.72..1,324.83 rows=44 width=39) (actual rows= loops=)

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

Hash Join (cost=669.28..1,323.52 rows=44 width=39) (actual rows= loops=)

  • Hash Cond: (((x.store_id)::text = ("ANY_subquery".store_id)::text) AND ((x.barcode)::text = ("ANY_subquery".barcode)::text) AND (x.date = "ANY_subquery".date))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..650.82 rows=354 width=91) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.02..0.03 rows=1 width=32) (actual rows= loops=)

  • Group Key: '82682-82069'::text
6. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((store_id)::text = ('82682-82069'::text))
8. 0.000 0.000 ↓ 0.0

Hash (cost=665.21..665.21 rows=200 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=663.21..665.21 rows=200 width=32) (actual rows= loops=)

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

Subquery Scan on ANY_subquery (cost=653.47..660.55 rows=354 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

HashAggregate (cost=653.47..657.01 rows=354 width=32) (actual rows= loops=)

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

Nested Loop (cost=0.57..650.82 rows=354 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.02..0.03 rows=1 width=32) (actual rows= loops=)

  • Group Key: '82682-82069'::text
14. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using pk_productids_summaries on productids_summaries (cost=0.55..647.25 rows=354 width=32) (actual rows= loops=)

  • Index Cond: ((store_id)::text = ('82682-82069'::text))