explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LH03

Settings
# exclusive inclusive rows x rows loops node
1. 35.210 1,524.057 ↑ 810.0 1 1

Hash Join (cost=8,119.44..147,275.13 rows=810 width=45) (actual time=1,520.203..1,524.057 rows=1 loops=1)

  • Hash Cond: (search_flightmodel.response_segment_id = search_responsesegmentmodel.id)
2. 1,422.716 1,488.820 ↑ 1.0 311,933 1

Bitmap Heap Scan on search_flightmodel (cost=6,038.36..143,977.27 rows=322,313 width=45) (actual time=72.985..1,488.820 rows=311,933 loops=1)

  • Recheck Cond: (index = 1)
  • Rows Removed by Index Recheck: 9968198
  • Heap Blocks: exact=25880 lossy=105385
3. 66.104 66.104 ↑ 1.0 311,933 1

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

  • Index Cond: (index = 1)
4. 0.002 0.027 ↑ 791.0 1 1

Hash (cost=2,071.20..2,071.20 rows=791 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.006 0.025 ↑ 791.0 1 1

Bitmap Heap Scan on search_responsesegmentmodel (cost=32.42..2,071.20 rows=791 width=8) (actual time=0.025..0.025 rows=1 loops=1)

  • Recheck Cond: (search_response_id = 6969585)
  • Filter: (index = 1)
  • Heap Blocks: exact=1
6. 0.019 0.019 ↑ 1,573.0 1 1

Bitmap Index Scan on search_responsesegmentmodel_5fc7e9f5 (cost=0.00..32.22 rows=1,573 width=0) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (search_response_id = 6969585)