explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o7l2

Settings
# exclusive inclusive rows x rows loops node
1. 126.947 208.407 ↑ 1.0 1 1

Aggregate (cost=1,720.58..1,720.59 rows=1 width=201) (actual time=208.406..208.407 rows=1 loops=1)

  • Output: array_agg(ROW(field, text_value, int_value, bool_value, domain_value, subnet_value, vm_repetition_group_key_value, vm_repetition_group_index_value, nic_index_value, external_subnet_value, type))
2. 81.460 81.460 ↑ 1.0 71,246 1

Seq Scan on public.config_module_attribute (cost=0.00..1,542.46 rows=71,246 width=201) (actual time=0.030..81.460 rows=71,246 loops=1)

  • Output: field, text_value, int_value, bool_value, domain_value, subnet_value, vm_repetition_group_key_value, vm_repetition_group_index_value, nic_index_value, external_subnet_value, type