explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4oHS

Settings
# exclusive inclusive rows x rows loops node
1. 0.235 6.892 ↓ 1.5 305 1

Sort (cost=496.49..496.99 rows=200 width=584) (actual time=6.871..6.892 rows=305 loops=1)

  • Output: (((("*SELECT* 1".metrics_date)::date - to_date('01-JAN-1970'::text, 'DD-MON-YYYY'::text)) * 86400)), 0, (round((sum((0)))::double precision)), 1, 2, 3, (round((sum((0)))::numeric, 2)), (round(sum("*SELECT* 1".page_views), 0)), (round(sum("*SELECT* 1".sessions), 0)), (round(sum("*SELECT* 1".buy_box_percentage), 2)), 4, (round((sum((0)))::numeric, 2)), (round(sum("*SELECT* 1".average_offer_count), 0)), (round(sum("*SELECT* 1".average_parent_items), 0)), (round(sum("*SELECT* 1".units_refunded), 0)), (round((sum((0)))::numeric, 2)), (round(sum(((0)::numeric)), 0)), (round(sum(((0)::numeric)), 0)), (round(sum(((0)::numeric)), 2)), (round(sum("*SELECT* 1".claims_received), 0)), (sum("*SELECT* 1".claims_amt)), (sum("*SELECT* 1".shipped_product_sales)), (round(sum("*SELECT* 1".shipped_units), 0)), (round(sum("*SELECT* 1".shipped_orders), 0)), "*SELECT* 1".metrics_date
  • Sort Key: (((("*SELECT* 1".metrics_date)::date - to_date('01-JAN-1970'::text, 'DD-MON-YYYY'::text)) * 86400))
  • Sort Method: quicksort Memory: 106kB
  • Buffers: shared hit=645
2. 2.342 6.657 ↓ 1.5 305 1

HashAggregate (cost=467.84..488.84 rows=200 width=584) (actual time=5.797..6.657 rows=305 loops=1)

  • Output: ((("*SELECT* 1".metrics_date)::date - to_date('01-JAN-1970'::text, 'DD-MON-YYYY'::text)) * 86400), 0, round((sum((0)))::double precision), 1, 2, 3, round((sum((0)))::numeric, 2), round(sum("*SELECT* 1".page_views), 0), round(sum("*SELECT* 1".sessions), 0), round(sum("*SELECT* 1".buy_box_percentage), 2), 4, round((sum((0)))::numeric, 2), round(sum("*SELECT* 1".average_offer_count), 0), round(sum("*SELECT* 1".average_parent_items), 0), round(sum("*SELECT* 1".units_refunded), 0), round((sum((0)))::numeric, 2), round(sum(((0)::numeric)), 0), round(sum(((0)::numeric)), 0), round(sum(((0)::numeric)), 2), round(sum("*SELECT* 1".claims_received), 0), sum("*SELECT* 1".claims_amt), sum("*SELECT* 1".shipped_product_sales), round(sum("*SELECT* 1".shipped_units), 0), round(sum("*SELECT* 1".shipped_orders), 0), "*SELECT* 1".metrics_date
  • Group Key: "*SELECT* 1".metrics_date
  • Buffers: shared hit=645
3. 0.081 4.315 ↓ 2.8 610 1

Append (cost=402.57..455.48 rows=215 width=524) (actual time=1.827..4.315 rows=610 loops=1)

  • Buffers: shared hit=645
4. 0.151 2.919 ↓ 1.5 305 1

Subquery Scan on *SELECT* 1 (cost=402.57..425.57 rows=200 width=524) (actual time=1.827..2.919 rows=305 loops=1)

  • Output: "*SELECT* 1".metrics_date, 0, 0, 0, 0, 0, 0, "*SELECT* 1".page_views, "*SELECT* 1".sessions, "*SELECT* 1".buy_box_percentage, 0, 0, "*SELECT* 1".average_offer_count, "*SELECT* 1".average_parent_items, "*SELECT* 1".units_refunded, 0, 0, 0, 0, "*SELECT* 1".claims_received, "*SELECT* 1".claims_amt, "*SELECT* 1".total_order_shipped_value, "*SELECT* 1".shipped_units, "*SELECT* 1".shipped_orders, "*SELECT* 1".shipped_product_sales
  • Buffers: shared hit=350
5. 2.082 2.768 ↓ 1.5 305 1

HashAggregate (cost=402.57..422.07 rows=200 width=448) (actual time=1.822..2.768 rows=305 loops=1)

  • Output: (date_trunc('hour'::text, (d_daily_merchant_activity.metrics_date + '12:00:00'::interval))), 0, 0, 0, 0, 0, 0, round(sum(d_daily_merchant_activity.page_views), 0), round(sum(d_daily_merchant_activity.distinct_session_count), 0), CASE WHEN (sum(d_daily_merchant_activity.page_views) = '0'::numeric) THEN '0'::numeric ELSE ('100'::numeric * (sum(d_daily_merchant_activity.buy_box_page_view_count) / sum(d_daily_merchant_activity.page_views))) END, 0, 0, CASE WHEN (sum(d_daily_merchant_activity.offering_count) > '0'::numeric) THEN round((sum(d_daily_merchant_activity.offering_count) / (sum(CASE WHEN (d_daily_merchant_activity.offering_count > '0'::numeric) THEN 1 ELSE 0 END))::numeric), 0) ELSE '0'::numeric END, CASE WHEN (sum(d_daily_merchant_activity.parent_asin_count) > '0'::numeric) THEN round((sum(d_daily_merchant_activity.parent_asin_count) / (sum(CASE WHEN (d_daily_merchant_activity.parent_asin_count > '0'::numeric) THEN 1 ELSE 0 END))::numeric), 0) ELSE '0'::numeric END, round(sum(d_daily_merchant_activity.refund_units), 0), 0, 0, 0, 0, round(sum(d_daily_merchant_activity.merchant_fault_order_count), 0), sum(d_daily_merchant_activity.merchant_fault_product_amt), sum(((d_daily_merchant_activity.gross_shipped_product_amt + d_daily_merchant_activity.gross_shipping_amt) + d_daily_merchant_activity.gross_giftwrap_amt)), round(sum(d_daily_merchant_activity.gross_shipped_units), 0), round(sum(d_daily_merchant_activity.gross_shipped_order_count), 0), sum(d_daily_merchant_activity.gross_shipped_product_amt), d_daily_merchant_activity.marketplace_id
  • Group Key: date_trunc('hour'::text, (d_daily_merchant_activity.metrics_date + '12:00:00'::interval)), d_daily_merchant_activity.marketplace_id
  • Buffers: shared hit=350
6. 0.089 0.686 ↑ 1.2 305 1

Result (cost=0.00..381.51 rows=351 width=61) (actual time=0.029..0.686 rows=305 loops=1)

  • Output: date_trunc('hour'::text, (d_daily_merchant_activity.metrics_date + '12:00:00'::interval)), d_daily_merchant_activity.marketplace_id, d_daily_merchant_activity.page_views, d_daily_merchant_activity.distinct_session_count, d_daily_merchant_activity.buy_box_page_view_count, d_daily_merchant_activity.offering_count, d_daily_merchant_activity.parent_asin_count, d_daily_merchant_activity.refund_units, d_daily_merchant_activity.merchant_fault_order_count, d_daily_merchant_activity.merchant_fault_product_amt, d_daily_merchant_activity.gross_shipped_product_amt, d_daily_merchant_activity.gross_shipping_amt, d_daily_merchant_activity.gross_giftwrap_amt, d_daily_merchant_activity.gross_shipped_units, d_daily_merchant_activity.gross_shipped_order_count
  • Buffers: shared hit=350
7. 0.032 0.597 ↑ 1.2 305 1

Append (cost=0.00..376.24 rows=351 width=62) (actual time=0.023..0.597 rows=305 loops=1)

  • Buffers: shared hit=350
8. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on booker.d_daily_merchant_activity (cost=0.00..0.00 rows=1 width=240) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: d_daily_merchant_activity.metrics_date, d_daily_merchant_activity.page_views, d_daily_merchant_activity.distinct_session_count, d_daily_merchant_activity.buy_box_page_view_count, d_daily_merchant_activity.offering_count, d_daily_merchant_activity.parent_asin_count, d_daily_merchant_activity.refund_units, d_daily_merchant_activity.merchant_fault_order_count, d_daily_merchant_activity.merchant_fault_product_amt, d_daily_merchant_activity.gross_shipped_product_amt, d_daily_merchant_activity.gross_shipping_amt, d_daily_merchant_activity.gross_giftwrap_amt, d_daily_merchant_activity.gross_shipped_units, d_daily_merchant_activity.gross_shipped_order_count, d_daily_merchant_activity.marketplace_id
  • Filter: ((d_daily_merchant_activity.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (d_daily_merchant_activity.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (d_daily_merchant_activity.marketplace_id = 1) AND (d_daily_merchant_activity.merchant_customer_id = 142499351))
9. 0.045 0.045 ↑ 1.1 16 1

Index Scan using u_ddma_201806_1 on booker.ddma_201806 (cost=0.56..20.01 rows=18 width=61) (actual time=0.021..0.045 rows=16 loops=1)

  • Output: ddma_201806.metrics_date, ddma_201806.page_views, ddma_201806.distinct_session_count, ddma_201806.buy_box_page_view_count, ddma_201806.offering_count, ddma_201806.parent_asin_count, ddma_201806.refund_units, ddma_201806.merchant_fault_order_count, ddma_201806.merchant_fault_product_amt, ddma_201806.gross_shipped_product_amt, ddma_201806.gross_shipping_amt, ddma_201806.gross_giftwrap_amt, ddma_201806.gross_shipped_units, ddma_201806.gross_shipped_order_count, ddma_201806.marketplace_id
  • Index Cond: ((ddma_201806.merchant_customer_id = 142499351) AND (ddma_201806.marketplace_id = 1) AND (ddma_201806.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201806.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=20
10. 0.057 0.057 ↑ 1.2 31 1

Index Scan using u_ddma_201807_1 on booker.ddma_201807 (cost=0.56..39.49 rows=37 width=61) (actual time=0.015..0.057 rows=31 loops=1)

  • Output: ddma_201807.metrics_date, ddma_201807.page_views, ddma_201807.distinct_session_count, ddma_201807.buy_box_page_view_count, ddma_201807.offering_count, ddma_201807.parent_asin_count, ddma_201807.refund_units, ddma_201807.merchant_fault_order_count, ddma_201807.merchant_fault_product_amt, ddma_201807.gross_shipped_product_amt, ddma_201807.gross_shipping_amt, ddma_201807.gross_giftwrap_amt, ddma_201807.gross_shipped_units, ddma_201807.gross_shipped_order_count, ddma_201807.marketplace_id
  • Index Cond: ((ddma_201807.merchant_customer_id = 142499351) AND (ddma_201807.marketplace_id = 1) AND (ddma_201807.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201807.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=35
11. 0.057 0.057 ↑ 1.2 31 1

Index Scan using u_ddma_201808_1 on booker.ddma_201808 (cost=0.56..38.46 rows=36 width=61) (actual time=0.014..0.057 rows=31 loops=1)

  • Output: ddma_201808.metrics_date, ddma_201808.page_views, ddma_201808.distinct_session_count, ddma_201808.buy_box_page_view_count, ddma_201808.offering_count, ddma_201808.parent_asin_count, ddma_201808.refund_units, ddma_201808.merchant_fault_order_count, ddma_201808.merchant_fault_product_amt, ddma_201808.gross_shipped_product_amt, ddma_201808.gross_shipping_amt, ddma_201808.gross_giftwrap_amt, ddma_201808.gross_shipped_units, ddma_201808.gross_shipped_order_count, ddma_201808.marketplace_id
  • Index Cond: ((ddma_201808.merchant_customer_id = 142499351) AND (ddma_201808.marketplace_id = 1) AND (ddma_201808.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201808.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=36
12. 0.051 0.051 ↑ 1.2 30 1

Index Scan using u_ddma_201809_1 on booker.ddma_201809 (cost=0.56..38.46 rows=36 width=61) (actual time=0.012..0.051 rows=30 loops=1)

  • Output: ddma_201809.metrics_date, ddma_201809.page_views, ddma_201809.distinct_session_count, ddma_201809.buy_box_page_view_count, ddma_201809.offering_count, ddma_201809.parent_asin_count, ddma_201809.refund_units, ddma_201809.merchant_fault_order_count, ddma_201809.merchant_fault_product_amt, ddma_201809.gross_shipped_product_amt, ddma_201809.gross_shipping_amt, ddma_201809.gross_giftwrap_amt, ddma_201809.gross_shipped_units, ddma_201809.gross_shipped_order_count, ddma_201809.marketplace_id
  • Index Cond: ((ddma_201809.merchant_customer_id = 142499351) AND (ddma_201809.marketplace_id = 1) AND (ddma_201809.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201809.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=34
13. 0.057 0.057 ↑ 1.2 31 1

Index Scan using u_ddma_201810_1 on booker.ddma_201810 (cost=0.56..38.46 rows=36 width=61) (actual time=0.012..0.057 rows=31 loops=1)

  • Output: ddma_201810.metrics_date, ddma_201810.page_views, ddma_201810.distinct_session_count, ddma_201810.buy_box_page_view_count, ddma_201810.offering_count, ddma_201810.parent_asin_count, ddma_201810.refund_units, ddma_201810.merchant_fault_order_count, ddma_201810.merchant_fault_product_amt, ddma_201810.gross_shipped_product_amt, ddma_201810.gross_shipping_amt, ddma_201810.gross_giftwrap_amt, ddma_201810.gross_shipped_units, ddma_201810.gross_shipped_order_count, ddma_201810.marketplace_id
  • Index Cond: ((ddma_201810.merchant_customer_id = 142499351) AND (ddma_201810.marketplace_id = 1) AND (ddma_201810.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201810.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=35
14. 0.048 0.048 ↑ 1.1 30 1

Index Scan using u_ddma_201811_1 on booker.ddma_201811 (cost=0.56..36.33 rows=34 width=61) (actual time=0.011..0.048 rows=30 loops=1)

  • Output: ddma_201811.metrics_date, ddma_201811.page_views, ddma_201811.distinct_session_count, ddma_201811.buy_box_page_view_count, ddma_201811.offering_count, ddma_201811.parent_asin_count, ddma_201811.refund_units, ddma_201811.merchant_fault_order_count, ddma_201811.merchant_fault_product_amt, ddma_201811.gross_shipped_product_amt, ddma_201811.gross_shipping_amt, ddma_201811.gross_giftwrap_amt, ddma_201811.gross_shipped_units, ddma_201811.gross_shipped_order_count, ddma_201811.marketplace_id
  • Index Cond: ((ddma_201811.merchant_customer_id = 142499351) AND (ddma_201811.marketplace_id = 1) AND (ddma_201811.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201811.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=34
15. 0.056 0.056 ↑ 1.2 31 1

Index Scan using u_ddma_201812_1 on booker.ddma_201812 (cost=0.56..38.46 rows=36 width=61) (actual time=0.011..0.056 rows=31 loops=1)

  • Output: ddma_201812.metrics_date, ddma_201812.page_views, ddma_201812.distinct_session_count, ddma_201812.buy_box_page_view_count, ddma_201812.offering_count, ddma_201812.parent_asin_count, ddma_201812.refund_units, ddma_201812.merchant_fault_order_count, ddma_201812.merchant_fault_product_amt, ddma_201812.gross_shipped_product_amt, ddma_201812.gross_shipping_amt, ddma_201812.gross_giftwrap_amt, ddma_201812.gross_shipped_units, ddma_201812.gross_shipped_order_count, ddma_201812.marketplace_id
  • Index Cond: ((ddma_201812.merchant_customer_id = 142499351) AND (ddma_201812.marketplace_id = 1) AND (ddma_201812.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201812.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=35
16. 0.057 0.057 ↑ 1.1 31 1

Index Scan using i_ddma_201901_1 on booker.ddma_201901 (cost=0.56..36.51 rows=34 width=61) (actual time=0.013..0.057 rows=31 loops=1)

  • Output: ddma_201901.metrics_date, ddma_201901.page_views, ddma_201901.distinct_session_count, ddma_201901.buy_box_page_view_count, ddma_201901.offering_count, ddma_201901.parent_asin_count, ddma_201901.refund_units, ddma_201901.merchant_fault_order_count, ddma_201901.merchant_fault_product_amt, ddma_201901.gross_shipped_product_amt, ddma_201901.gross_shipping_amt, ddma_201901.gross_giftwrap_amt, ddma_201901.gross_shipped_units, ddma_201901.gross_shipped_order_count, ddma_201901.marketplace_id
  • Index Cond: ((ddma_201901.merchant_customer_id = 142499351) AND (ddma_201901.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201901.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (ddma_201901.marketplace_id = 1))
  • Buffers: shared hit=35
17. 0.049 0.049 ↑ 1.1 28 1

Index Scan using i_ddma_201902_1 on booker.ddma_201902 (cost=0.56..34.47 rows=32 width=62) (actual time=0.012..0.049 rows=28 loops=1)

  • Output: ddma_201902.metrics_date, ddma_201902.page_views, ddma_201902.distinct_session_count, ddma_201902.buy_box_page_view_count, ddma_201902.offering_count, ddma_201902.parent_asin_count, ddma_201902.refund_units, ddma_201902.merchant_fault_order_count, ddma_201902.merchant_fault_product_amt, ddma_201902.gross_shipped_product_amt, ddma_201902.gross_shipping_amt, ddma_201902.gross_giftwrap_amt, ddma_201902.gross_shipped_units, ddma_201902.gross_shipped_order_count, ddma_201902.marketplace_id
  • Index Cond: ((ddma_201902.merchant_customer_id = 142499351) AND (ddma_201902.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201902.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (ddma_201902.marketplace_id = 1))
  • Buffers: shared hit=32
18. 0.051 0.051 ↑ 1.1 31 1

Index Scan using i_ddma_201903_1 on booker.ddma_201903 (cost=0.56..36.53 rows=34 width=62) (actual time=0.011..0.051 rows=31 loops=1)

  • Output: ddma_201903.metrics_date, ddma_201903.page_views, ddma_201903.distinct_session_count, ddma_201903.buy_box_page_view_count, ddma_201903.offering_count, ddma_201903.parent_asin_count, ddma_201903.refund_units, ddma_201903.merchant_fault_order_count, ddma_201903.merchant_fault_product_amt, ddma_201903.gross_shipped_product_amt, ddma_201903.gross_shipping_amt, ddma_201903.gross_giftwrap_amt, ddma_201903.gross_shipped_units, ddma_201903.gross_shipped_order_count, ddma_201903.marketplace_id
  • Index Cond: ((ddma_201903.merchant_customer_id = 142499351) AND (ddma_201903.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201903.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (ddma_201903.marketplace_id = 1))
  • Buffers: shared hit=35
19. 0.035 0.035 ↑ 1.1 15 1

Index Scan using i_ddma_201904_1 on booker.ddma_201904 (cost=0.56..19.05 rows=17 width=62) (actual time=0.012..0.035 rows=15 loops=1)

  • Output: ddma_201904.metrics_date, ddma_201904.page_views, ddma_201904.distinct_session_count, ddma_201904.buy_box_page_view_count, ddma_201904.offering_count, ddma_201904.parent_asin_count, ddma_201904.refund_units, ddma_201904.merchant_fault_order_count, ddma_201904.merchant_fault_product_amt, ddma_201904.gross_shipped_product_amt, ddma_201904.gross_shipping_amt, ddma_201904.gross_giftwrap_amt, ddma_201904.gross_shipped_units, ddma_201904.gross_shipped_order_count, ddma_201904.marketplace_id
  • Index Cond: ((ddma_201904.merchant_customer_id = 142499351) AND (ddma_201904.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddma_201904.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (ddma_201904.marketplace_id = 1))
  • Buffers: shared hit=19
20. 0.384 1.315 ↓ 20.3 305 1

Subquery Scan on *SELECT* 2 (cost=28.71..29.91 rows=15 width=524) (actual time=0.599..1.315 rows=305 loops=1)

  • Output: "*SELECT* 2".metrics_date, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "*SELECT* 2".feedback_received, "*SELECT* 2".neg_feedback_received, "*SELECT* 2".received_neg_feedback_rate, 0, 0, 0, 0, 0, 0
  • Buffers: shared hit=295
21. 0.606 0.931 ↓ 20.3 305 1

HashAggregate (cost=28.71..29.31 rows=15 width=196) (actual time=0.592..0.931 rows=305 loops=1)

  • Output: (date_trunc('hour'::text, (d_merchant_feedback_ratings.metrics_date + '12:00:00'::interval))), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, round(sum(d_merchant_feedback_ratings.total_feedback_count), 0), round(sum(d_merchant_feedback_ratings.negetive_feedback_rating_count), 0), CASE WHEN (sum(d_merchant_feedback_ratings.total_feedback_count) = '0'::numeric) THEN '0'::numeric ELSE ('100'::numeric * (sum(d_merchant_feedback_ratings.negetive_feedback_rating_count) / sum(d_merchant_feedback_ratings.total_feedback_count))) END, 0, 0, 0, 0, 0, 0, d_merchant_feedback_ratings.marketplace_id
  • Group Key: date_trunc('hour'::text, (d_merchant_feedback_ratings.metrics_date + '12:00:00'::interval)), d_merchant_feedback_ratings.marketplace_id
  • Buffers: shared hit=295
22. 0.085 0.325 ↓ 20.3 305 1

Result (cost=0.00..28.45 rows=15 width=48) (actual time=0.020..0.325 rows=305 loops=1)

  • Output: date_trunc('hour'::text, (d_merchant_feedback_ratings.metrics_date + '12:00:00'::interval)), d_merchant_feedback_ratings.marketplace_id, d_merchant_feedback_ratings.total_feedback_count, d_merchant_feedback_ratings.negetive_feedback_rating_count
  • Buffers: shared hit=295
23. 0.024 0.240 ↓ 20.3 305 1

Append (cost=0.00..28.22 rows=15 width=48) (actual time=0.014..0.240 rows=305 loops=1)

  • Buffers: shared hit=295
24. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on booker.d_merchant_feedback_ratings (cost=0.00..0.00 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: d_merchant_feedback_ratings.metrics_date, d_merchant_feedback_ratings.total_feedback_count, d_merchant_feedback_ratings.negetive_feedback_rating_count, d_merchant_feedback_ratings.marketplace_id
  • Filter: ((d_merchant_feedback_ratings.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (d_merchant_feedback_ratings.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone) AND (d_merchant_feedback_ratings.merchant_customer_id = 142499351) AND (d_merchant_feedback_ratings.marketplace_id = 1))
25. 0.185 0.185 ↓ 76.2 305 1

Index Scan using u_dmfr_000001 on booker.dmfr_000001 (cost=0.56..5.66 rows=4 width=48) (actual time=0.013..0.185 rows=305 loops=1)

  • Output: dmfr_000001.metrics_date, dmfr_000001.total_feedback_count, dmfr_000001.negetive_feedback_rating_count, dmfr_000001.marketplace_id
  • Index Cond: ((dmfr_000001.merchant_customer_id = 142499351) AND (dmfr_000001.marketplace_id = 1) AND (dmfr_000001.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000001.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=279
26. 0.002 0.002 ↓ 0.0 0 1

Index Scan using u_dmfr_000003 on booker.dmfr_000003 (cost=0.15..2.17 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: dmfr_000003.metrics_date, dmfr_000003.total_feedback_count, dmfr_000003.negetive_feedback_rating_count, dmfr_000003.marketplace_id
  • Index Cond: ((dmfr_000003.merchant_customer_id = 142499351) AND (dmfr_000003.marketplace_id = 1) AND (dmfr_000003.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000003.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
27. 0.001 0.001 ↓ 0.0 0 1

Index Scan using u_dmfr_000004 on booker.dmfr_000004 (cost=0.15..2.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: dmfr_000004.metrics_date, dmfr_000004.total_feedback_count, dmfr_000004.negetive_feedback_rating_count, dmfr_000004.marketplace_id
  • Index Cond: ((dmfr_000004.merchant_customer_id = 142499351) AND (dmfr_000004.marketplace_id = 1) AND (dmfr_000004.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000004.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
28. 0.002 0.002 ↓ 0.0 0 1

Index Scan using u_dmfr_000005 on booker.dmfr_000005 (cost=0.15..2.17 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: dmfr_000005.metrics_date, dmfr_000005.total_feedback_count, dmfr_000005.negetive_feedback_rating_count, dmfr_000005.marketplace_id
  • Index Cond: ((dmfr_000005.merchant_customer_id = 142499351) AND (dmfr_000005.marketplace_id = 1) AND (dmfr_000005.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000005.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
29. 0.001 0.001 ↓ 0.0 0 1

Index Scan using u_dmfr_000006 on booker.dmfr_000006 (cost=0.15..2.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: dmfr_000006.metrics_date, dmfr_000006.total_feedback_count, dmfr_000006.negetive_feedback_rating_count, dmfr_000006.marketplace_id
  • Index Cond: ((dmfr_000006.merchant_customer_id = 142499351) AND (dmfr_000006.marketplace_id = 1) AND (dmfr_000006.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000006.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
30. 0.008 0.008 ↓ 0.0 0 1

Index Scan using u_dmfr_000007 on booker.dmfr_000007 (cost=0.43..2.45 rows=1 width=48) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: dmfr_000007.metrics_date, dmfr_000007.total_feedback_count, dmfr_000007.negetive_feedback_rating_count, dmfr_000007.marketplace_id
  • Index Cond: ((dmfr_000007.merchant_customer_id = 142499351) AND (dmfr_000007.marketplace_id = 1) AND (dmfr_000007.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_000007.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=3
31. 0.001 0.001 ↓ 0.0 0 1

Index Scan using u_dmfr_091960 on booker.dmfr_091960 (cost=0.15..2.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: dmfr_091960.metrics_date, dmfr_091960.total_feedback_count, dmfr_091960.negetive_feedback_rating_count, dmfr_091960.marketplace_id
  • Index Cond: ((dmfr_091960.merchant_customer_id = 142499351) AND (dmfr_091960.marketplace_id = 1) AND (dmfr_091960.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_091960.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
32. 0.006 0.006 ↓ 0.0 0 1

Index Scan using u_dmfr_526970 on booker.dmfr_526970 (cost=0.41..2.44 rows=1 width=48) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: dmfr_526970.metrics_date, dmfr_526970.total_feedback_count, dmfr_526970.negetive_feedback_rating_count, dmfr_526970.marketplace_id
  • Index Cond: ((dmfr_526970.merchant_customer_id = 142499351) AND (dmfr_526970.marketplace_id = 1) AND (dmfr_526970.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_526970.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=3
33. 0.007 0.007 ↓ 0.0 0 1

Index Scan using u_dmfr_771770 on booker.dmfr_771770 (cost=0.42..2.44 rows=1 width=48) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: dmfr_771770.metrics_date, dmfr_771770.total_feedback_count, dmfr_771770.negetive_feedback_rating_count, dmfr_771770.marketplace_id
  • Index Cond: ((dmfr_771770.merchant_customer_id = 142499351) AND (dmfr_771770.marketplace_id = 1) AND (dmfr_771770.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_771770.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=3
34. 0.001 0.001 ↓ 0.0 0 1

Index Scan using u_dmfr_999999 on booker.dmfr_999999 (cost=0.15..2.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: dmfr_999999.metrics_date, dmfr_999999.total_feedback_count, dmfr_999999.negetive_feedback_rating_count, dmfr_999999.marketplace_id
  • Index Cond: ((dmfr_999999.merchant_customer_id = 142499351) AND (dmfr_999999.marketplace_id = 1) AND (dmfr_999999.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (dmfr_999999.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1
35. 0.001 0.001 ↓ 0.0 0 1

Index Scan using u_ddmfr_0000001338980 on booker.ddmfr_0000001338980 (cost=0.15..2.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: ddmfr_0000001338980.metrics_date, ddmfr_0000001338980.total_feedback_count, ddmfr_0000001338980.negetive_feedback_rating_count, ddmfr_0000001338980.marketplace_id
  • Index Cond: ((ddmfr_0000001338980.merchant_customer_id = 142499351) AND (ddmfr_0000001338980.marketplace_id = 1) AND (ddmfr_0000001338980.metrics_date >= '2018-06-14 12:00:00'::timestamp without time zone) AND (ddmfr_0000001338980.metrics_date <= '2019-04-15 12:00:00'::timestamp without time zone))
  • Buffers: shared hit=1