explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HpT5

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 0.091 ↓ 0.0 0 1

Delete on geometries (cost=0.29..30.17 rows=6 width=6) (actual time=0.089..0.091 rows=0 loops=1)

2. 0.047 0.047 ↑ 1.0 6 1

Index Scan using geometries_pkey on geometries (cost=0.29..30.17 rows=6 width=6) (actual time=0.023..0.047 rows=6 loops=1)

  • Index Cond: (id = ANY ('{110937,110938,110939,110940,110941,110942}'::bigint[]))
Planning time : 0.204 ms
Execution time : 35.039 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint geometry_tiles_geometry_id_fkey on geometries 14.024 ms 6 2.337 ms
for constraint grid_geometries_geometry_id_fkey on geometries 0.338 ms 6 0.056 ms
for constraint locks_geometry_id_fkey on geometries 0.260 ms 6 0.043 ms
for constraint feature_attribute_values_geometry_fkey on geometries 0.252 ms 6 0.042 ms
for constraint level_of_details_parent_fkey on geometries 0.265 ms 6 0.044 ms
for constraint level_of_details_child_fkey on geometries 0.187 ms 6 0.031 ms
for constraint geometry_hulls_geometry_id_fkey on geometries 0.328 ms 6 0.055 ms
for constraint geometries_subgeometry_of_fkey on geometries 14.820 ms 6 2.470 ms
for constraint versions_geometry_id_fkey on geometries 0.292 ms 6 0.049 ms
for constraint voxet_region_names_voxet_id_fkey on geometries 0.225 ms 6 0.037 ms
for constraint additional_feature_metadata_geometry_id_fkey on geometries 0.250 ms 6 0.042 ms
for constraint geometry_tiles_version_id_fkey on versions 2.110 ms 1 2.110 ms
for constraint locks_parent_version_fkey on versions 0.072 ms 1 0.072 ms
for constraint geometry_hulls_version_id_fkey on versions 0.071 ms 1 0.071 ms
for constraint property_tiles_geometry_tile_id_fkey on geometry_tiles 0.957 ms 5 0.191 ms
for constraint region_flag_tiles_geometry_tile_id_fkey on geometry_tiles 0.225 ms 5 0.045 ms