PostGIS  2.3.8dev-r@@SVN_REVISION@@

◆ _postgis_gserialized_sel()

Datum _postgis_gserialized_sel ( PG_FUNCTION_ARGS  )

Definition at line 2024 of file gserialized_estimate.c.

References _postgis_gserialized_joinsel(), estimate_selectivity(), FALSE, gbox_to_string(), PG_FUNCTION_INFO_V1(), pg_get_nd_stats_by_name(), text2cstring(), and text_p_get_mode().

Referenced by _postgis_gserialized_stats().

2025 {
2026  Oid table_oid = PG_GETARG_OID(0);
2027  text *att_text = PG_GETARG_TEXT_P(1);
2028  Datum geom_datum = PG_GETARG_DATUM(2);
2029  GBOX gbox; /* search box read from gserialized datum */
2030  float8 selectivity = 0;
2031  ND_STATS *nd_stats;
2032  int mode = 2; /* 2D mode by default */
2033 
2034  /* Check if we've been asked to not use 2d mode */
2035  if ( ! PG_ARGISNULL(3) )
2036  mode = text_p_get_mode(PG_GETARG_TEXT_P(3));
2037 
2038  /* Retrieve the stats object */
2039  nd_stats = pg_get_nd_stats_by_name(table_oid, att_text, mode, FALSE);
2040 
2041  if ( ! nd_stats )
2042  elog(ERROR, "stats for \"%s.%s\" do not exist", get_rel_name(table_oid), text2cstring(att_text));
2043 
2044  /* Calculate the gbox */
2045  if ( ! gserialized_datum_get_gbox_p(geom_datum, &gbox) )
2046  elog(ERROR, "unable to calculate bounding box from geometry");
2047 
2048  POSTGIS_DEBUGF(3, " %s", gbox_to_string(&gbox));
2049 
2050  /* Do the estimation */
2051  selectivity = estimate_selectivity(&gbox, nd_stats, mode);
2052 
2053  pfree(nd_stats);
2054  PG_RETURN_FLOAT8(selectivity);
2055 }
static ND_STATS * pg_get_nd_stats_by_name(const Oid table_oid, const text *att_text, int mode, bool only_parent)
Pull the stats object from the PgSQL system catalogs.
static int text_p_get_mode(const text *txt)
Utility function to see if the first letter of the mode argument is 'N'.
char * gbox_to_string(const GBOX *gbox)
Allocate a string representation of the GBOX, based on dimensionality of flags.
Definition: g_box.c:404
static float8 estimate_selectivity(const GBOX *box, const ND_STATS *nd_stats, int mode)
This function returns an estimate of the selectivity of a search GBOX by looking at data in the ND_ST...
char * text2cstring(const text *textptr)
#define FALSE
Definition: dbfopen.c:168
N-dimensional statistics structure.
Here is the call graph for this function:
Here is the caller graph for this function: