postgres
diff --git a/‎src/backend/commands/subscriptioncmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/subscriptioncmds.c
+6-6Lines changed: 6 additions & 6 deletions b/‎src/backend/commands/subscriptioncmds.c
Copy file name to clipboardExpand all lines: src/backend/commands/subscriptioncmds.c
+6-6Lines changed: 6 additions & 6 deletions
diff --git a/‎src/test/subscription/t/026_stats.pl
Copy file name to clipboardExpand all lines: src/test/subscription/t/026_stats.pl
+20Lines changed: 20 additions & 0 deletions b/‎src/test/subscription/t/026_stats.pl
Copy file name to clipboardExpand all lines: src/test/subscription/t/026_stats.pl
+20Lines changed: 20 additions & 0 deletions
@@ -1646,6 +1646,12 @@ DropSubscription(DropSubscriptionStmt *stmt, bool isTopLevel)
 	ReplicationOriginNameForLogicalRep(subid, InvalidOid, originname, sizeof(originname));
 	replorigin_drop_by_name(originname, true, false);
 
+	/*
+	 * Tell the cumulative stats system that the subscription is getting
+	 * dropped.
+	 */
+	pgstat_drop_subscription(subid);
+
 	/*
 	 * If there is no slot associated with the subscription, we can finish
 	 * here.
@@ -1734,12 +1740,6 @@ DropSubscription(DropSubscriptionStmt *stmt, bool isTopLevel)
 	}
 	PG_END_TRY();
 
-	/*
-	 * Tell the cumulative stats system that the subscription is getting
-	 * dropped.
-	 */
-	pgstat_drop_subscription(subid);
-
 	table_close(rel, NoLock);
 }
 
 
@@ -267,6 +267,26 @@ sub create_sub_pub_w_errors
 	qq(f),
 	qq(Subscription stats for subscription '$sub1_name' should be removed.));
 
+# Get subscription 2 oid
+my $sub2_oid = $node_subscriber->safe_psql($db,
+	qq(SELECT oid FROM pg_subscription WHERE subname = '$sub2_name'));
+
+# Diassociate the subscription 2 from its replication slot and drop it
+$node_subscriber->safe_psql(
+	$db,
+	qq(
+ALTER SUBSCRIPTION $sub2_name DISABLE;
+ALTER SUBSCRIPTION $sub2_name SET (slot_name = NONE);
+DROP SUBSCRIPTION $sub2_name;
+			    ));
+
+# Subscription stats for sub2 should be gone
+is( $node_subscriber->safe_psql(
+		$db, qq(SELECT pg_stat_have_stats('subscription', 0, $sub2_oid))),
+	qq(f),
+	qq(Subscription stats for subscription '$sub2_name' should be removed.));
+$node_publisher->safe_psql($db,
+	qq(SELECT pg_drop_replication_slot('$sub2_name')));
 
 $node_subscriber->stop('fast');
 $node_publisher->stop('fast');