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. 0.000 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. 2,108.638 807,106.581 ↓ 38.0 38 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. 819.191 50,699.400 ↓ 26.4 597,228 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. 960.954 960.954 ↑ 1.3 1,118 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. 48,919.255 48,919.255 ↑ 1.2 534 3,355

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. 754,298.543 754,298.543 ↓ 0.0 0 1,791,683

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