explain.depesz.com

PostgreSQL's explain analyze made readable

Result: riKN

Settings
# exclusive inclusive rows x rows loops node
1. 5,581.394 5,957.130 ↓ 6.2 5,370,704 1

Bitmap Heap Scan on qpq_item_statements (cost=14,029.19..2,170,885.90 rows=864,907 width=4) (actual time=626.986..5,957.130 rows=5,370,704 loops=1)

  • Recheck Cond: ((edge_property_id = 31) AND (target_item_id = 5))
  • Heap Blocks: exact=1292078
2. 375.736 375.736 ↓ 6.2 5,370,704 1

Bitmap Index Scan on qpq_item_statements_source_item_id_idx (cost=0.00..13,812.97 rows=864,907 width=0) (actual time=375.736..375.736 rows=5,370,704 loops=1)

Planning time : 1.977 ms
Execution time : 6,070.786 ms