explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nhu

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.038 ↑ 1.0 1 1

Bitmap Heap Scan on qpq_item_statements (cost=139.94..143.95 rows=1 width=62) (actual time=0.037..0.038 rows=1 loops=1)

  • Recheck Cond: ((source_item_id = 31) AND (target_item_id = 1088364))
  • Filter: (edge_property_id = 1344)
  • Heap Blocks: exact=1
2. 0.002 0.032 ↓ 0.0 0 1

BitmapAnd (cost=139.94..139.94 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

3. 0.021 0.021 ↑ 14.9 175 1

Bitmap Index Scan on qpq_item_statements_source_item_id_idx (cost=0.00..52.19 rows=2,616 width=0) (actual time=0.021..0.021 rows=175 loops=1)

  • Index Cond: (source_item_id = 31)
4. 0.009 0.009 ↑ 194.0 24 1

Bitmap Index Scan on qpq_item_statements_target_item_id_idx (cost=0.00..87.49 rows=4,656 width=0) (actual time=0.009..0.009 rows=24 loops=1)

  • Index Cond: (target_item_id = 1088364)
Planning time : 0.084 ms
Execution time : 0.055 ms