explain.depesz.com

A tool for finding a real cause for slow queries.

Result: NxG

options
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))