explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pab

Settings
# exclusive inclusive rows x rows loops node
1. 1.317 2.526 ↓ 4.1 823 1

GroupAggregate (cost=2,070.21..2,078.01 rows=200 width=240) (actual time=1.175..2.526 rows=823 loops=1)

  • Group Key: daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id
2. 0.377 1.209 ↑ 1.3 823 1

Sort (cost=2,070.21..2,070.76 rows=1,100 width=61) (actual time=1.161..1.209 rows=823 loops=1)

  • Sort Key: daily_product_metrics_ongoing_totals_p2019_02_20.product_tm_id
  • Sort Method: quicksort Memory: 105kB
3. 0.735 0.832 ↑ 1.3 823 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals_p2019_02_20 (cost=14.37..2,059.10 rows=1,100 width=61) (actual time=0.139..0.832 rows=823 loops=1)

  • Recheck Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2019-02-20'::date))
  • Heap Blocks: exact=326
4. 0.097 0.097 ↑ 1.3 823 1

Bitmap Index Scan on daily_product_metrics_ongoin_seller_marketplace_tm_id_da_idx307 (cost=0.00..14.31 rows=1,100 width=0) (actual time=0.097..0.097 rows=823 loops=1)

  • Index Cond: ((seller_marketplace_tm_id = 'e5b9f199-6ff6-48a2-9cae-801e935e0ae7'::uuid) AND (date = '2019-02-20'::date))
Planning time : 0.211 ms
Execution time : 2.613 ms