explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OYPg

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 9.875 ↓ 2.0 2 1

HashAggregate (cost=74.01..74.02 rows=1 width=634) (actual time=9.874..9.875 rows=2 loops=1)

  • Group Key: category.model_name_, category.category_
2. 0.672 9.860 ↓ 2.0 2 1

Nested Loop (cost=0.00..74.00 rows=1 width=634) (actual time=3.813..9.860 rows=2 loops=1)

  • Join Filter: ((category.dealer_code_)::text = (msi.dealer_code_)::text)
  • Rows Removed by Join Filter: 206
3. 1.752 1.752 ↓ 4.0 4 1

Foreign Scan on sd_sales_result_category category (cost=0.00..2.58 rows=1 width=732) (actual time=1.526..1.752 rows=4 loops=1)

  • Filter: (((stu_day_)::text >= '20190312'::text) AND ((stu_day_)::text <= '20190412'::text) AND ((category_type_)::text = 'C520AGE'::text))
  • Rows Removed by Filter: 117
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/101873/208667
  • CStore File Size: 5821
4. 7.436 7.436 ↓ 52.0 52 4

Foreign Scan on mst_site_info msi (cost=0.00..71.41 rows=1 width=58) (actual time=1.301..1.859 rows=52 loops=4)

  • Filter: (((territory_)::text = '7b4082e0-9b76-4190-bb68-5b8bdac2a1d0'::text) AND ((area_)::text = '5bd4791d-458f-4307-9a14-9a42e3b35574'::text) AND ((sub_area_)::text = 'd86f01a7-6909-4b99-9d08-87574d832872'::text) AND ((md_dealer_code_)::text = 'FD0601'::text))
  • Rows Removed by Filter: 3307
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/101873/210606
  • CStore File Size: 172429