explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YmVU

Settings
# exclusive inclusive rows x rows loops node
1. 35.223 1,571.880 ↑ 811.0 1 1

Hash Join (cost=2,068.65..299,039.49 rows=811 width=45) (actual time=1,568.220..1,571.880 rows=1 loops=1)

  • Hash Cond: (search_flightmodel.response_segment_id = search_responsesegmentmodel.id)
2. 1,536.628 1,536.628 ↑ 1.0 311,499 1

Seq Scan on search_flightmodel (cost=0.00..295,753.61 rows=322,430 width=45) (actual time=0.071..1,536.628 rows=311,499 loops=1)

  • Filter: (index = 1)
  • Rows Removed by Filter: 12634257
3. 0.005 0.029 ↑ 802.0 1 1

Hash (cost=2,058.63..2,058.63 rows=802 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.011 0.024 ↑ 802.0 1 1

Bitmap Heap Scan on search_responsesegmentmodel (cost=32.59..2,058.63 rows=802 width=8) (actual time=0.022..0.024 rows=1 loops=1)

  • Recheck Cond: (search_response_id = 6969585)
  • Filter: (index = 1)
  • Heap Blocks: exact=1
5. 0.013 0.013 ↑ 1,595.0 1 1

Bitmap Index Scan on search_responsesegmentmodel_5fc7e9f5 (cost=0.00..32.38 rows=1,595 width=0) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (search_response_id = 6969585)