explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6chf

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 283.414 5,618.321 ↑ 1.0 1 1

Aggregate (cost=357,478.90..357,478.91 rows=1 width=4) (actual time=5,618.320..5,618.321 rows=1 loops=1)

2. 5,197.520 5,334.907 ↑ 1.9 140,719 1

Bitmap Heap Scan on erccis_summary_occurrences o (cost=24,735.93..356,811.27 rows=267,055 width=4) (actual time=139.283..5,334.907 rows=140,719 loops=1)

  • Recheck Cond: (tetrad_geom && '0106000020110F0000020000000103000000010000000400000088ED724672401BC10F43AB97062759414E3F0B6E81571DC1C40F292632035941C50191D17AE819C104DFD90704FF584188ED724672401BC10F43AB970627594101030000000100000004000000B1A5895F54F41FC19B455ECD51F65841FEB32888195C20C1B1B41DE8BEDB58410935E0C75AF21EC19593758550E25841B1A5895F54F41FC19B455ECD51F65841'::geometry)
  • Rows Removed by Index Recheck: 1925336
  • Filter: _st_intersects(tetrad_geom, '0106000020110F0000020000000103000000010000000400000088ED724672401BC10F43AB97062759414E3F0B6E81571DC1C40F292632035941C50191D17AE819C104DFD90704FF584188ED724672401BC10F43AB970627594101030000000100000004000000B1A5895F54F41FC19B455ECD51F65841FEB32888195C20C1B1B41DE8BEDB58410935E0C75AF21EC19593758550E25841B1A5895F54F41FC19B455ECD51F65841'::geometry)
  • Rows Removed by Filter: 697610
3. 137.387 137.387 ↓ 1.0 838,329 1

Bitmap Index Scan on ix_erccis_summary_occurrences_tetrad_geom (cost=0.00..24,669.16 rows=801,167 width=0) (actual time=137.387..137.387 rows=838,329 loops=1)

  • Index Cond: (tetrad_geom && '0106000020110F0000020000000103000000010000000400000088ED724672401BC10F43AB97062759414E3F0B6E81571DC1C40F292632035941C50191D17AE819C104DFD90704FF584188ED724672401BC10F43AB970627594101030000000100000004000000B1A5895F54F41FC19B455ECD51F65841FEB32888195C20C1B1B41DE8BEDB58410935E0C75AF21EC19593758550E25841B1A5895F54F41FC19B455ECD51F65841'::geometry)"Total runtime: 5618.618 ms