explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bkLa

Settings
# exclusive inclusive rows x rows loops node
1. 0.088 0.169 ↓ 0.0 0 1

Delete on geometries (cost=0.42..30.61 rows=6 width=6) (actual time=0.166..0.169 rows=0 loops=1)

2. 0.081 0.081 ↑ 1.2 5 1

Index Scan using geometries_pkey on geometries (cost=0.42..30.61 rows=6 width=6) (actual time=0.059..0.081 rows=5 loops=1)

  • Index Cond: (id = ANY ('{120692,120693,120694,120695,120686,120697}'::bigint[]))
Planning time : 0.325 ms
Execution time : 28,060.475 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint geometry_tiles_geometry_id_fkey on geometries 1,568.392 ms 6 261.399 ms
for constraint grid_geometries_geometry_id_fkey on geometries 0.694 ms 6 0.116 ms
for constraint locks_geometry_id_fkey on geometries 0.277 ms 6 0.046 ms
for constraint feature_attribute_values_geometry_fkey on geometries 0.291 ms 6 0.048 ms
for constraint level_of_details_parent_fkey on geometries 0.286 ms 6 0.048 ms
for constraint level_of_details_child_fkey on geometries 0.221 ms 6 0.037 ms
for constraint geometry_hulls_geometry_id_fkey on geometries 0.349 ms 6 0.058 ms
for constraint geometries_subgeometry_of_fkey on geometries 60.944 ms 6 10.157 ms
for constraint versions_geometry_id_fkey on geometries 0.668 ms 6 0.111 ms
for constraint voxet_region_names_voxet_id_fkey on geometries 0.245 ms 6 0.041 ms
for constraint additional_feature_metadata_geometry_id_fkey on geometries 0.218 ms 6 0.036 ms
for constraint geometry_tiles_version_id_fkey on versions 239.572 ms 1 239.572 ms
for constraint locks_parent_version_fkey on versions 0.172 ms 1 0.172 ms
for constraint geometry_hulls_version_id_fkey on versions 0.074 ms 1 0.074 ms
for constraint property_tiles_geometry_tile_id_fkey on geometry_tiles 26,184.664 ms 58 451.460 ms
for constraint region_flag_tiles_geometry_tile_id_fkey on geometry_tiles 2.701 ms 58 0.047 ms