explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tjdj

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 52,181.925 ↑ 1.0 1 1

Limit (cost=0.56..224.70 rows=1 width=51) (actual time=52,181.924..52,181.925 rows=1 loops=1)

2. 52,181.922 52,181.922 ↑ 261,100.0 1 1

Index Scan using search_passengerfareproductsectionmodel_index_5e65a2bd_idx on search_passengerfareproductsectionmodel (cost=0.56..58,522,770.30 rows=261,100 width=51) (actual time=52,181.922..52,181.922 rows=1 loops=1)

  • Filter: (passenger_fare_product_segment_id = 1116373047)
  • Rows Removed by Filter: 26514185