explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5uwu

Settings
# exclusive inclusive rows x rows loops node
1. 0.144 424,028.456 ↓ 12.0 12 1

GroupAggregate (cost=1,001.31..344,244.92 rows=1 width=12) (actual time=71,992.355..424,028.456 rows=12 loops=1)

  • Group Key: data_manager_hexgrid.id
2. 154,992.785 424,028.312 ↓ 115.0 115 1

Gather Merge (cost=1,001.31..344,244.81 rows=1 width=8) (actual time=71,992.347..424,028.312 rows=115 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 702.879 269,035.527 ↓ 38.0 38 3 / 3

Nested Loop (cost=1.28..343,244.67 rows=1 width=8) (actual time=38,283.889..269,035.527 rows=38 loops=3)

4. 273.064 16,899.800 ↓ 26.4 597,228 3 / 3

Nested Loop (cost=0.85..317,442.83 rows=22,595 width=8) (actual time=291.695..16,899.800 rows=597,228 loops=3)

5. 320.318 320.318 ↑ 1.3 1,118 3 / 3

Parallel Index Scan using data_manager_hexgrid_pkey on data_manager_hexgrid (cost=0.42..71,030.37 rows=1,400 width=4) (actual time=291.603..320.318 rows=1,118 loops=3)

  • Filter: (size = 250000)
  • Rows Removed by Filter: 146841
6. 16,306.418 16,306.418 ↑ 1.2 534 3,355 / 3

Index Scan using data_manager_gbifoccurrence_hexgrid_hexgrid_id_530aeca2 on data_manager_gbifoccurrence_hexgrid (cost=0.43..113.61 rows=624 width=8) (actual time=0.189..14.581 rows=534 loops=3,355)

  • Index Cond: (hexgrid_id = data_manager_hexgrid.id)
7. 251,432.848 251,432.848 ↓ 0.0 0 1,791,683 / 3

Index Scan using data_manager_gbifoccurrence_pkey on data_manager_gbifoccurrence u0 (cost=0.43..1.14 rows=1 width=4) (actual time=0.421..0.421 rows=0 loops=1,791,683)

  • Index Cond: (id = data_manager_gbifoccurrence_hexgrid.gbifoccurrence_id)
  • Filter: ((("edit_decimalLatitude")::numeric <@ '[-90.0,90.0)'::numrange) AND (("edit_decimalLongitude")::numeric <@ '[-180.0,180.0)'::numrange) AND (to_tsvector('english'::regconfig, concat(row_json)) @@ '''belgica'' & ''antarctica'''::tsquery))
  • Rows Removed by Filter: 1