explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hFlZ : d

Settings
# exclusive inclusive rows x rows loops node
1. 1.032 11.261 ↓ 117.2 1,055 1

Aggregate (cost=1,239.57..1,239.77 rows=9 width=54) (actual time=9.982..11.261 rows=1,055 loops=1)

  • Buffers: shared hit=1,502
2. 4.174 10.229 ↓ 117.2 1,055 1

Sort (cost=1,239.57..1,239.59 rows=9 width=28) (actual time=9.972..10.229 rows=1,055 loops=1)

  • Sort Key: sales.invoice_no, sales.product_id
  • Sort Method: quicksort Memory: 197kB
  • Buffers: shared hit=1,502
3. 6.055 6.055 ↓ 117.2 1,055 1

Index Scan using sales_retail_id_store_id_index on sales sales (cost=0.56..1,239.43 rows=9 width=28) (actual time=0.021..6.055 rows=1,055 loops=1)

  • Index Cond: ((sales.retail_id = 13) AND (sales.store_id = 30,053))
  • Filter: ((sales.sale_timestamp >= '2020-09-01 00:00:00'::timestamp without time zone) AND (sales.sale_timestamp <= '2020-10-05 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1,502
Planning time : 0.186 ms
Execution time : 11.532 ms