explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dhyh

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 63.313 ↑ 1,612.0 1 1

Bitmap Heap Scan on search_flightmodel (cost=7,157.33..13,067.36 rows=1,612 width=45) (actual time=63.302..63.313 rows=1 loops=1)

  • Recheck Cond: ((response_segment_id = 13494434) AND (index = 1))
  • Rows Removed by Index Recheck: 80
  • Heap Blocks: exact=1
2. 0.007 63.272 ↓ 0.0 0 1

BitmapAnd (cost=7,157.33..7,157.33 rows=1,612 width=0) (actual time=63.272..63.272 rows=0 loops=1)

3. 0.025 0.025 ↑ 800.1 81 1

Bitmap Index Scan on search_flightmodel_1e6efccb (cost=0.00..1,198.49 rows=64,808 width=0) (actual time=0.025..0.025 rows=81 loops=1)

  • Index Cond: (response_segment_id = 13494434)
4. 63.240 63.240 ↑ 1.0 311,955 1

Bitmap Index Scan on idx_search_flightmodel_index (cost=0.00..5,957.78 rows=322,313 width=0) (actual time=63.240..63.240 rows=311,955 loops=1)

  • Index Cond: (index = 1)
Planning time : 0.101 ms
Execution time : 63.345 ms