explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SGK9 : Optimization for: plan #6chf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,356.751 3,912.020 ↑ 1.0 1 1

Aggregate (cost=158,655.96..158,655.97 rows=1 width=4) (actual time=3,912.019..3,912.020 rows=1 loops=1)

2. 2,431.718 2,555.269 ↓ 1.0 838,329 1

Bitmap Heap Scan on erccis_summary_occurrences o (cost=24,869.46..156,653.04 rows=801,167 width=4) (actual time=125.046..2,555.269 rows=838,329 loops=1)

  • Recheck Cond: (tetrad_geom && '0106000020110F0000020000000103000000010000000400000088ED724672401BC10F43AB97062759414E3F0B6E81571DC1C40F292632035941C50191D17AE819C104DFD90704FF584188ED724672401BC10F43AB970627594101030000000100000004000000B1A5895F54F41FC19B455ECD51F65841FEB32888195C20C1B1B41DE8BEDB58410935E0C75AF21EC19593758550E25841B1A5895F54F41FC19B455ECD51F65841'::geometry)
  • Rows Removed by Index Recheck: 1925336
3. 123.551 123.551 ↓ 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=123.551..123.551 rows=838,329 loops=1)

  • Index Cond: (tetrad_geom && '0106000020110F0000020000000103000000010000000400000088ED724672401BC10F43AB97062759414E3F0B6E81571DC1C40F292632035941C50191D17AE819C104DFD90704FF584188ED724672401BC10F43AB970627594101030000000100000004000000B1A5895F54F41FC19B455ECD51F65841FEB32888195C20C1B1B41DE8BEDB58410935E0C75AF21EC19593758550E25841B1A5895F54F41FC19B455ECD51F65841'::geometry)