explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NIoVE

Settings
# exclusive inclusive rows x rows loops node
1. 3.897 3.983 ↓ 48.5 97 1

Gather (cost=1,000.56..1,017.40 rows=2 width=276) (actual time=2.743..3.983 rows=97 loops=1)

  • Output: metric_table.date, metric_table.entity_name, metric_table.value, metric_table.company_name, metric_table.company_id, metric_table.entity_id, metric_table.country, metric_table.country_id, metric_table.organization_id, metric_table.rollup, metric_table._primary, metric_table.is_primary_region, metric_table.is_primary_entity, metric_table.hash_code
  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.005 0.086 ↓ 48.5 97 1 / 2

Append (cost=0.56..17.20 rows=2 width=276) (actual time=0.022..0.173 rows=97 loops=1)

  • Worker 0: actual time=0.022..0.173 rows=97 loops=1
3. 0.043 0.043 ↓ 51.0 51 1 / 2

Index Scan using idx_analytics_traffic_similarweb_all_visit on workspaces_reloaded.traffic_similarweb_all_visit metric_table (cost=0.56..8.58 rows=1 width=276) (actual time=0.021..0.087 rows=51 loops=1)

  • Output: metric_table.date, metric_table.entity_name, metric_table.value, metric_table.company_name, metric_table.company_id, metric_table.entity_id, metric_table.country, metric_table.country_id, metric_table.organization_id, metric_table.rollup, metric_table._primary, metric_table.is_primary_region, metric_table.is_primary_entity, metric_table.hash_code
  • Index Cond: ((metric_table.organization_id = 5) AND ((metric_table.rollup)::text = 'month'::text) AND (metric_table.company_id = 1))
  • Filter: (metric_table.country_id = 999)
  • Worker 0: actual time=0.021..0.087 rows=51 loops=1
4. 0.037 0.037 ↓ 46.0 46 1 / 2

Index Scan using idx_analytics_traffic_similarweb_mobile_visit on workspaces_reloaded.traffic_similarweb_mobile_visit (cost=0.56..8.58 rows=1 width=276) (actual time=0.018..0.075 rows=46 loops=1)

  • Output: traffic_similarweb_mobile_visit.date, traffic_similarweb_mobile_visit.entity_name, traffic_similarweb_mobile_visit.value, traffic_similarweb_mobile_visit.company_name, traffic_similarweb_mobile_visit.company_id, traffic_similarweb_mobile_visit.entity_id, traffic_similarweb_mobile_visit.country, traffic_similarweb_mobile_visit.country_id, traffic_similarweb_mobile_visit.organization_id, traffic_similarweb_mobile_visit.rollup, traffic_similarweb_mobile_visit._primary, traffic_similarweb_mobile_visit.is_primary_region, traffic_similarweb_mobile_visit.is_primary_entity, traffic_similarweb_mobile_visit.hash_code
  • Index Cond: ((traffic_similarweb_mobile_visit.organization_id = 5) AND ((traffic_similarweb_mobile_visit.rollup)::text = 'month'::text) AND (traffic_similarweb_mobile_visit.company_id = 1))
  • Filter: (traffic_similarweb_mobile_visit.country_id = 999)
  • Worker 0: actual time=0.018..0.075 rows=46 loops=1
Planning time : 0.168 ms
Execution time : 4.024 ms