explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vJuL

Settings
# exclusive inclusive rows x rows loops node
1. 675,319.218 683,505.946 ↓ 6.1 5,370,704 1

Bitmap Heap Scan on qpq_item_statements (cost=1,151,503.11..3,344,442.97 rows=885,766 width=4) (actual time=8,626.012..683,505.946 rows=5,370,704 loops=1)

  • Recheck Cond: ((target_item_id = 5) AND (edge_property_id = 31))
  • Heap Blocks: exact=1292078
2. 469.258 8,186.728 ↓ 0.0 0 1

BitmapAnd (cost=1,151,503.11..1,151,503.11 rows=885,766 width=0) (actual time=8,186.728..8,186.728 rows=0 loops=1)

3. 1,003.158 1,003.158 ↑ 1.0 5,837,659 1

Bitmap Index Scan on qpq_item_statements_target_item_id_idx (cost=0.00..111,355.46 rows=6,029,718 width=0) (actual time=1,003.158..1,003.158 rows=5,837,659 loops=1)

  • Index Cond: (target_item_id = 5)
4. 6,714.312 6,714.312 ↓ 1.0 56,641,861 1

Bitmap Index Scan on qpq_item_statements_edge_property_id_idx (cost=0.00..1,039,704.52 rows=56,298,660 width=0) (actual time=6,714.312..6,714.312 rows=56,641,861 loops=1)

  • Index Cond: (edge_property_id = 31)
Planning time : 0.061 ms
Execution time : 683,751.167 ms