explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4mkp

Settings
# exclusive inclusive rows x rows loops node
1. 0.157 0.528 ↑ 180,427.9 263 1

Sort (cost=23,457,334.37..23,575,965.73 rows=47,452,545 width=51) (actual time=0.504..0.528 rows=263 loops=1)

  • Sort Key: index, id
  • Sort Method: quicksort Memory: 61kB
2. 0.087 0.371 ↑ 180,427.9 263 1

Bitmap Heap Scan on search_passengerfareproductsectionmodel (cost=725,975.69..12,541,397.12 rows=47,452,545 width=51) (actual time=0.296..0.371 rows=263 loops=1)

  • Recheck Cond: (passenger_fare_product_segment_id = ANY ('{183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364}'::bigint[]))
  • Heap Blocks: exact=4
3. 0.284 0.284 ↑ 180,427.9 263 1

Bitmap Index Scan on search_passengerfareproductsectionmodel_a559e381 (cost=0.00..714,112.55 rows=47,452,545 width=0) (actual time=0.284..0.284 rows=263 loops=1)

  • Index Cond: (passenger_fare_product_segment_id = ANY ('{183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364}'::bigint[]))