explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bD2k

Settings
# exclusive inclusive rows x rows loops node
1. 731,676.856 732,301.442 ↑ 1.1 1,807,833 1

Bitmap Heap Scan on item_statements (cost=36,602.65..5,792,232.58 rows=1,955,365 width=183) (actual time=1,096.584..732,301.442 rows=1,807,833 loops=1)

  • Recheck Cond: (edge_property_id = 570)
  • Heap Blocks: exact=1334364
2. 624.586 624.586 ↑ 1.1 1,807,833 1

Bitmap Index Scan on item_statements_edge_property_id_idx (cost=0.00..36,113.81 rows=1,955,365 width=0) (actual time=624.586..624.586 rows=1,807,833 loops=1)

  • Index Cond: (edge_property_id = 570)
Planning time : 0.076 ms
Execution time : 732,420.364 ms