explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ow33

Settings
# exclusive inclusive rows x rows loops node
1. 1,527.964 1,784.581 ↑ 67.1 197 1

Bitmap Heap Scan on project_survey_items (cost=158.89..50,427.61 rows=13,219 width=343) (actual time=266.082..1,784.581 rows=197 loops=1)

  • Recheck Cond: (project_id = 7,960)
  • Rows Removed by Index Recheck: 21,604
  • Heap Blocks: exact=41,020 lossy=2,303,702
2. 256.617 256.617 ↓ 222.5 2,941,326 1

Bitmap Index Scan on index_project_survey_items_on_project_id (cost=0.00..155.58 rows=13,219 width=0) (actual time=256.617..256.617 rows=2,941,326 loops=1)

  • Index Cond: (project_id = 7,960)
Planning time : 0.056 ms
Execution time : 1,785.466 ms