explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IOVh

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 48,516.000 ↑ 1.0 21 1

Limit (cost=523,872.21..523,876.62 rows=21 width=353) (actual time=48,405.093..48,516.000 rows=21 loops=1)

2. 47.295 48,515.950 ↑ 3,053.2 21 1

GroupAggregate (cost=523,872.21..537,336.72 rows=64,117 width=353) (actual time=48,405.089..48,515.950 rows=21 loops=1)

3. 46,976.038 48,468.655 ↑ 36.2 17,719 1

Sort (cost=523,872.21..525,475.13 rows=641,167 width=353) (actual time=48,400.534..48,468.655 rows=17,719 loops=1)

  • Sort Key: species_group_name, species_scientific_name, species_vernacular_name
  • Sort Method: external merge Disk: 229584kB
4. 1,395.093 1,492.617 ↓ 1.0 647,778 1

Bitmap Heap Scan on erccis_summary_occurrences o (cost=16,669.47..146,453.06 rows=641,167 width=353) (actual time=99.499..1,492.617 rows=647,778 loops=1)

  • Recheck Cond: ((species_group_name)::text = 'bird'::text)
  • Rows Removed by Index Recheck: 51866
5. 97.524 97.524 ↓ 1.0 647,778 1

Bitmap Index Scan on ix_erccis_summary_occurrences_species_group_name (cost=0.00..16,509.18 rows=641,167 width=0) (actual time=97.524..97.524 rows=647,778 loops=1)

  • Index Cond: ((species_group_name)::text = 'bird'::text)"Total runtime: 51663.917 ms