Result: NxG

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
60.801	311.613	↓ 308.1	188219	1	→ Hash Right Join (cost=201.17..206.11 rows=611 width=12) (actual time=188.917..311.613 rows=188219 loops=1) Hash Cond: (field_data_field_antwoorden.entity_id = node.nid)
161.644	250.193	↓ 941.1	188219	1	→ HashAggregate (cost=54.86..56.86 rows=200 width=20) (actual time=188.284..250.193 rows=188219 loops=1)
88.549	88.549	↓ 308.1	188219	1	→ Seq Scan on field_data_field_antwoorden (cost=0.00..44.16 rows=611 width=374) (actual time=0.042..88.549 rows=188219 loops=1)
0.206	0.619	↑ 1.0	611	1	→ Hash (cost=138.68..138.68 rows=611 width=4) (actual time=0.619..0.619 rows=611 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 22kB
0.199	0.413	↑ 1.0	611	1	→ Bitmap Heap Scan on node (cost=30.51..138.68 rows=611 width=4) (actual time=0.226..0.413 rows=611 loops=1) Recheck Cond: ((status = 1) AND ((type)::text = 'antwoorden'::text))
0.214	0.214	↑ 1.0	611	1	→ Bitmap Index Scan on node_node_status_type_idx (cost=0.00..30.36 rows=611 width=0) (actual time=0.214..0.214 rows=611 loops=1) Index Cond: ((status = 1) AND ((type)::text = 'antwoorden'::text))

 Hash Right Join  (cost=201.17..206.11 rows=611 width=12) (actual time=188.917..311.613 rows=188219 loops=1)
   Hash Cond: (field_data_field_antwoorden.entity_id = node.nid)
   ->  HashAggregate  (cost=54.86..56.86 rows=200 width=20) (actual time=188.284..250.193 rows=188219 loops=1)
         ->  Seq Scan on field_data_field_antwoorden  (cost=0.00..44.16 rows=611 width=374) (actual time=0.042..88.549 rows=188219 loops=1)
   ->  Hash  (cost=138.68..138.68 rows=611 width=4) (actual time=0.619..0.619 rows=611 loops=1)
         Buckets: 1024  Batches: 1  Memory Usage: 22kB
         ->  Bitmap Heap Scan on node  (cost=30.51..138.68 rows=611 width=4) (actual time=0.226..0.413 rows=611 loops=1)
               Recheck Cond: ((status = 1) AND ((type)::text = 'antwoorden'::text))
               ->  Bitmap Index Scan on node_node_status_type_idx  (cost=0.00..30.36 rows=611 width=0) (actual time=0.214..0.214 rows=611 loops=1)
                     Index Cond: ((status = 1) AND ((type)::text = 'antwoorden'::text))

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.199 ms	0.1 %
Bitmap Index Scan	1	0.214 ms	0.1 %
Hash	1	0.206 ms	0.1 %
Hash Right Join	1	60.801 ms	19.5 %
HashAggregate	1	161.644 ms	51.9 %
Seq Scan	1	88.549 ms	28.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
field_data_field_antwoorden	1	88.549 ms	28.4 %
Seq Scan	1	88.549 ms	100.0 %
node	1	0.199 ms	0.1 %
Bitmap Heap Scan	1	0.199 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: NxG

Colorize:

Columns visibility:

Per node type stats

Per table stats