explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDki

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 32,871.164 ↑ 1.3 44 1

Sort (cost=187,184.59..187,184.73 rows=56 width=27) (actual time=32,871.154..32,871.164 rows=44 loops=1)

  • Sort Key: a.name
  • Sort Method: quicksort Memory: 28kB
2. 1,077.805 32,871.066 ↑ 1.3 44 1

HashAggregate (cost=187,182.40..187,182.96 rows=56 width=27) (actual time=32,871.055..32,871.066 rows=44 loops=1)

  • Group Key: a.name, a.area_id, a.type
3. 1,003.496 31,793.261 ↑ 11.2 1,783,093 1

Nested Loop (cost=12.88..37,554.08 rows=19,950,443 width=27) (actual time=32.444..31,793.261 rows=1,783,093 loops=1)

4. 0.069 0.069 ↑ 1.0 56 1

Seq Scan on area a (cost=0.00..9.56 rows=56 width=25,244) (actual time=0.008..0.069 rows=56 loops=1)

5. 30,042.544 30,789.696 ↓ 530.7 31,841 56

Bitmap Heap Scan on policy_data pd (cost=12.88..669.84 rows=60 width=32) (actual time=16.221..549.816 rows=31,841 loops=56)

  • Recheck Cond: (point_geom_4326 && a.polygon_4326)
  • Filter: ((internal_company_id = 14) AND _st_intersects(point_geom_4326, a.polygon_4326))
  • Rows Removed by Filter: 52168
  • Heap Blocks: exact=359493
6. 747.152 747.152 ↓ 276.2 90,326 56

Bitmap Index Scan on policy_data_geometry_gix (cost=0.00..12.87 rows=327 width=0) (actual time=13.342..13.342 rows=90,326 loops=56)

  • Index Cond: (point_geom_4326 && a.polygon_4326)
Planning time : 0.849 ms
Execution time : 32,871.505 ms